Serial Number FAQ
(Doc ID 417875.1)
Last updated on JULY 23, 2024
Applies to:
Oracle Inventory Management - Version 11.5.10 and laterInformation 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
Purpose
This note is meant to consolidate common serial number issues.
Questions and Answers
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
| Purpose |
| Questions and Answers |
| 1. Basics |
| 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). |
| References |