Sri

• Aug 15th, 2005

 

Registering Oracle Reports: 
 
Step 1: Register a concurrent program executable  
Navigate to the Define Executable form (AOL Reference manual pg 9-84)  
This determines the type of program being run,ie an Oracle Report. Fill in the executable name, application and execution method. For the Execution File, fill in just the filename. The concurrent manager will look in the appropriate directory under the application's top directory.  
For spawned programs, the file must be in the bin directory, for Oracle Reports the rdf file must be in the srw directory.  
For PLSQL concurrent programs, put the name of the stored procedure.  
Step 2: Define the concurrent program  
Navigate to the Define Concurrent Program form (AOL Reference manual pg 9-87)  
This form links a concurrent program to the executable you just defined, as well as defines the programs parameters, incompatibilities, and other options.  
Enter the concurrent program name, application, short name and description. Check Standard Submission if you want to be able to submit this program from the Standard Report Submission form.  
Enter the name of the executable you defined and any report information if necessary. Also define any parameters your program needs here and any incompatibilities.  
Step 3: Add the concurrent program to a Report Group  
First you will need to find the name of the Report Group to use.  
Go to Security->Responsibility and query the responsibility you want to run the program with.  
It should show a Report Group name. Query this name in Security->Responsibility->Report  
Add your new program to the list of available programs. Now when you go to submit a request with this responsibility, you will be able to submit your custom program. 
 
Forms Registration  
 
1. Develop the form in Developer 2000. 
2. Save the FORM and move it to UNIX. [Form to be moved to $CUSTOM_TOP/forms/US] 
3. Define the FORM in Application Developer 
4. Define FORM as FUNCTION. 
5. Identify MENU, where the FORM to be attached. [SysadminResponsibilityDefine] 
6.Copy the above MENU and go to Application Developer and query on MENU tab