Creating a Concurrent Program with default Parameter Value Set
By Jag - March 02, 2014
Creating a Concurrent Program with default Parameter Value Set:
Use the following SQL script :
“select EMPNO, ENAME, SAL, DEPTNO from emp where deptno=&1;” and name it as “emp_param_default.sql” and place itD:oracleVISappsapps_stapplap12.0.0sql.
Define the Concurrent Program Executable
Navigate to System administrator>> Concurrent>> Program>> Executable.
Create a concurrent program executable with name “emp_param_default”.
Creating a Concurrent Program Executable
System Administrator>> Concurrent >> Program>> Define.
Defining a Concurrent Program
Click Parameters.
Enter the data:
Seq = 10, Parameter = deptno, Value Set = 15 Number ( or any number format)
SAVE.
Defining Parameters
Attach this concurrent program to a Request group.
System Administrator>> Security>> Responsibility>> Request.
F11 and enter ‘All Reports‘ then ctrl+F11.
Ensure that Application is PAYABLES.
Go to requests and click New Icon in the toolbar to create a new row as shown in the screen.
SAVE.
Adding Concurrent Program to a Request Group
Run the concurrent program
Switch Responsibility (Toolbar>>Click Switch responsibility icon) to Payables.
View>> Requests>> Submit a New Request>>
Submitting a Concurrent request
Single Request
In the SRS (Standard Request Submission) screen, enter the name of the concurrent program.
Click Submit. Another Request ..NO, Click Find and observe the status. Click View Output.
DONE.
The output would look like this:
Output of a Concurrent Program
Using Table Value Set for Parameters in a SQL concurrent program:
We have DEPT table. Register it with Apps:
BEGIN
AD_DD.REGISTER_TABLE (‘FND’,'DEPT’,'T’);
END;
Register the columns
BEGIN
AD_DD.REGISTER_COLUMN (‘FND’, ‘DEPT’,'DEPTNO’, 1, ‘NUMBER’, 20, ‘Y’, ‘Y’);
AD_DD.REGISTER_COLUMN (‘FND’, ‘DEPT’,'DNAME’, 2, ‘VARCHAR2′, 20, ‘Y’, ‘Y’);
AD_DD.REGISTER_COLUMN (‘FND’, ‘DEPT’, ‘LOC’, 3, ‘VARCHAR2′, 20, ‘Y’, ‘Y’);
END;
Open the Apps go to System Administrator Responsibility and Create a Table value set by name “PARAMS_TABLE”. Select validation type as tableand click edit information button and enter values as shown:
Creating a Value Set
Validation table info
Create a SQL script:
PARAMS_TABLE.sql
select * from emp where deptno=&1;
and place it in “D:oracleVISappsapps_stapplap12.0.0sql”
Create Concurrent Program Executable
In The Apps go to System Administrator>> Concurrent>> Executable
and Create SQL Script con prg. Executable
Creating Concurrent Program Executable
Define the concurrent program
System Administrator>> Concurrent>> Program>> Define.
Defining a Concurrent Program
Click on parameters
Defining Parameters
Attach this concurrent program to a Request group.
System Administrator>> Security>> Responsibility>> Request.
F11 and enter All Reports then ctrl+F11.
Ensure that Application is PAYABLES.
Navigate to requests and click New Icon in the toolbar to create a new row as shown in the screen.
SAVE.
Attaching Concurrent Program to a Request Group
Run the concurrent program
Switch Responsibility (Toolbar>>Click Switch responsibility icon) to Payables.
View>> Requests>> Submit a New Request>> Single Request
In the SRS (Standard Request Submission) screen, enter the name of the concurrent program.
Click Submit. Another Request…NO, Click Find and observe the status. Click View Output.
DONE.
0 comments