OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » ORACLE error 6550 in FDPSTP

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORACLE error 6550 in FDPSTP [message #590336]

Wed, 17 July 2013 05:35

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

Report message to a moderator

Re: ORACLE error 6550 in FDPSTP [message #590339 is a reply to message #590336]

Wed, 17 July 2013 05:55

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: ORACLE error 6550 in FDPSTP [message #590342 is a reply to message #590339]

Wed, 17 July 2013 06:05

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;

Report message to a moderator

Re: ORACLE error 6550 in FDPSTP [message #590343 is a reply to message #590342]

Wed, 17 July 2013 06:17

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: ORACLE error 6550 in FDPSTP [message #590344 is a reply to message #590343]

Wed, 17 July 2013 06:22

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

Attachment: XXC_PO_ETA_PKG.pkb
(Size: 56.56KB, Downloaded 2349 times)

[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

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

Report message to a moderator

Re: ORACLE error 6550 in FDPSTP [message #590346 is a reply to message #590345]

Wed, 17 July 2013 06:48

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: ORACLE error 6550 in FDPSTP [message #590347 is a reply to message #590336]

Wed, 17 July 2013 06:56

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

Report message to a moderator

Re: ORACLE error 6550 in FDPSTP [message #590348 is a reply to message #590347]

Wed, 17 July 2013 07:08

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: ORACLE error 6550 in FDPSTP [message #590415 is a reply to message #590348]

Wed, 17 July 2013 23:56

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Thanks Littlefoot..

Regards,
Siva

Report message to a moderator

Previous Topic:	Registering executable from backend
Next Topic:	Tables Description

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 01:32:42 CST 2024