Register the Report into Oracle Application

Introduction
To register a Report with Oracle Applications in order to use it in Apps.

1. Develop the report(.rdf) file as per client requirement by using reports 6i.
2. move the .rdf file from local machine to server into the respective path

CUS_TOP\11.5.0\Reports\US\ .rdf PO_TOP\11.5.0\Reports\US\ .rdf

1. Connect to the application and select system administrator create Executable
2. Executable Name (Any User defined Name)
3. Application Name(Where the .rdf file located)
4. Execution Method (Oracle Reports for reports)
5. Execution File (.rdf file Name)
6. Create Concurrent program and attach 1)Executable
7. Parameters
8. Incompatible Programs
9. create Request Group attach Concurrent Program
10. Create responsibility attach
    1. Request Group
    2. Menu
    3. Data Group
11. Create User Attach Responsibility to the User
12. User will submit the request from SRS (Standard Request Submission) Window

SELECT user_id UserID, user_name UserName, creation_date Cdate FROM fnd_user Executable = System Administrator => Concurrent = > PRogram =>Executable Concurrent Program = => Concurrent = > Program => Define Request Group = => Security = >Responsibility => Request responsibility = => Security = >responsibility => define user = =>Security =>User =>Define SRS Window = View=>Requests=>Submit New Request => OK =>Select Program Name =>Click Submit Button Press NO =>Select find Button =>

1. Click View output button to open the output file.
2. Click View Log button to open the log file.

1.we will develop the report through report 6i.
2.we will move that report from local machine to oracle apps server
for example if it Po module the path is
PO/11.5/reports/us/xx.rdf
3.we will create exectuable from sysadmin responsiblity.
4.we will create concurent program from sysadmin responsiblity and attch exectable incompatabilites parameters.
5.we will create request group and attach concurent program.
6.we will create responsiblity and attach request group.
7.we will attch responsilty to user .
8.user will sumbit concurent program from srs window.
We will modify
pre_form trigger when_new_form_instance app_custom package we need to change in template.fmb