Home » Applications » Oracle Fusion Apps & E-Business Suite » ORACLE error 6550 in FDPSTP
ORACLE error 6550 in FDPSTP [message #590336] Wed, 17 July 2013 05:35 Go to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Hi all,

Can any one please help me?

Here XXC_MTL_SUBMIT_REQUEST is the Procedure in my package

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


Thanks&Regards,
Siva
Re: ORACLE error 6550 in FDPSTP [message #590339 is a reply to message #590336] Wed, 17 July 2013 05:55 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Everything is said here:
wrong number or types of arguments in call to 'XXC_MTL_SUBMIT_REQUEST'

Therefore, check the way you are calling that procedure.
Re: ORACLE error 6550 in FDPSTP [message #590342 is a reply to message #590339] Wed, 17 July 2013 06:05 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Thanks for reply,

Here is my code please please check it once and i compiled in TOAD it compiled sucessfully..

PROCEDURE Xxc_mtl_submit_request (x_request_id OUT NUMBER)
IS
v_dev_phase VARCHAR2(30);
v_dev_status VARCHAR2(30);
v_func_phase VARCHAR2(30);
v_func_status VARCHAR2(30);
v_func_message VARCHAR2(240);
v_wait BOOLEAN := TRUE;
v_user_description VARCHAR2(240) := 'Process Transaction Interface';
errcode NUMBER;
v_program VARCHAR2(200);
v_wait_status BOOLEAN;
BEGIN
errcode := fnd_request.Submit_request ('ONT', --Application
'INCTCM', --Program
v_user_description, --Description
NULL,
FALSE,
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0),
CHR(0));
IF errcode = 0 THEN
dbms_output.Put_line('Cannot Submit Request');
ELSE
dbms_output.Put_line('Submitting Job to Run '
||v_user_description
||' Look at Request ID: '
||To_char(errcode));

COMMIT;
END IF;

--clear_block;
x_request_id := errcode;

IF errcode != 0 THEN
IF v_wait --if parm to wait is true
THEN
v_wait_status := fnd_concurrent.Wait_for_request(errcode, 60, 60,
v_func_phase ,
v_func_status,
v_dev_phase, v_dev_status,
v_func_message
);

dbms_output.Put_line('Phase is '
|| v_func_phase
|| ', Status is '
|| v_func_status);

IF v_dev_phase != 'COMPLETE'
OR v_dev_status NOT IN ( 'NORMAL', 'WARNING' )
OR NOT v_wait_status THEN
dbms_output.Put_line('ERROR: '
|| v_user_description
|| ' did not Complete Normally');

dbms_output.Put_line('Phase is '
|| v_func_phase
|| ', Status is '
|| v_func_status);
END IF;
END IF; --end of if p_wait
END IF;
END xxc_mtl_submit_request;
Re: ORACLE error 6550 in FDPSTP [message #590343 is a reply to message #590342] Wed, 17 July 2013 06:17 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It didn't fail when you compiled it, but when you called it. How did you call it? Post that piece of code, please.
Re: ORACLE error 6550 in FDPSTP [message #590344 is a reply to message #590343] Wed, 17 July 2013 06:22 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Ok,

I have package XXC_PO_ETA_PKG.XXC_MTL_SUBMIT_REQUEST, i passed 'P_FILE_NUMBER' for Requests

[Updated on: Wed, 17 July 2013 06:28]

Report message to a moderator

Re: ORACLE error 6550 in FDPSTP [message #590345 is a reply to message #590344] Wed, 17 July 2013 06:33 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Hi Littlefoot..

1.)XXC_PO_ETA_PKG.XXC_MTL_SUBMIT_ REQUEST
This program will call standard program "Process Transaction Interface" this will insert data into these tables
1.)MTL_MATERIAL_TRANSACTIONS
2.)RCV_SHIPMENT_HEADERS
3.)RCV_SHIPMENT_LINES
Above is the actuall process..

Regards,
Siva
Re: ORACLE error 6550 in FDPSTP [message #590346 is a reply to message #590345] Wed, 17 July 2013 06:48 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, nothing you posted so far leads to that error.

In a package, XXC_MTL_SUBMIT_REQUEST procedure (as a string) is mentioned 3 times:
- line 661: (CREATE) PROCEDURE XXC_MTL_SUBMIT_REQUEST
- line 806: END XXC_MTL_SUBMIT_REQUEST
- line 1349: calling XXC_MTL_SUBMIT_REQUEST (as a part of XXC_SUBMIT_INV_REQUEST procedure)

As we said, CREATE PROCEDURE is OK, so only line 1349 is left. It looks like this:
XXC_MTL_SUBMIT_REQUEST(x_request_id);

x_request_id is declared as a NUMBER (line 1201), which is OK.

Therefore, once again, I think that package you posted can't be responsible for the error.

Did you, by any chance, call XXC_MTL_SUBMIT_REQUEST elsewhere? What is "FDPSTP" that failed?
Re: ORACLE error 6550 in FDPSTP [message #590347 is a reply to message #590336] Wed, 17 July 2013 06:56 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
No,

I called XXC_MTL_SUBMIT_REQUEST(x_request_id) in XXC_SUBMIT_INV_REQUESTS Procedure..

Regards,
Siva
Re: ORACLE error 6550 in FDPSTP [message #590348 is a reply to message #590347] Wed, 17 July 2013 07:08 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I know, I said that in my previous message. But there's nothing wrong in that.

Excerpt from the package:
PROCEDURE XXC_MTL_SUBMIT_REQUEST (x_request_id   OUT NUMBER) IS
BEGIN
  errcode := fnd_request.submit_request (
			  'INV',               --Application
			  'INCTCM',            --Program
			  v_user_description,  --Description
			  NULL,
			  FALSE,
			  CHR(0),
			  CHR(0),
                          ...

  x_request_id := errcode;
END XXC_MTL_SUBMIT_REQUEST;

PROCEDURE XXC_SUBMIT_INV_REQUEST (...)
IS
  x_request_id             NUMBER;
BEGIN
  XXC_MTL_SUBMIT_REQUEST(x_request_id);
END XXC_SUBMIT_INV_REQUEST;


It says that procedure returns X_REQUEST_ID which is equal to ERRCODE which gets its value from FND_REQUEST.SUBMIT_REQUEST.

Is it possible that FND_REQUEST.SUBMIT_REQUEST returns anything but a number? If so, that might be a culprit.
Re: ORACLE error 6550 in FDPSTP [message #590415 is a reply to message #590348] Wed, 17 July 2013 23:56 Go to previous message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Thanks Littlefoot..

Regards,
Siva
Previous Topic: Registering executable from backend
Next Topic: Tables Description
Goto Forum:
  


Current Time: Thu Mar 28 15:08:11 CDT 2024