creating a custom oracle report with concurrent program executable
we have followed the steps to create a oracle report and attach it to the concurrent program executable from the oracle apps dev guide. but it is NOT working!!! the query is not retrieving any records. to test , replaced the SRWINIT with MO_GLOBAL.SET_POLICY_CONTEXT('S', 134); and it works in reports but does not work with CCP executable. what is missing?
the objective is to retrieve the data from ar_payment_schedules_v through oracle reports.
as per manual did the following
* CCP parameter define as "Request ID" , display = No, token P_conc_request_id, val_set "7/number"