Tuesday, November 3, 2009

How to register the oracle reports in oracle apps?

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


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)

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete