REGISTERING A REPORT IN ORACLE APPLICATIONS

STEP 1: NAVIGATING TO THE APPLICATION MODULE FOR REPORT

First Log into the Unix server using TELNET.
E.g. Start->Run->telnet 128.212.3.255

Login with User Name and Password
E.g.


You will be logged into the folder:-‘\home/”User Name”’. Use pwd to check your current working directory.
Eg.


The main folder for each application can be referred to as ‘_TOP’.
E.g.


But, this requires that the path of the ‘_TOP’ to be set before hand else it will not work.

We can also browse to the folder by navigating as described below
In this case all the application modules are present in the path /applcrp1/crp1appl

Some of the various application modules in this folder are listed below.



For an ORDER MANAGEMENT report, the module is ONT.

For registering a report, we can browse to the reports directory.


The various reports already registered are present in this directory are displayed above.

STEP 2: FTP THE FILE INTO THE UNIX SERVER
First log into the unix server.
E.g. Start ->Run-> ftp 128.212.3.255

Log into the Unix server and move to the reports directory of the application module of your report identified in the last step.
E.g. cd /applcrp1/crp1appl/ont/11.5.0/reports/US

The ‘lcd’ command displays the local directory you are present in windows. Change this directory to the directory where you report is present.


The file can be transferred in various modes like Binary, ASSCII… The default mode of transfer is ASCII. The ASCII mode of transfer will only be suitable for .txt (notepad) files where only text is possible. For other formats like .rdf(even if the report is character mode), where it contains other items not decodable by ASCII, the transfer must be BINARY.

To change to Binary transfer mode, use the command:  bin

The file can be transferred using the command:  put <filename>

(Note: Any file can be obtained from the Unix server by user of get <filename>)

The transfer can be verified from the telnet.
STEP 3: CREATING A PROGRAM EXECUTABLE IN THE FRONT END

 

Choose the responsibility as Application Developer or System Administrator.

Navigate into Concurrent->Executable

The fields need to be filled as follows:
Executable: This is the file name which it will search for in the module specified in the application. Give any name to represent the executable
Short name: This is a name used internally in apps to link the application with the concurrent program. Assign a short name
Application: Input the application module the report belongs to. E.g. Order Management (ONT).
Description: Input any User defined description.
Execution Method: An application registered can be an Oracle report, PL/SQL stored procedure, Java Concurrent Program…We have to select Oracle report when we are registering an Oracle Report.
Execution File Name: This is the same as Executable. Input the same name
E.g.


Usually the Executable and the short name are given the same name for ease of use, but they can have distinct values.

STEP 4: SETUP A CONCURRENT PROGRAM FOR THE EXECUTABLE
Log in the same responsibility as STEP 3 (Application Developer or System Administrator.)
Navigate into Concurrent->Program.


The fields need to be filled as follows:

Program: Input a name to the concurrent program.
Short Name: Give the short name of the Program Executable that needs to be run. This is the ‘Short Name’ given to the executable in STEP 3.
Application: Select the application module the report belongs to. E.g. Order Management (ONT)
Description: Give a description about the Concurrent program
Name: Give the Executable name.
Method: This is populated with the Execution method given in the Program executable (in STEP 3)
Format: The output can be of text, PDF… format
          The report can be saved and/or printed. Check the boxes according to requirement.
If you select print, input the row size, column size and printer also.
Style:  Select a style according to requirement.
E.g.

The parameters of the Program also need to be entered. Click the Parameters button in the right bottom corner of the report. It will open another window as shown below


       Fill in all the Input parameters for the report in this form. 
       Enter the name of the user parameter used in Oracle Reports in the Parameter column.

       E.g.   
        
         Each parameter should also have a Value Set.
       If the Input parameter does not have a specific value set, 
       it can be given a Value Set like 1 Number,100 Characters…etc depending on requirement.
       If the Input Parameter has a value set (List Of Values), 
       then create a new value set as given in Appendix A.

       Leave the Display size, Concatenated Description Size, Description size, Security Group 
       with their default values.

       STEP 5: ASSIGN THE CONCURRENT PROGRAM TO A RESPONSIBILITY

Go to the below screen:

       Navigator – SystemAdministrator :Security :Responsibility :Define.
       Get the Request Group name for a specific Responsibility name from the below screen



       Now go to the below screen
       Navigator - SystemAdministrator :Security :Responsibility :Request.

           
        Press the ‘+’ sign at the top left corner.

        Now enter the Group name

        It will display all the applications in that group.

       Add your application details (Type, Name, Application) by 
      clicking the New button (plus symbol) in the tool bar.

      Add the organization id parameter in the following manner:
      This is with respective to invoice reports.


APPENDIX A: CREATE A VALUE SET

Choose the responsibility as Application Developer or System Administrator.

Navigate into Application->Validation->Set

       Enter a Value Set Name and Description.

       Enter the Format Type, Maximum Size and Precision as per requirement.

       If the validation is based on a Table then enter the Validation type as Table
       Click the Edit Information tab.

       Choose the table required from which the field needs to be fetched in the Table Name
       the value that needs to be displayed in Value,  and the value that needs to be passed in ID.
       Include the Where/Order By condition if required