This discussion is archived
1 Reply Latest reply: Jan 29, 2013 7:32 AM by Vortex13 RSS

fnd_request.submit_request CESQLLDR

668397 Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points