Serial Number FAQ
(Doc ID 417875.1)
Last updated on MAY 27, 2020
Applies to:Oracle Inventory Management - Version 11.5.10 and later
Information in this document applies to any platform.
This document includes all versions of Oracle EBS 11i and R12
FORM:INVTTESR.FMB - Enter Serial Numbers
FORM LIBRARY:INVSLENT.pll - Enter Serial Numbers
This note is meant to consolidate common serial number issues.
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
|Questions and Answers|
|a. What are the forms/programs?|
|b. What tables?|
|c. Important Code / Finding key file versions?|
|2. Serial uniqueness?|
|2a. What is the difference between the various levels of serial uniqueness?|
|2b. Changing Serial Uniqueness|
|3. Serial Status|
|3a. What do the serial status numbers mean?|
|3b. What does serial number status 6 mean?|
|3c. Why serial status remains 5?|
|4. Mark IDs / Locked Serials|
|4a. What is a mark id?|
|4b. Cannot Transact Serial Number with Mark ID Populated / Orphan Serial Numbers|
|5. Serial Control Codes|
|5a. What is the difference between serial generation 'At Receipt' vs. 'At Sales Order Issue'?|
|5b. What Serial Controls are allowed for Inter-Organization Transfers?|
|6. Querying Transactions By Serial After Inter-Organization Transfers?|
|7.Serial and Receiving Topics|
|7a. What does the LOV for Serials in Receiving Look for?|
|7b. Could you explain INV: Restrict Receipt of Serials?|
|8. How to track a serial number across organizations?|
9. How to enter serial number descriptions (or Descriptive Flexfields / DFF)?
|10. Experiencing Performance Issues with Serial Numbers?|
|13. Duplicate Serials Allowed in Sales Order Issue?|
|14. Onhand and Serial Mismatches?|
|15. Correct Mistyped Serials?|
|16. Shipping serial error but item NOT serialized|
|17. API Call|
|a. Example API Call|
b. Using API to generate serials for work orders (Wip Jobs).