12 Replies Latest reply on Apr 20, 2018 8:50 AM by 3241795

    How to Call 'Create Accounting' From backend(from fnd_submit_request).

    3241795

      Hello Guys,

       

      Could anyone help me out how to submit create accounting program from back end. I am using the below way but the request ID is coming '0' i.e it is not getting submitted properly.

       

      set SERVEROUTPUT ON;

      declare

       

      v_request_id VARCHAR2(100) ;

       

      BEGIN

      v_request_id:=fnd_request.submit_request (

                                  application   => 'XLA',

                                  program       => 'XLAACCPB',

                                  start_time    => sysdate,

                                  sub_request   => FALSE,

                                  argument1     => '1040',

                                  argument2     => '',

                                  argument3     => '03-may-2016',

                                  argument4     => 'F',

                                  argument5     => 'N',

                                  argument6     => 'N',

                                  argument7     => 'Y',

                                  argument8     => 'Y',

                                  argument9     => '',

                                  argument10    => 'N'                          

                                 );

                                                           

      dbms_output.put_line('Request submitted. ID = ' || v_request_id);

      commit ;

      exception

      when others then

      dbms_output.put_line('Request set submission failed – unknown error:'|| sqlerrm);

      END;                           

             

      Please help me out