Monday 27 July 2015

Report Builder's rdf Report File Integration With Oracle EBS R12

One you have developed report in Report Builder, save it as .rdf file.
Following are the steps to integrate with ebs

Note. I will be integrating report in order management responsibility for demonstration purposes.



  1. First of all we need to know in which application folder is to put the rdf file. Go to System Administrator > Application > Register, Enter application name and you will get Basepath in the form of <Application_folder>_TOP.
  2.  Place the rdf file in appropriate application folder at <system drive>\oracle\VIS\apps\apps_st\appl\<application folder>\12.0.0\reports\US. In my case system drive is D:\ and <Application_folder> is folder find in step 1..
  3. Define executable. Go to System Administrator > Concurrent > Program > Executable and enter the following information prompted in form , Executable = executable name , short name which will be used when defining concurrent program,   Application = Order Management (ebs will look for rdf file corresponding to order management folder), Execution Method = Oracle Reprots, Execution File Name = file name placed in <application folder> in step 2. Save the form
  4. Define Concurrent Programs. Go to System Administrator > Concurrent > Program > Define and enter the following information prompted in the form, Program = Name of current program which will be used when creating report, Short name, Application = Order Management, In executable field area Name = shortname given in step 3, In Output Format = PDF Style = A4. If there are parameters then click on Parameters Button and add parameters. Save the form.
  5. Assign to Request group. As we are creating concurrent program for order management responsibility, we need to check which request group is assigned to this responsibility. Once you have find request group, go to System Administrator > Security > Responsibility > Request and enter the Request group and add our concurrent program we created in step 4.
  6. Now go to Order Management responsibility and select view > request > submit new request.