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.
The Oracle Concurrent Program activity provides the following functions:
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. |
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. |
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:
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. |
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.
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.
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.
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: