1 Reply Latest reply: Apr 17, 2012 2:20 PM by 741497 RSS

    fnd_submit.set_request_set, stage program not getting org context

    741497
      R12 - I am using request_set submission from backend, similar to example in note [ID 221542.1]. ORG_ID context beging setup at the begining of calling package, request set request_id getting org_id properly , However stage programs not getting org_context.

      Here is the simplified example ..

      Step 0 - Org_context set at the begining
      mo_global.set_policy_context('S',v_org_id);
      fnd_request.set_org_id('ORG_ID');

      Note: Getting org_id value at this point in fnd_log

      Step 1 - call set_request_set
      success := fnd_submit.set_request_set('FND', 'FNDRSSUB43');

      Note: fnd_concurrent_request.org_id updated properly for request set request id, so org is properly setup

      Step 2 - call submit program for each program in the set
      success := fnd_submit.submit_program('FND','FNDMNMNU', 'STAGE10', 'System Administrator', chr(0));

      Note: org_id is not update with fnd_concurrent_request.org_id for stage request_id. Report in stage is not pulling data from pa_projects, meaning org_id context is not setup for the program. There is no parameter for org_id in argument, i am expecting it to setup based on org_context.

      Thanks in advance.

      Edited by: AppsRD on Apr 16, 2012 7:59 AM