Registration of a Report (.rdf) in Oracle Applications(11i and R12)

Registration of a Report (.rdf) in Oracle Applications(11i and R12)

Summary of Steps to Register a form

1. If it is a new Report start from Oracle Report Builder and build the required report TESTREPORT.rdf..

2. FTP the report TESTREPORT.rdf from Client Windows PC to Oracle Applications Middle Tier to the

path $CUST_TOP/reports/US

3. In Oracle Applications, Navigate to Application Developer Responsibility-> Concurrent-> Program-

>Executable

5. In Oracle Applications, Navigate to Application Developer Responsibility-> Concurrent ->Program and

associate the Executable with the Concurrent Program.

6. In Oracle Applications, Navigate to Application Developer Responsibility-> Application->Request

Group and associate the above Concurrent Program.

7. In Oracle Applications, Navigate to System Administrator Responsibility ->Security-> Responsibility->

Define and associate the Request Group with the Responsibility.

8. Assign the above Responsibility to the Application User, Navigate to System Administrator

Responsibility – Security->User->Define

Detailed Explanations and Step by Step Report Registration Tasks

Requirements:

1. Oracle Applications (11i or R12) Access

2. Oracle Reports Builder(6i or 10g)

3. WinSCP Tool or ftp tool like ssh or putty

- WinSCP is an open source free SFTP client and FTP client for Windows. Legacy SCP protocol is also

supported. Its main function is safe copying of files between a local and a remote computer.

- Download option of WinSCP Tool was available the following link

http://winscp.net/eng/download.php#download2

FTP the Report to Remote Server

Step1:

- Develop the report in Client Windows PC using Oracle report Builder and save the name as (.rdf)

Extension for example (TESTREPORT.rdf.) (or)

- Any other report other than .rdf like sql report to register in Oracle Application 11i or R12.

Step2:

- Open the winSCP tool, The Following window is opening,

In this Window, Enter the Host name of your Oracle Application

- And Enter the Username & Password, then click the Login button.

 - In Remote system window, open the report’s (.rdf) current folder (appltop/custom/reports/us)

- Then Move (copy) the developed Report (TEXTREPORT.rdf) from local system to Remote system

(path like $CUSTOM_TOP/reports/US).

- Move the Next Step, Once FTP of report Completed as above.

Registering the Reports into Oracle Application

Step 1:

Registering a Executable

Navigation – Application Developer ->Concurrent->Executable

Now, the following window appearing on the Screen.

Enter the following fields,

Executable name: TEST REPORT (Whichever Name you want to mention the Executable or in this case to

reflect TESTREPORT.rdf) (Mandatory Field)

Short Name: TEST_REPORT (Enter Unique value without space) (Mandatory Field)

Application: Application Object Library (or suitable Application name) (Mandatory Field)

Description: This for Test Report ( Non Mandatory Field)

Execution Method: Select the “Oracle Reports” from List of Values.

Execution File Name: TESTREPORT (Enter the File name in Upper Case without extension of .rdf that is

TESTREPORT.rdf without .rdf )

Save It through File -> Save or Press the Save Icon.

Step 2:

Creating a Program Associate with an Executable

Navigation – Application Developer Responsibility ->Concurrent->Program

Now this window appearing on the Screen.

Enter the following fields,

Program Name: Report for TEST (Enter the Report name whatever you want?)

Short Name: TEST_FOR_REPORT ( Enter the Unique name without Space for this Report)

Executable name: TEST REPORT (Executable Name mentioned by you in previous step/Window for

Executable Registration) (Mandatory Field)

Output Format: PDF (Select the Output format from the List of Values)

Output Style: Landscape ( Select the style from the available List of Values)

Save it Through File -> save or Click the Save Icon,

If Reports have a Parameter Values, Then You should mention the parameter values through the following

way,

Click the Parameter button from bottom of that form, Now one more window will opening,

In this Window,

Enter the Seq value of Parameter like 10,20,…

Enter the Parameter name without Space

Please note that in this current example we have not passed any parameters as this report does not have

any report parameters.

In Validation Part, Assign the Value set for this Parameter from validation List,

In Display Part, Enter Prompt name and Token Value of the Parameter,

Save it Through File -> save or Click the Save Icon,

Assign the Concurrent Program to Request Group

Step 1:

Navigation – System Administrator Responsibility -> Security -> Responsibility -> Request

The below window appears on the Screen.

In this Window,

Select the Request Group (name whichever you want)

After that move the Cursor into Name field in Requests Part, then select file-> New(assuming that there

are already concurrent programs associated in this already existing Request Group), to create a new row

then enter registered report program or the above Concurrent Program name in this field. Please note that

choose Type as “Program”.

Then Save it through File à save.

Assign the Request Group to Responsibility

Navigation – System Administrator -> Security->Responsibility->Define

Click on Define button and you will see following screen:

Please note that Request Group created in the previous step has been assigned to the Responsibility.

[download id="11"]

Author : Lingesan.J (dataQapps Technologies)

Editor  : S.Prasanth (SCM Consultant)