2 Replies Latest reply: Dec 19, 2012 7:27 AM by 917323 RSS

    enable to create ldt file for specific program using FNDLOAD submit request

    917323
      hi ALL ,


      i am trying to create .ldt file for specific program but the things is that following program creating .ldt file for all the program which are available on instance .
      please suggest me if i did anything wrong in my code ...

      DECLARE
      req_id fnd_concurrent_requests.request_id%TYPE;
      BEGIN
      fnd_global.apps_initialize (user_id => 1012001,
      resp_id => 20420,
      resp_appl_id => 1
      );
      req_id :=
      fnd_request.submit_request
      (application => 'FND',
      program => 'FNDLOAD',
      description => NULL,
      start_time => NULL,
      sub_request => FALSE,
      argument1 => 'DOWNLOAD' ---Mode - UPLOAD
      ,
      argument2 => '@fnd:patch/115/import/afcpprog.lct'
      -- -LCT File
      ,
      argument3 => '/tmp/concqueues.ldt' -- -
      ,
      argument4 => 'PROGRAM',
      argument5 => 'XXFUJI'
      ,argument6 => 'XXSAG_FILE_DATA'
      );
      DBMS_OUTPUT.put_line ('req_id= ' || req_id);
      COMMIT;
      END;


      thanks in advance

      sagar