Steps
1. Concurrent executable creations.
2. Concurrent program definitions & adding parameters.
3. Attach this program into request group.
4. Develop the oracle reports as per requirements.
5. Move the reports into $XXCUSTOM_TOP/reports/US.
6. Run and verify the report output. (concurrent program)
Steps in detail
1. Concurrent executable creations.
Navigation: Application Developer > Concurrent > Executable
Enter the valid values for the “Executable, short name, application, execution method, execution file name ”
Execution methods
1. Oracle Reports – used for the RDF reports.
2. Host – used for shell scripts, basically the language of the host operating system.
3. PL/SQL Stored procedure – used to run the stored procedure through oracle applications.
4. SQL*Loader – used to run the sql loader programs.
5. SQL*Plus - used to run the anonymous PL/SQL blocks. It will get executed in the same fashion as you are running on SQL Plus.
6. Java Stored Procedure – The execution file is a Java stored procedure.
7. Java Concurrent Program – Used for program written in Java.
8. Spawned – used for c or pro*c Program. Mainly used by standard oracle interfaces.
9. Perl Concurrent Program – used for programs written in CGI Perl.
10. Request Set Stage Function – PL/SQL stored function that can be used to calculate the completion statuses of request set stages.
11. Immediate – execution file is a program written to run as subroutine of the concurrent manager. Oracle doesn’t recommend use of this executable type.
12. Multi-Language function – execution file is an MLS function that supports running concurrent program in multiple languages.
PL/SQL Stored Procedure, Oracle Reports, Host, SQL*loader, SQL*Plus are the most commonly used executable types.
2. Concurrent program definitions & adding parameters.
Navigation: Application Developer > Concurrent > program
1. Concurrent executable creations.
2. Concurrent program definitions & adding parameters.
3. Attach this program into request group.
4. Develop the oracle reports as per requirements.
5. Move the reports into $XXCUSTOM_TOP/reports/US.
6. Run and verify the report output. (concurrent program)
Steps in detail
1. Concurrent executable creations.
Navigation: Application Developer > Concurrent > Executable
Enter the valid values for the “Executable, short name, application, execution method
Execution methods
1. Oracle Reports – used for the RDF reports.
2. Host – used for shell scripts, basically the language of the host operating system.
3. PL/SQL Stored procedure – used to run the stored procedure through oracle applications.
4. SQL*Loader – used to run the sql loader programs.
5. SQL*Plus - used to run the anonymous PL/SQL blocks. It will get executed in the same fashion as you are running on SQL Plus.
6. Java Stored Procedure – The execution file is a Java stored procedure.
7. Java Concurrent Program – Used for program written in Java.
8. Spawned – used for c or pro*c Program. Mainly used by standard oracle interfaces.
9. Perl Concurrent Program – used for programs written in CGI Perl.
10. Request Set Stage Function – PL/SQL stored function that can be used to calculate the completion statuses of request set stages.
11. Immediate – execution file is a program written to run as subroutine of the concurrent manager. Oracle doesn’t recommend use of this executable type.
12. Multi-Language function – execution file is an MLS function that supports running concurrent program in multiple languages.
PL/SQL Stored Procedure, Oracle Reports, Host, SQL*loader, SQL*Plus are the most commonly used executable types.
2. Concurrent program definitions & adding parameters.
Navigation: Application Developer > Concurrent > program
Token (nothing but report parameter name)
3. Attach this program into appropriaterequest group.
4. Develop the oracle reports as per requirements.
5. Move the reports into $XXCUSTOM_TOP/reports/US.
6. Run and verify the report output. (concurrent program)
No comments:
Post a Comment