My Oracle Support Banner

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

Last updated on MARCH 06, 2023

Applies to:

Oracle Inventory Management - Version 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: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.



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.


FRM-40212: Invalid value for field FM_SERIAL_NUMBER


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.

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.


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
 B. Avoiding Future Problems: 11.5.10
 C. Avoiding Future Problems: R12

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.