Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Oracle E-Business Suite Interface Connector

Oracle E-Business Suite Interface Connector

FAQ

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:
  1. Connect to the database as
    sysdba
    .
  2. Create a user name in the
    <username>
    format and set a password in the
    <password>
    format.
  3. Grant session to the user.
How to grant different privileges to a user?
  1. Connect to the database as
    sysdba
    .
  2. 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.
  1. Open the
    Application Developer
    .
  2. Navigate to
    Concurrent
    Program
    .
    The following image shows the
    Concurrent Program
    page:
  3. Specify the value of the
    Program
    field.
  4. Under the
    Executable
    session, specify the value of the
    Name
    field.
  5. Click
    Parameters
    .
    The following image shows the
    Parameters
    page:
  6. 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.

0 COMMENTS

We’d like to hear from you!