Inv_lot_api_pub.auto_gen Package Issue - Start_auto_lot_number Is Changed
(Doc ID 2561356.1)
Last updated on AUGUST 03, 2023
Applies to:
Oracle Inventory Management - Version 12.2.7 and laterInformation in this document applies to any platform.
Symptoms
It is noticed that the lot number sequence for one item has changed drastically. See following example:
- In the Organization Parameters form, Lot Generation is set to "At item level"
- In the Item Define form, Lot Control is "Full", Starting Prefix is set to "X"
- In the MTL_LOT_NUMBERS table, lot numbers and creation dates can be found as follows.
Note that the sequence goes from X60* to X12* and back to X60*.
- X600009232 22-JUN-15
- X600009233 22-JUN-15
- X600015064 01-OCT-15
- X120003599 28-FEB-19
- X120003600 28-FEB-19
- X600000085 07-MAR-19
Cause
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
Symptoms |
Cause |
Solution |