My Oracle Support Banner

Incorrect Transaction Date Sequence For Sales Order Pick & Issue Transactions (Doc ID 1588604.1)

Last updated on DECEMBER 04, 2019

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?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.