Monday, 30 June 2014

How to run concurrent program in procedure/ trigger

req_id NUMBER;
RESULT BOOLEAN;

RESULT := APPS.fnd_request.set_mode (TRUE);
                req_id := APPS.FND_REQUEST.SUBMIT_REQUEST('FND',
                                         'FNDSCURS',
                                         '',
                                         sysdate,
                                         FALSE,
                                         :NEW.BATCH_ID);
               commit;
  
--this is sample to run the active users standard report having no parameter, you can explore the parameters by reviewing the FND_REQUEST.SUBMIT body. 

No comments:

Post a Comment