Transaction Date in Receiving Transaction Summary Does Not Match Table Level Transaction Date
Last updated on NOVEMBER 24, 2015
Applies to:Oracle Inventory Management - Version 11.5.10 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.
While reviewing data while generating a report it is found the Received Date in the forms (Transaction Date) and the Received Date in the RCV_TRANSACTIONS Table do not match.
For example see :
Receiving Transaction Summary form
See Date for Receive transaction is 26-JUL-2015 at 20:30
When using Tools > Examine in Block = Lines Folder and Field = Transaction Date the Value = 27-JUL-2015 01:30
It is a 5 hour difference.
In the RCV_TRANSACTIONS table see TRANSACTION_DATE = 27-JUL-15
Why are the values not the same?
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