Transaction With Serial Control Item result in mtl_serial_numbers.current_status = 0

(Doc ID 1185125.1)

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. 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

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