XML Report Development Steps

XML Report Development Steps

Read the FDD thoroughly. And clarify the column mapping with the functional consultant (or get from which form, the value is referenced).

1. Get the specific requirement need in the report. If some specific requirement is need then you search the similar report (.rdf) will be surely will be given by oracle.

2. So, decide weather the report is to developed by existing oracle seeded report or develop a new report.

3. in case of new report you almost every step to create a new ..rdf

4. But in case of modify the existing report, first get the concurrent program name and its application name, find the executable of it.

5. Get the folder the ..rdf is present. Download it with SFTP (WinSCP or Toad or cmd FTP).

6. Open the report builder, connect to data base (apps/apps@------) and open the downloaded ..rdf.

7. Save as new name according the naming conventions.

8. Now create new formula columns at main query block or child query block as required for your new report.

9. Save all changes do not do any thing with the layout because you are not going to do any thing with the .rdf report layout.

10. Only compile newly created formula column functions.

11. Place the .rdf in the custom folder, create new executable and name the concurrent program according the naming standards.

12. Give out put as XML and save.

13. Now open a new MsWord document, since most of the layouts will be given in the FDD it self copy that layout and paste in the new MsWord.

14. At the places where the data to be printed inset new formtext fields.

15. First place a form text filed at the starting of the report to start the new query group and put end form text filed at the end of the report layout.

16. Give name the field and in Add help text type the ex. The XML tag of the formula column, which can be found in the formula column property palette.

17. Like wise create all fields wherever are required for the report. And for inner formula columns that are in child query block start a new inner query group name and crate the new field and end it with for text field.

18. Save the new MsWord and save as .rtf file and name this file also with naming conventions ( cilentshortname_modulename_descriptin of the report)

19. Now open the Oracle applications front end go to XML Publisher responsibility

20. Create a new data definition where the Code should match with the concurrent program short name.

21. Create a new template and attach the data definition to the template and upload the MsWord .rtf file and give a language and territory. Apply.

22. Attach the concurrent program to request group and try to submit the Report, click options button if you find the template name then the XML template is attached rightly and the report will work.

These are the steps that to be followed.