March 5, 2010

Concurrent Program Registration

 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

 
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.



 








































No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...