Sure Apps
Welcome
Home
Login/Register
Commands
Sql
Pl/Sql
Reports
Forms
Oracle Apps
FAQs
Sql
Pl/Sql
Reports
Forms
Oracle Apps
Learn
Sql
Pl/Sql
Reports
Forms
Oracle Apps

Few Report Commands

1. To apply a format mask for date parameter.
Usually report fails when we select a date value from FND_STANDARD_DATE value set value as a parameter. To avoid this provide the input mask in rdf 'YYYY/MM/DD HH24:MI:SS'. Select the date parameter in rdf and provide the input mask under format mask.

2. To display messages from the report.
Use the SRW function to display message.

SRW.MESSAGE(100,your_message);

3. To Call a bursting report.
We usually call the bursting program after the report completed. So we write a pieco of code in After report trigger.

l_request_id := FND_REQUEST.SUBMIT_REQUEST('XDO',
'XDOBURSTREP',
'',
'',
FALSE,
'Y',
:P_CONC_REQUEST_ID,
'Y');

Above pass the values as they are.
DisclaimerContact UsPrivacy Policy