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.
SerialNumber.java INVTTMTX RCVRCERC RCVTXER


Symptoms

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
/

Cause

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