Tuesday, July 5, 2022

Set Oracle Report(rdf) Concurrent Program ends with Warning Status

Create a user parameter as P_CONC_REQUEST_ID as shown in below screenshot.


In before report trigger initialize using user exists as shown in below screenshot.


Below is our requirement:

We have two optional parameters Account and Parent Account. User has to select either of the one parameter. If user selects both Parameters then the report output will be blank. So we are completing program with Warning status so that user can go review the log file.



As shown in above screenshot write srw.message to see the message in log file.



No comments:

Post a Comment

Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...