Home » Applications » Oracle Fusion Apps & E-Business Suite » FDPSTP failed due to ORA-06550
FDPSTP failed due to ORA-06550 [message #466805] Wed, 21 July 2010 04:34 Go to next message
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 2262 times)
Re: FDPSTP failed due to ORA-06550 [message #466811 is a reply to message #466805] Wed, 21 July 2010 04:48 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There's a procedure. It has some parameters.
Now you are calling that procedure.
What parameters do you pass to the procedure? Oracle complains that they don't match in number or type.
Re: FDPSTP failed due to ORA-06550 [message #466998 is a reply to message #466805] Wed, 21 July 2010 23:57 Go to previous messageGo to next message
manisha_borade
Messages: 49
Registered: May 2010
Member
hi


i have 3 IN parameters(Trip Start Date,Warehouse Code,SHIFT_CODE)

and i sumbit request from backend.....
i return the code on when_button_pressed trigger to create a batch.....
  • Attachment: para.txt
    (Size: 2.85KB, Downloaded 1359 times)
Re: FDPSTP failed due to ORA-06550 [message #467010 is a reply to message #466998] Thu, 22 July 2010 00:47 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There are zillion '' parameters' values. Did you forget some of them? Or add a few too many?

Perhaps it would be easier to trace it if you named all the parameters. Something like
begin
  my_proc(par_code => :code,
          par_date => sysdate,
          par_id1  => null,
          par_id2  => null,
          par_id3  => null
         );
end;
Re: FDPSTP failed due to ORA-06550 [message #467117 is a reply to message #467010] Thu, 22 July 2010 05:06 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Show us the parameter declaration of 'FDPSTP' and show us the definition of the items you are using for "Trip Start Date", "Warehouse Code", and "SHIFT_CODE" that you are feeding into it.

David
Re: FDPSTP failed due to ORA-06550 [message #467166 is a reply to message #467117] Thu, 22 July 2010 07:15 Go to previous message
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
Previous Topic: add menu item form personalization
Next Topic: Payables Transfer To General Ledger
Goto Forum:
  


Current Time: Tue Apr 23 20:27:09 CDT 2024