1 Reply Latest reply: Jan 29, 2013 9:32 AM by Vortex13 RSS

    fnd_request.submit_request CESQLLDR

    668397
      Hi Techies,

      DECLARE
      l_request_id NUMBER;
      l_resp_id FND_USER_RESP_GROUPS.RESPONSIBILITY_ID%type;
      l_resp_appl_id fnd_user_resp_groups.responsibility_application_id%TYPE;
      BEGIN
      --Derive Responsibility Application ID and Responsibility ID
      BEGIN
      SELECT application_id,
      responsibility_id
      INTO l_resp_appl_id,
      l_resp_id
      FROM fnd_responsibility_vl
      WHERE responsibility_name = 'Cash Management Manager';
      EXCEPTION
      WHEN NO_DATA_FOUND THEN
      dbms_output.put_line('No such responsiblity');
      WHEN OTHERS THEN
      dbms_output.put_line('2222'||DBMS_UTILITY.format_error_backtrace || '. SQLERRM: '|| SQLERRM);
      END;
      --Apps Initialize
      fnd_global.apps_initialize(2446, l_resp_id, l_resp_appl_id);
      --Submitting the standard Payable Invoice Import Program
      L_REQUEST_ID :=
      fnd_request.submit_request ( application => 'CE',
      program => 'CESQLLDR',
      description => NULL,
      start_time => NULL,
      sub_request => FALSE,
      argument1 => 'IMPORT',
      argument2 => 1002,
      ARGUMENT3 => '123.txt' ,
      argument4 => '$CE_TOP/bin',
      argument5 => 301369,
      ARGUMENT6 => 54124,
      argument7 => '2013/01/24 00:00:00',
      argument8 => NULL,
      argument9 => NULL,
      ARGUMENT10 => null,
      argument11 => NULL,
      ARGUMENT12 => 'N',
      argument13 => NULL
      );


      COMMIT;
      DBMS_OUTPUT.PUT_LINE('L_REQUEST_ID==> '||L_REQUEST_ID);
      EXCEPTION
      WHEN OTHERS THEN
      dbms_output.put_line(DBMS_UTILITY.format_error_backtrace || '. SQLERRM: '|| SQLERRM);
      END;

      After executing the above piece of code, encountering the below error:

      ------------------------------------------------------------------------
      "ORACLE error 6550 in FDPSTP

      Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
      PLS-00306: wrong number or types of arguments in call to 'CALL_SQL_LOADER'
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored
      .

      The SQL statement bei"
      ------------------------------------------------------------------------
        • 1. Re: fnd_request.submit_request CESQLLDR
          Vortex13
          If you can post the spec for CE_BANK_STMT_SQL_LDR package?

          In my version, 12.1.3, you are missing a parameter:
          /* $Header: cesqldrb.pls 120.7 2006/06/06 00:33:19 bhchung ship $     */
          
          ,argument14 => NULL
          I received your same error without argument14, and it ran without error when i added it.
          HTH,
          --Johnnie

          Edited by: Vortex13 on Jan 29, 2013 7:31 AM