How do you customize the Reports in Oracle Applications?

1.     Identify the Short name of the standard report in which module we have to customize

Ex: if u wants to customize in the AR module path is

Appl top\ar\11.5.0\reports\US\ .rdf

2.     Open the .rdf file in Report builder and change the name of the module.

3.     Open the data module and modify the query (what is client requirements) assign the columns to the attributes.

4.     Go to report wizard and select, what r the newly created columns.

5.     Then Compile it. Then u will get a .rep file in the specified module. If it is not in the specified directory then we have to put in the server directory.

6.     Then Register in the AOL

Application developer àConcurrent à Executable.

Application developer àConcurrent à Program.

7.     Go to the system administrator responsibilities and find out the Request group name.

8.     Add and assign a concurrent program to a request group.

System Administrator à Security à Responsibility à Request.

9.     Now switch to the appropriate responsibility then only we can run the request.