A. Report Developed Using Report Builder
1. Create Report using Report Builder.
2. Place Report Definition file in the module specific directory.
3. Create an Executable for report definition file.
4. Create Concurrent program to that Executable.
5. Add Report Parameters if any in Parameter window.
6. Attach the concurrent program to request group.
B. Registration of PL/SQL with Parameter
1. Create the procedure in the module specific schema.
2. Create a public synonym for that procedure in the Apps schema.
3. Create the executable for that procedure.
4. Create a concurrent program.
5. Add Report Parameters if any in Parameter window.
6. Attach the concurrent program to that procedure.
Note: There are two mandatory parameters 1. Errbuf 2. Retcode. Any parameter
which are to be passed should be succeeded with these two parameters and have to be
registered. When calling the procedure, these two parameters are not mentioned.
1. Create Report using Report Builder.
2. Place Report Definition file in the module specific directory.
3. Create an Executable for report definition file.
4. Create Concurrent program to that Executable.
5. Add Report Parameters if any in Parameter window.
6. Attach the concurrent program to request group.
B. Registration of PL/SQL with Parameter
1. Create the procedure in the module specific schema.
2. Create a public synonym for that procedure in the Apps schema.
3. Create the executable for that procedure.
4. Create a concurrent program.
5. Add Report Parameters if any in Parameter window.
6. Attach the concurrent program to that procedure.
Note: There are two mandatory parameters 1. Errbuf 2. Retcode. Any parameter
which are to be passed should be succeeded with these two parameters and have to be
registered. When calling the procedure, these two parameters are not mentioned.
No comments:
Post a Comment