Mobile Transactions Failing for Lot Controlled Items with error ORA-06550 ... PLS-00703: multiple instances of named argument in list ... (Doc ID 1947437.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Warehouse Management - Version 12.0.0 and later
Oracle Inventory Management - Version 12.0.0 and later
Information in this document applies to any platform.

Goal

On release 12:

When attempting to perform Account alias receipt transactions for lot controlled items in the mobile (MSCA, MWA / WMS), the following error occurs.

Also, two fields are showing up in Lot Attributes mobile page for the Supplier Lot Number, whereas only one segment is defined for the same in the definition of the Lot Attributes descriptive flexfield. (DFF)

Why is this happening?

Error
[
... : ORA-06550: line 1, column 14: PLS-00703:multiple instances of named argument in list ORA-06550: line 1, column 7: PL/SQL: Statement ignored.
Press any key to continue.
]



NOTES:
Similar error would occur for other kinds of transactions performed in the mobile like PO receipt transactions.
Depending on the mobile page and on the exact release of the E-Business Suite, the error message may begin with "Transaction failed" or "Database error", ...

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms