REPORTS

1.    What are the steps involved in Reports Customization?

1.    Copy the source file into custom directory and rename if required.

2.    Carry out the required changes.

3.    Create a new executable and concurrent program.

4.    Attach to a Request Group and subsequently to a Responsibility.

2.    How do you implement customized reports into Oracle Apps?

Create a new executable and concurrent program.

Attach to a Request Group and subsequently to a Responsibility.

3.    What is a User Exit?

User exit is a program, which enables executing external procedures.

4.    What are the user exits available in Oracle Apps?

FND SRWINIT, FND SRWEXIT, FND FORMAT_CURRENCY,

FND FLEXIDVAL, FND FLEXSQL.

5.    What is the use of FND SRWINIT?

It is used to set Profile values and environmental variables.

6.    What is the use of FND SRWEXIT?

It is used to release the memory used by Profile and Environmental variables called by SRWINIT.

7.    How do you find the report source file name?

Report’s source file name can be found from the log file of that report.

8.    Where do you find a report’s source file?

It will be found in the corresponding report directory of the Product Top.

9.    In which directory do you store the customized reports?

Report directory of Custom Top.

10. How do you ensure that customized reports are not overwritten during an upgrade?

By placing them under Custom directory.

11. Why is FND FORMAT_CURRENCY used exit called?

This user exit is used for formatting currencies dynamically.

12. How do you pass parameters to a report?

Parameters can be passed to a report via Tokens from a Concurrent Program.

13. What is the use of $FLEX$?

$FLEX$ is used in value sets to retrieve values based on a value of another value set.

14. What is FND FLEXIDVAL used for?

This user exit is used to populate fields for display. You pass the key flex fields data retrieved by the query into this user exit from the formula column. With is user exit, you can display values, descriptions and prompts by passing appropriate token (any one of VALUE, DESCRIPTION, APROMPT or LPROMPT).

15. What are the different methods of doing a Flex field report?

There are two methods of doing a Flex Field report.

1.    By using Flex Field views.

2.    By using Flex Field user exits.

16. Is there any template for reports customization?

No.

17. From which trigger do you call the SRWINIT user exit?

Before Report Trigger.

18. From which trigger do you call the SRWEXIT user exit?

After Report Trigger.

19. Where are the log files and output files of a report stored?

Log files and Out files are stored under the Log and Out directories

Of the respective Product directory.

20. When do you call SRW.Reference?

SRW.Reference is called when you want to access the current value of any

Item / Variable in a report.

21. What is the purpose of calling FND FLEXSQL?

This user exit is called to create a SQL fragment usable by your report to

tailor your SELECT statement that retrieves flex field values. This

fragment allows you to SELECT flex field values or to create a WHERE,

ORDER BY, GROUP BY, or HAVING clause to limit or sort the flex field values returned by your SELECT statement. You call this user exit once for each fragment you need for your select statement.

22. How do restrict a user from accessing a report?

By assigning responsibilities.

23. How do you access profile values from a report?

By using appropriate procedures from FND_PROFILE.

24. What are the required parameters if you want to create a flex field report ?

·         P_CONC_REQUEST_ID.

The user exit FND SRWINIT uses this parameter to retrieve information about the concurrent request that started this report.

           

·         P_FLEXDATA