Concurrent Program Registration

Overview:

• Develop a report or PL/SQL Package to register as a concurrent program
• Create Executable: Link it to Report file(.rdf) or PL/SQL Package created
• Create Concurrent Program: Link to it executable defined in previous step
• Enter Parameters and link Value Sets
• Assign the registered Conc.Prog to a request group

Creating Executable:

Navigation: Login into Oracle Applications --> Goto Application Developer Responsibility --> Concurrent --> Executable

Here we will register a oracle report as a concurrent progam

FIELDS:

• Executable: This is User Understandable Name
• ShortName: This is Unique and for system reference
• Application: Under which application you want to register this Conc.Program
• Description: Description
• Execution Method: Based on this field, Your file has to placed in respective directory or database.
• Execution File Name: This is the actual Report file name. If you register a PL/SQL Procedure in a package you have to give the packagename.procedure. You dont need to specify any parameters in procedure here.

Action: Save

Create Concurrent Program:

Navigation: Application Developer --> Concurrent --> Program

FIELDS:

• Program: User Understandable Program Name
• Short Name: This should be unique name and for system reference
• Application: Enter the application under which you want to register this conc.prog
• Executable Name: Enter the User Understandable Executable Name
• Method: This will be populated automatically from Executable Definition
• Output Format: Select the format of the output you want
• Output Style: Select A4 to print on A4 Paper
• Printer: You can default any printer or you can ente while submitting concurrent program.

DEFINE PARAMETERS AND VALUE SETS

Navigation: click on Parameters button in above screen

FIELDS:

• Seq: Its always better to enter sequences in multiple of 5 or 10. So that you can insert any additional parameters if you want later in middle.
• Parameter: Name the Parameter Field. This is for system reference
• Description: You can see this discription While submitting the conc.prog.
• Valueset: "15 Charachers" is the standard value set for Character input parameters
• Default Type: This field is not mandatory. If you want to default any particular value to save time while submitting the concurrent program you can do so here.
• Prompt: This is the actual message displayed while submitting the conc.prog
• Token: This is used to link this parameter to the parameter defined in actual report file(.rdf)

Action: Save

Assing this Concurrent Program to a request group:

Navigation: Switch to "System Administrator" Responsibility --> Security --> Responsibility --> Request

Action: Open/Double click

Action: Press F11

Action: CTRL+F11

Action: Select the First record in the "Requests" and then File --> New

Action: Enter Your User Readable Name of your concurrent program

Action: Save

Now Your Concurrent Program is ready to use from the responsibilities having " Purchasing Reports" as Request Group.