Oracle E-Business Suite Interface Connector

Back Next

FAQ

How to create a new user in the database?: A new user gets the access to read all the base tables or views, and write to all the interface tables in a
.ini
file.; Perform the following steps to create a new user in the database:
Connect to the database as
sysdba
.
Create a user name in the
<username>
format and set a password in the
<password>
format.
Grant session to the user.

How to grant different privileges to a user?: Connect to the database as
sysdba
.
Enter the following to grant different privileges to a user:
GRANT SELECT ON [Schema].[Table] TO [User} GRANT INSERT ON [Schema].[Table] TO [User]

How to configure the .ini file with parameters?: A user must specify the list of interface tables and programs associated to the
.ini
file.
Open the
Application Developer
.
Navigate to
Concurrent
Program
.
The following image shows the
Concurrent Program
page:

Specify the value of the
Program
field.
Under the
Executable
session, specify the value of the
Name
field.
Click
Parameters
.
The following image shows the
Parameters
page:

Enter the values of the
Parameter
fields for the
.ini
files.

How to set the MORG ID parameter?: We can set the
MORG ID
parameter in two ways:
Select the program and enable the
Operating Unit
field, you will get the
MORG ID
in the
Parameter
field.
The following image shows the
Submit Request
page where you can obtain the
MORG ID
parameter:

Run the following command:
Select MULTI_ORG_CATEGORY from FND_CONCURRENT_PROGRAMS where concurrent_program_name=<<ProgramShortName Ex: RACUST as input>>

If the value of the
MULTI_ORG_CATEGORY
is
S
, you will get the
MORG ID
in the
Parameter
field.