MSCA Misc Receipt Transaction Fails When DFF - Serial numbers (ATTRIBUTEn) is Enabled
(Doc ID 2342782.1)
Last updated on APRIL 04, 2025
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.
Symptoms
Problem Statement
When attempting to perform Misc Receipt of a Serial Number,
the following error occurs.
Error
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.
Title | MTL_SERIAL_NUMBERS (Check eTRM for the details) |
FORM | MSCA |
Serial Attributes | C_ATTRIBUTEn - VARCHAR2(150) D_ATTRIBUTEn - DATE N_ATTRIBUTEn - NUMBER |
Supported | Supported |
Serial numbers |
ATTRIBUTEn - VARCHAR2(150) |
Supported | Not Supported |
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).
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |