Transaction Date in Receiving Transaction Summary Does Not Match Table Level Transaction Date (Doc ID 2069026.1)

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.

Goal

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?  

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms