Transaction With Serial Control Item result in mtl_serial_numbers.current_status = 0
Last updated on MAY 15, 2016
Applies to:Oracle Inventory Management - Version 12.1.1 to 12.1.1 [Release 12.1]
Information in this document applies to any platform.
SerialNumber.java INVTTMTX RCVRCERC RCVTXER
When doing transactions serial number get current_status=0
(issue reported happen for miscellaneous and receiving transactions)
This only happens when inventory debug is not turned on.
If INV: Debug Trace= Yes, then status become 3
If INV: Debug Trace= No, then status become 0
Current_status=0 is not a valid status::
select lookup_type, lookup_code, meaning from mfg_lookups
where lookup_type = 'SERIAL_NUM_STATUS'
order by lookup_type, lookup_code
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms