Oracle Concurrent Program

You can use the Oracle Concurrent Program activity to populate Oracle interface tables, execute Concurrent Programs, and retrieve status information about the execution.

You can use the Oracle Concurrent Program activity to inspect the Integration Repository for the schema of the interface tables of the selected Concurrent Programs as well as the parameters required to execute the Concurrent Program, and to present this information in a user interface for configuration.

Note: A comparison between Oracle Concurrent Program and Custom Concurrent Program is provided in Oracle Concurrent Program and Custom Concurrent Program Comparison.

The Oracle Concurrent Program activity provides the following functions:

  • At design time

    • Loads Concurrent Program parameters from the FND table.
    • Loads Inbound Interface Tables or Views from Oracle Integration Repository.
    • Saves the information to a file.
  • At run time

    • Loads Concurrent Program parameters and Interface Tables or Views from the file.
    • Uses JDBC to insert data into Interface Tables or Views.
    • Uses JDBC to submit a Concurrent Program request.
Note: Oracle Integration Repository is shipped with Oracle E-Business Suite 12.0.x, 12.1.x, and 12.2.x; therefore, Oracle Concurrent Program can be used in these versions. See Introduction to Oracle Integration Repository for more details.

General

In the General tab, you can establish a connection to an Oracle E-Business Suite server, specify the language, concurrent program name, responsibility name, and user name, and set the check interval and total amount of time for checking the result of executing the Concurrent Program.

The General tab contains the following fields:

Field Module Property? Description
Name No The name of the resource.

The default is OracleConcurrentProgram.

Shared Connection Yes A shared configuration resource containing the Oracle E-Business Suite connection information.

To select a shared connection resource, click the Choose/Create Default Resource icon. All usable connections are listed in the opened dialog. Select one to apply to your current activity. If no matching connection resource is found, click Create Shared Resource to create one. See Oracle E-Business Suite Connection for more details.

Note: Before running the Oracle Concurrent Program activity, ensure that the plug-in user name that you specified in the Shared Connection is correct.
Language No The language in which the Oracle E-Business Suite user interface is shown.

Click Search Language or the text field. Then, enter a part of the language name in the opened dialog or leave the text field empty, and click Search. All languages that are installed in Oracle E-Business Suite and match the search criteria are listed in the opened dialog. Select a language in the opened dialog, and click OK. The contents of the concurrent program name, responsibility name, and output change accordingly.

Concurrent Program Name No Programs that can be called by a concurrent manager.

Click Search Concurrent Program Name or the text field. Then, enter a part of the concurrent program name in the opened dialog or leave the text field empty, and click Search. Select a Concurrent Program from the Concurrent Program List dialog, and click OK.

Responsibility Name No A responsibility is a level of authority in Oracle E-Business Suite.

You can only access the functions and data specified by the selected responsibility.

Click Search Responsibility Name or the text field. Then, enter a part of the responsibility name in the opened dialog or leave the text field empty, and click Search. Select a Concurrent Program from the Concurrent Program List dialog, and click OK.

User Name No The name of the user whose information is stored in Oracle E-Business Suite.

Click Search User Name or the text field. Then, enter a part of the user name in the opened dialog or leave the text field empty, and click Search. Select a user name from the User Name List dialog, and click OK.

Concurrent Request No If this check box is selected, the plug-in inserts records into interface tables, and submits the concurrent request. Otherwise, the plug-in only inserts records into interface tables.
Wait for Response No Select this check box if you want the Concurrent Program to retrieve REQUEST_ID, PHASE, STATUS, and MESSAGE information, which are shown in the Output tab. If this check box is cleared, the response time becomes shorter, but only REQUEST_ID is retrieved.
Check Interval (s) Yes The time interval for checking the result of executing the Concurrent Program.

The default is 15.

Note: When running the Oracle Concurrent Program activity, if the total waiting time that you set for checking the result of the Concurrent Program activity is shorter than the check interval, the plug-in still checks the result once.
Wait Time (s) Yes The total amount of time allowed for checking the result of executing the Concurrent Program.

The time set in this field should be a multiple of the time set in the Check Interval (s) field. The default is 0, which means the plug-in waits until the Concurrent Program execution is completed.

Generate SQL Script No After configuring the Oracle Concurrent Program activity, click Generate SQL Script. The scripts to be generated are displayed in the opened dialog. Click Generate, and the following two SQL scripts are created in the TIBCO_HOME\bw\palettes\oracleebs\version_number\sql directory:
  • ProcessName_ActivityName_ConcurrentProgramName.sql
  • ProcessName_ActivityName_ConcurrentProgramName_undo.sql

Run the ProcessName_ActivityName_ConcurrentProgramName.sql script in the connected Oracle database before starting the process.

The ProcessName_ActivityName_ConcurrentProgramName.sql script is used to grant privileges to the plug-in user so that the plug-in user can access the objects being configured. The plug-in uses the apps user entered in the Oracle E-Business Suite Connection resource to get the information to generate this script. After this script is executed, the plug-in user can access the tables and procedures configured for the activity.

The script with the _undo suffix reverses the granted privileges and undoes the changes to the database. With this operation, you can cleanse the privileges for objects that are no longer used by obsolete or unwanted activities.

Note: If the execution of the Concurrent Program takes a significant amount of time, you can clear the Wait for Response check box, and just get REQUEST_ID in the Output tab. Or you select the Wait for Response check box, and set the Wait Time (s) field to a limited time; in this case, the Concurrent Program returns the output data no matter whether the execution of the Concurrent Program is completed or not.

Description

In the Description tab, you can enter a short description for the Oracle Concurrent Program activity.

Concurrent Program Details

In the Concurrent Program Details tab, you can view the procedures in the plug-in user schema and the related interface tables or views (if they exist).

Input

In the Input tab, you can view the input data for the Oracle Concurrent Program activity. The parameters in the OracleConcurrentProgram-input column correspond to those shown in the Concurrent Program Details tab, with the following exceptions: application, program, description, start_time, and sub_request.

Note: Select the Concurrent Request check box in the General tab to show FND_REQUEST.SUBMIT_REQUEST.

The ResponsibilityName and UserName are dynamic parameters. They are configured in the General tab. You can also change the two parameters in the Input tab during run time.

Note: The parameter settings in the Input tab takes precedence over those in the General tab.

Output

In the Output tab, you can find the output information of the Oracle Concurrent Program activity. If the Wait for Response check box is selected in the General tab, the REQUEST_ID, PHASE, STATUS, and MESSAGE information are all displayed in the Output tab. Otherwise, only REQUEST_ID is retrieved.

Note: If you clear the Concurrent Request check box in the General tab, the output is empty.

Fault

In the Fault tab, you can find the error messages of the Oracle Concurrent Program activity.

See Plug-in Error Codes for more information about error messages and corrective actions to take.

The Fault tab lists the following error messages:

Fault Thrown When ...
OracleEBSPaletteAQConnectionException The AQ Connection does not initialize.

A JMSException happens during an incoming message delivery.

OracleEBSPaletteConnectionNotFoundException The connection cannot be created.
OracleEBSPaletteSQLException An SQL Exception occurs.