Cannot Transact Serial Number with Mark ID Populated / Orphan Serial Numbers (Doc ID 309710.1)

Last updated on AUGUST 23, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10.0 and later
Information in this document applies to any platform.
This document includes all versions of Oracle EBS 11i and R12 and later

FORM:INVTTMTX.FMB - Inventory Transactions
FORM:INVTOTRX.FMB - Transact Move Orders
FORM:RCVRCERC.FMB - Enter Receipts GUI
FORM:RCVTXERT.FMB - Enter Receiving Transactions GUI


This document is intended to help users successfully setup organizations for the purpose of Intercompany Invoicing through the Oracle Inventory Application.


Symptoms

 

Note: Please use <Note 1472005.1> instead that includes the latest datafix and root-cause patches. Also, check out: <Note 568012.1> "FAQ: Inventory Standard Datafixes" for a full list of common datafixes and the related root-cause patches or existing bugs.

 

Try to transact a serialized item that has a quantity onhand using the Miscellaneous Transaction Form but cannot see a serial number available.
The list of values for the serial number contains no entries.
The following error appears when the user types in the serial number.

Error

FRM-40212: Invalid value for field FM_SERIAL_NUMBER

-OR-

APP-INV-05577: The serial numbers are not available for use in this transaction


Expected Behavior

Expect the serial number to be available in the miscellaneous transaction form and to transact without issue.

Steps
1. Goto Inventory > Transactions > Miscellaneous Transactions
2. Enter the header information including the date, miscellaneous issue, and account.
3. Goto the line details.
4. Enter the item, subinventory, and quantity.
5. Press the Lot / Serial Button.
6. Enter the lot number.
7. Goto the serial numbers.
8. Attempt to enter a serial number, but cannot select any.
9. See the error message noted.

Note: The issue can also arise in other forms like Receiving (RCV) or Work in Process (WIP). For an example in WIP, see <Note 1290344.1>.


Business Impact
Due to this issue, users cannot issue the serialized item out of stores, or receive serials, as they appear already in use.

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