1. Create concurrent program, Short Name e.g. = XXXX_BIPREPORT, Executable Name = XDODTEXE, Output Format = XML. And add to the required Request Group.
2. Create BIP report resulting in an XDO file (data definition file, available from filing system) and a template file (such as an .RTF file defining report layout)
3. Within EBS, using XML publisher administrator responsibility, navigate to data definitions and select create data definition.
4. Populate name etc and in the code box enter Concurrent Program Short Name from 0. ie XXXX_BIPREPORT, click apply
5. Still in the data definitions tab, search for the Data definition just created and click to view it.
6. Select Add file button next to data template and browse for the XDO file created within BIP, select ok and apply. This action tells Concurrent Program from 0 XXXX_BIPREPORT what data to extract.
7. Click on data template tab and create template.
8. Populate boxes with names and code of Concurrent Program Short Name from 0 XXXX_BIPREPORT and name of data definition just created.
9. In the template file box browse for the template file created in BIP (eg .rtf)
10. Click apply and run concurrent program XXXX_BIPREPORT.
Some other pointers:
- It is possible to automate and move the above setup around environments using combination of FNDLOAD and XDOLOADER
- You can set a default output type if you apply patches 5612820 (R11i and R12) plus 7627832 (R11i only) see http://garethroberts.blogspot.com/2009/01/revisited-changing-default-layout.html
0 comments:
Post a Comment