Incorrect Transaction Date Sequence For Sales Order Pick & Issue Transactions
Last updated on AUGUST 21, 2016
Applies to:Oracle Inventory Management - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
When releasing a Sales Order , Transactions Creation Dates and IDs are correctly numbered.
When releasing a Sales Order , 3 Material Transactions occurr -named:
-- 2 pick transactions to move the product from the sub inventory to the transit sub inventory
-- Sales Order issue transaction
These 3 Material Transactions have to run after each other. These transactions got right IDs (xxxxx01 and xxxxx02 for picking and xxxxx03 for the issue one that they are consecutive as it has to be) but the transactions dates are wrong (first 1392/05/26 16:19:24 for the issue trigger that makes it before the others and 16:19:27 for the others that makes them after issue) so the primary quantity of the transit sub inventory will be negative for 3 seconds and it will be mentioned in some reports (Custom Reports)
Need help to know how to make the transaction date consecutive like transaction IDs?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms