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. 1. Connect to the database as sysdba.
2. 2. Create a user name in the <username> format and set a password in the <password> format.
3. 3. Grant session to the user.

How to grant different privileges to a user?

1. 1. Connect to the database as sysdba.
2. 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. 1. Open the Application Developer.
2. 2. Navigate to Concurrent > Program.
The following image shows the Concurrent Program page:

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

6. 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.