4 Replies Latest reply on Apr 10, 2018 5:33 PM by Tam_11

    calling other concurrent programs from after report trigger on Oracle Strd Report 10

    Tam_11

      Good day,

       

      eBS 12.1.3

       

      Quick summary of what I'm trying to do......from the Statement Generation (ARXSGPO) After Report Trigger --> call Function in custom package --> call XDOREPPB using fnd_request.submit_request --> return to ARXSGPO  After Report Trigger-> call Function in custom package --> call custom ftp job using fnd_request.submit_request.

       

      When I called the custom ftp job I couldn't find the *.out file in $APPL_OUT directory.  Initially I thought XDOREPPB wasn't finished yet, so I tried using wait_for_request and discovered that XDOREPPB never actually completes until the calling program ARXSGPO completes.  So I can't access the XDOREPPB output file to copy and ftp.

       

      Is there a way to force the XDOREPPB to finish when it is called this way?

       

      Thanks,

      Tam