In the following integration interfaces belonging to a batch, you must use an existing Group ID.
To use an existing Group ID in an integration interface:
Set OA_USE_EXISTING_GROUP_ID IKM option to Yes
Provide the Group ID Name in the OA_GROUP_ID_NAME IKM option.
In the integration interface mapping, select the flag UD1 for all the columns you wish to load with the
Group ID value and set the mapping value to 0.
In the last integration interface that loads a batch of interface tables, you may delete a Group ID that is no longer necessary.
To delete an existing Group ID:
Choose the OA_REMOVE_GROUP_ID option
Provide the Group ID Name in the OA_GROUP_ID_NAME option.
In the integration interface mapping, select the flag UD1 for all the columns of the interface table you
wish to load with the Group ID value and set the mapping value to 0.
Note: The Group IDs are stored in an SNP_OA_GROUP table that is created in the work schema specified in the physical schema that points to the Oracle Applications Interface tables. The Group ID is referenced in Oracle Data Integrator by a unique Group ID Name.
Executing an OpenInterface program
In the Oracle Data Integrator integration interfaces, when a set of interface tables is loaded, it is necessary to call an OpenInterface program in order to validate and process the data in the E-Business Suite interface tables. You can use an existing Group ID in this call (see Use an existing Group ID), or create it (see Create a Group ID) in the same integration interface, if the OpenInterface only contains a single table. The execution of the OpenInterface program is started in the last integration interface of a package. This integration interface populates a set of OpenInterface tables and usually deletes the Group ID, if no longer needed.
To execute an OpenInterface Program:
Set the SUBMIT_PROGRAM option to YES
Provide the name of the program to call in the OA_PROGRAM option
Note: For a list of available OpenInterface programs and their parameters, please refer to the E-Business Suite module API and OpenInterface documentation or the E-Business Suite Repository.
Specify the program parameters in the OA_ARGUMENTS option. The parameters are specified in the following format: argument_name => 'argument value', argument_name => 'argument value’ ... If one argument must take the value of the Group ID, you must then specify argument Name => v_group_id
You must also specify the context parameters for the session that will execute the program by setting the values of the following options:
OA_USER_NAME : E-Business Suite User Name OA_REPONSIBILITY : E-Business Suite Responsibility Name OA_LANGUAGE : Language used for the responsibility OA_APPLICATION : Application to which the responsibility belongs
Knowledge Modules Reference Guide