1.Client supply the report layout in any format (excel).
2.Create and write the query in TOAD (or any other IDE). The output of the query must be similar to the
client data format. Knowing the important apps tables with columns names and join condition between them is a key for creating queries for report. In most of the cases, the client provide the tables
names and column names to be used.
3.Create a data template (XML) using the query. If you have sample data template file, then just modify the
existing ones.
4.Generally, during report creating using data template, we use 'XDODTEXE' as an executable program.
'XDODTEXE' is an default executable java concurrent program. So, no need to create executable
program if you are using data template file to create report.
5. To create the concurrent program. Go to 'Application Developer' in apps -> Concurrent -> Program
Enter Program ->(Any valid report name. The report name will be used later and will be seen in report output).
Short Name->(enter any name)
Application->(XX_CUSTOM)
Executable Name-> XDODTEXE (As already mentioned above).
Format-> (xml).
6. Copy the report name and pass it to DBA. So that the DBA can add rresponsibility in the resquest group)
7. Copy the short name and close the form.
8. In the apps, Go to th eXM: publisher Administrator -> Home -> data Definition.
9. Click 'Create data template'.
10.Paste the short name to 'code' field.
11. Enter name-> (any), Application->XX_Custom
12.Click apply.
13.In data template -> click add file and browse the data template xml file.
14.Run the request in SRS window.
15. View the output in XML format.
16.save the ouput xml file in .xml format. (this will be used for importing in BI Publisher)
17. Create and design the layout in BI Publisher.
18.REGISTERING THE .RTF FILE:
19. Go to the data definition and copy the name.
20.Go to template -> Create 'Template'.
21.Paste the name, Application as 'XX-CUSTOM' and type as 'RTF'.
22.In the file -> Browse the .RTF file.
23.Go to the SRS window of the particular responsibility of AR (Let us consider the DBA
has attached the AR responsibility) and see the output of the report.
2.Create and write the query in TOAD (or any other IDE). The output of the query must be similar to the
client data format. Knowing the important apps tables with columns names and join condition between them is a key for creating queries for report. In most of the cases, the client provide the tables
names and column names to be used.
3.Create a data template (XML) using the query. If you have sample data template file, then just modify the
existing ones.
4.Generally, during report creating using data template, we use 'XDODTEXE' as an executable program.
'XDODTEXE' is an default executable java concurrent program. So, no need to create executable
program if you are using data template file to create report.
5. To create the concurrent program. Go to 'Application Developer' in apps -> Concurrent -> Program
Enter Program ->(Any valid report name. The report name will be used later and will be seen in report output).
Short Name->(enter any name)
Application->(XX_CUSTOM)
Executable Name-> XDODTEXE (As already mentioned above).
Format-> (xml).
6. Copy the report name and pass it to DBA. So that the DBA can add rresponsibility in the resquest group)
7. Copy the short name and close the form.
8. In the apps, Go to th eXM: publisher Administrator -> Home -> data Definition.
9. Click 'Create data template'.
10.Paste the short name to 'code' field.
11. Enter name-> (any), Application->XX_Custom
12.Click apply.
13.In data template -> click add file and browse the data template xml file.
14.Run the request in SRS window.
15. View the output in XML format.
16.save the ouput xml file in .xml format. (this will be used for importing in BI Publisher)
17. Create and design the layout in BI Publisher.
18.REGISTERING THE .RTF FILE:
19. Go to the data definition and copy the name.
20.Go to template -> Create 'Template'.
21.Paste the name, Application as 'XX-CUSTOM' and type as 'RTF'.
22.In the file -> Browse the .RTF file.
23.Go to the SRS window of the particular responsibility of AR (Let us consider the DBA
has attached the AR responsibility) and see the output of the report.
