MSCA Misc Receipt Transaction Fails When DFF - Serial numbers (ATTRIBUTEn) is Enabled
Last updated on DECEMBER 24, 2017
Applies to:Oracle Inventory Management - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Oracle Warehouse Management - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Information in this document applies to any platform.
When attempting to perform Misc Receipt of a Serial Number,
the following error occurs.
Transaction failed:ORA-06550: line 1, column 13:
PLS-00306: wrong number or types of arguments in call to 'INSERT_SER_TRX'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Steps to Reproduce
- Item is serial number controlled:
Serial Generation At Receipt
- DFF - Serial numbers:
ATTRIBUTES10 is Enabled and set to Required.
- Misc Receipt the serial number through Form:
Serial Entry window requests user to enter ATTRIBUTES10.
- Misc Issue the same serial number through Form
- Misc Receipt the same serial number again through MSCA:
Mobile page doesn't request user to enter ATTRIBUTES10.
- Error occurs
There are two types of serial number related DFF in the system.
(Check eTRM for the details)
|Serial Attributes||C_ATTRIBUTEn - VARCHAR2(150)
D_ATTRIBUTEn - DATE
N_ATTRIBUTEn - NUMBER
ATTRIBUTEn - VARCHAR2(150)
DFF - Serial numbers: ATTRIBUTES10 is Enabled and set to Required.
When receiving a new serial number through FORM, Serial Entry window will request user to enter ATTRIBUTES10. As a result, the receipt succeeds and MTL_SERIAL_NUMBERS - ATTRIBUTES10 is populated.
When receiving a new serial number through MSCA, Serial Entry window will NOT request user to enter ATTRIBUTES10 because it is NOT Supported currently. As a result, the receipt succeeds and MTL_SERIAL_NUMBERS - ATTRIBUTES10 is NOT populated.
The error happens when receiving an existing serial number(status = 4) through MSCA and the same serial number has been received once through FORM (MTL_SERIAL_NUMBERS - ATTRIBUTES10 has been populated).
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