FDPSTP failed due to ORA-06550 [message #466805] |
Wed, 21 July 2010 04:34 |
manisha_borade
Messages: 49 Registered: May 2010
|
Member |
|
|
Hi,
One of the stored procedure errored while running fron end(Oracle Apps)
But it working backend.
#####Error Message#########
This request finished with an error and produced the following completion message:
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 'XX_DEMPO_BATCH_PLANT'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
The SQL state
i have 3 IN parameters(Trip Start Date,Warehouse Code,SHIFT_CODE)
You may find more information on the cause of the error in the request log or the concurrent manager log.
Even we set out parameter(errbuf OUT VARCHAR2,
retcode OUT VARCHAR2)
Kindly clarify this issue
Thanks
-
Attachment: program.txt
(Size: 52.84KB, Downloaded 2426 times)
|
|
|
|
|
|
|
Re: FDPSTP failed due to ORA-06550 [message #467166 is a reply to message #467117] |
Thu, 22 July 2010 07:15 |
|
vamsi kasina
Messages: 2112 Registered: October 2003 Location: Cincinnati, OH
|
Senior Member |
|
|
Try to pass only the three parameters and crosscheck. fnd_request.submit_request
('IMC', --Customers Online -- Application Short name of the Concurrent Program.
'XX_BATCH_PLANT', -- Program Short Name.
'', -- Description of the Program.
SYSDATE, -- Submitted date. Always give the SYSDATE.
FALSE, -- Always give the FLASE.
:nondb.whse_code, -- Passing the Value to the First Parameter of the report.
:nondb.shift_code,
TO_CHAR (TRUNC (:nondb.trip_start), 'DD/MM/YYYY')); By
Vamsi
|
|
|