Creating BI Publisher Report and Registering In Oracle Apps

Creating BI Publisher Report

Let us see, How the RTF reports have to be created and registered in the Oracle Apps R12. Before going to that you must be aware of RDF reports and you have to have some knowledge on RDF reports. Developing RTF reports is Easy than RDF, since we no need to draw the complex layout as in RDF.

PRE-REQUISITES:

·         Oracle Report Builder

·         BI Publisher Desktop (Add-on for MS Word)

Develop RDF Report and Generate XML. Here you no need to develop the layouts. Defining data model in RDF is enough

Step 1:

  Open the Report Builder and Specify the Data model and Create a RDF file without layout

Step 2: Generate XML file by navigating File>generate to file>XML 

Step 3: Create RTF file

             Load the XML file into the word document using BI publisher Add-ins

Step 4: Select the fields which you want in report or either choose insert all fields or from table wizard, table/form.

STEP 5: save the RTF file

STEP 6: Register the rdf file in oracle apps. Open the Oracle apps and navigate to the following

                                                             Application developer>concurrent>executables

STEP7: Register the concurrent program

           Application developer>concurrent>Program

STEP 8:

Define the data definition by navigating

XML publisher administrator>Home>DataDefinition

Step 9: Defining template

STEP 10:

Assigning the report to responsibility

System Administrator>Security>Request

Type the request group name to which you have assign

Eg:- XXEMP Request Group

Step 11: Move the RDF file to the custom top.

Eg: /t03/applkt1/apps/apps_st/appl/xxogs/12.0.0/reports/US

Step 12: Run the request going to particular responsibility to which you assigned the Concurrent Program.

Now you have created and registered the BI publisher report in the Oracle Apps Successfully.