INTERVIEW QUESTIONS ORACLE APPS ORACLE APPS BASICS DETAILS

Question: How to register Form , Reports?

Answer: Registering Oracle Reports: <br> <br>Step 1: Register a concurrent program executable <br>Navigate to the Define Executable form (AOL Reference manual pg 9-84) <br>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. <br>For spawned programs, the file must be in the bin directory, for Oracle Reports the rdf file must be in the srw directory. <br>For PLSQL concurrent programs, put the name of the stored procedure. <br>Step 2: Define the concurrent program <br>Navigate to the Define Concurrent Program form (AOL Reference manual pg 9-87) <br>This form links a concurrent program to the executable you just defined, as well as defines the programs parameters, incompatibilities, and other options. <br>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. <br>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. <br>Step 3: Add the concurrent program to a Report Group <br>First you will need to find the name of the Report Group to use. <br>Go to Security->Responsibility and query the responsibility you want to run the program with. <br>It should show a Report Group name. Query this name in Security->Responsibility->Report <br>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. <br> <br>Forms Registration <br> <br>1. Develop the form in Developer 2000. <br>2. Save the FORM and move it to UNIX. [Form to be moved to $CUSTOM_TOP/forms/US] <br>3. Define the FORM in Application Developer <br>4. Define FORM as FUNCTION. <br>5. Identify MENU, where the FORM to be attached. [SysadminResponsibilityDefine] <br>6.Copy the above MENU and go to Application Developer and query on MENU tab <br>

Registering Oracle Reports: <br> <br>Step 1: Register a concurrent program executable <br>Navigate to the Define Executable form (AOL Reference manual pg 9-84) <br>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. <br>For spawned programs, the file must be in the bin directory, for Oracle Reports the rdf file must be in the srw directory. <br>For PLSQL concurrent programs, put the name of the stored procedure. <br>Step 2: Define the concurrent program <br>Navigate to the Define Concurrent Program form (AOL Reference manual pg 9-87) <br>This form links a concurrent program to the executable you just defined, as well as defines the programs parameters, incompatibilities, and other options. <br>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. <br>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. <br>Step 3: Add the concurrent program to a Report Group <br>First you will need to find the name of the Report Group to use. <br>Go to Security->Responsibility and query the responsibility you want to run the program with. <br>It should show a Report Group name. Query this name in Security->Responsibility->Report <br>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. <br> <br>Forms Registration <br> <br>1. Develop the form in Developer 2000. <br>2. Save the FORM and move it to UNIX. [Form to be moved to $CUSTOM_TOP/forms/US] <br>3. Define the FORM in Application Developer <br>4. Define FORM as FUNCTION. <br>5. Identify MENU, where the FORM to be attached. [SysadminResponsibilityDefine] <br>6.Copy the above MENU and go to Application Developer and query on MENU tab <br> Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question