iWay Application Adapter for Oracle E-Business Suite supports running what was formerly known as the Oracle Applications concurrent program function using the adapter concurrent programs agent. Currently, this function is called the Submit Request.
The Submit Request submits a request that runs a concurrent program. Concurrent programs perform several functions, including moving data. For example, if you wish to move data to a base table:
Each interface table has a Submit Request associated with it.
The Submit Request moves the data from the interface table to the base table.
The Submit Request can call a concurrent program synchronously or asynchronously. It submits the concurrent program to a concurrent manager that controls background processing in Oracle E-Business Suite.
To run the Submit Request:
You do this only once for a Submit Request. This covers all Submit Requests to be run from a given Oracle E-Business Suite connection.
You do this only once for a Submit Request. This covers all Submit Requests to be run from one Oracle E-Business Suite connection.
To install the Submit Request, you must perform the following additional steps when installing the adapter:
<iway_home>\etc\setup
Note: Contact Information Builders Customer Support Services to obtain the Concurrent.ora script.
Note: As part of the installation process, you must run the Concurrent.ora script. You can run it at any time before creating the service for the Submit Request. For information on how to run the Concurrent.ora script, see How to Run the Concurrent.ora Script.
As part of the installation process, you must run the Concurrent.ora script. You can run it at any time before creating the service for the Submit Request. The computer on which you run the script must have:
To run the Concurrent.ora script:
You can also use the iWay package facility to install the Oracle Applications package, which contains the script file. For more information, see the iWay Service Manager User's Guide.
For Windows Platforms Only:
In the CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED IwayConc... section, the path to the cmd.exe file must be set correctly at finalCommand[0]. For example:
finalCommand[0] = "C:\\WINDOWS\\system32\\cmd.exe";
For Windows and UNIX Platforms:
In the CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED IwayConc... section, the path to the ConcSub.exe file must be appended before concCommand at finalCommand[3]. For example:
finalCommand[3] = "D:\\oracle\visappl\\fnd\\11.5.0\\bin" + concCommand;
SQLPLUS APPS/password@database @Concurrent.ora
where:
Is the password associated with the APPS user ID.
Is a value of the tnsnames entry (in the tnsnames.ora file) that points to the Oracle E-Business Suite database instance.
To adjust the system path and verify CONCSUB:
$FND_TOP\bin
You can add it at any time before creating the service for the Submit Request.
If CONCSUB is missing, contact your Oracle E-Business Suite administrator.
$FND_TOP is the location of the Oracle E-Business Suite foundation directory. Its value is set in the vis.env (or prod.env) file located under the oraclehome\visappl directory.
You must create a pair of request and response service schemas for the Submit Request. You need only do this once for each Oracle E-Business Suite connection from which you run these programs. This satisfies the requirement for all Submit Requests that are accessed using that connection.
To generate the request and response schemas:
A table appears on the right.
You have finished generating the service schemas.
Generating a web service for the submit request is identical to configuring other Oracle E-Business Suite services, except that some of the configuration parameters differ.
The following table lists and describes the service parameters for the submit request.
Parameter |
Description |
---|---|
Select |
Submit Request. |
Userid |
User ID for the Oracle E-Business Suite database. |
Password |
Password associated with the user ID. |
Host |
Name of the server where the Oracle E-Business Suite database instance resides. |
Port |
Port number on which the database is listening. |
ServiceId |
Unique name, comprised of the database name and domain name, that identifies the database. |
TnsName |
Logical name of the Oracle E-Business Suite database instance. |
To create a web service:
The following image shows the expanded submit_request service node on the left and a property table for the submit request service that opens on the right.
The Operations menu becomes available on the right.
The Create Web Service for submit_request pane opens on the right and provides the option to create a new service or use an existing service as shown in the following image.
The right pane prompts you for descriptive information about the service, as shown in the following image.
The right pane then prompts you to identify a method for the service, as shown in the following image.
You can use an XML editor to create the service request document. For a sample submit request document, see How to Test the Submit Request.
After you create a web service and a request document, you can verify that you correctly configured the service for the Submit Request. After you create a service, the test pane appears on the right.
To test the Submit Request service:
The response document appears on the right.
The submit_response_id returned in the reply is the request id returned from the concsub command. This request id can be used through Oracle E-Business Suite to monitor the status of the concurrent manager program instance that was invoked.
You have completed the testing of the Submit Request service.
<?xml version="1.0" encoding="UTF-8"?> <ORACLE> <submit_request> <resp_appl_shrtnm>SYSADMIN</resp_appl_shrtnm> <responsibility>System Administrator</responsibility> <username>SYSADMIN</username> <wait>N</wait> <prog_appl_shrtnm>WIP</prog_appl_shrtnm> <program>WICTMS</program> <parm>3993</parm> <parm>0</parm> <parm>1</parm> </submit_request> </ORACLE>
iWay Software |