OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Lookups in apps (Oracle E-Business Suite R12)

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

Lookups in apps [message #546678]

Thu, 08 March 2012 02:06

Osafa
Messages: 14
Registered: July 2011
Location: Malaysia , KL

Junior Member

Hi all,

I am trying to execute ac concurrent by triggering it using lookup, but the concurrent end up with the following error.

**Starts**06-MAR-2012 16:38:24
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 'MAINV2'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

The SQL statement being executed at the time
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+-------------------------------------

However when I submit it individually via concurrent it runs without error but the same concurrent gives the above mentioned error while running

I need an urgent help as I am stuck with for quite a long.

Regards,
Karim.

Report message to a moderator

Re: Lookups in apps [message #547640 is a reply to message #546678]

Thu, 15 March 2012 05:41

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Quote:

I am trying to execute ac concurrent by triggering it using lookup
However when I submit it individually via concurrent it runs without error but the same concurrent gives the above mentioned error while running

Please elaborate.

By
Vamsi

Report message to a moderator

Re: Lookups in apps [message #547707 is a reply to message #547640]

Thu, 15 March 2012 20:33

Osafa
Messages: 14
Registered: July 2011
Location: Malaysia , KL

Junior Member

Hi vamsi,

Thanks for your response..

I managed to solve it. The preprocessor which I was submitting takes concurrent short-name and the corresponding parameters from the lookups and then using fnd_submit it triggers the concurrents. How ever if the triggered exec is a .rdf then it is not a problem where as in case of pl/sql stored procedure it was errored out with the error log. I checked the values and it was correct except it was trying to pass as many values as the lookups by default. When i changed the submission part from passing the (attribute1- attribute 10) to (attribute1- attribute 4) which actually was the number of parameters my stored proc was using apart from errbuff and retcode, submitted normally.

I came to conclusion that for .rdf one can use the defaulted submission however for stored proc it has to be manoeuvered.Correct me if I am wrong.

Thanks,
Osafa karim

Report message to a moderator

Re: Lookups in apps [message #547723 is a reply to message #547707]

Fri, 16 March 2012 01:13

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Quote:

I came to conclusion that for .rdf one can use the defaulted submission however for stored proc it has to be manoeuvered.Correct me if I am wrong.

Yes, you are right.

By
Vamsi

Report message to a moderator

Previous Topic:	Error While Cancelling PO Line
Next Topic:	report running problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 05:45:43 CST 2024