Serial Number Datafix Extension / Personalization / Customization [Video]
(Doc ID 761153.1)
Last updated on AUGUST 15, 2018
Applies to:Oracle Inventory Management - Version 11.5.10 and later
Information in this document applies to any platform.
FORM:INVTTESR.FMB - Enter Serial Numbers
How can one fix serial numbers that are locked from user (marked) without having a technical person run a SQL datafix to fix them?
A mark is the application's way of saying a serial number is locked or reserved by another process already. Sometimes a process will end without releasing that lock and the serial number remains marked.
There is no way in the Oracle Applications currently to unmark the serial numbers.
(This is just an example navigation as serial numbers are seen in many modules)
Navigate to Inventory > Transactions > Miscellaneous Transactions
Try to perform a miscellaneous issue for an item
Can see the item and onhand quantity but find no serials available to select.
Navigate to Inventory > Onhand > Serial Numbers
Query the serial numbers.
See a list of serial numbers but there is no way to see the serial number is marked, or to unmark them.
Right now, users must request the technical team to run the script to fix data. If the script was integrated into the Oracle Applications, it could be run directly by users.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!