INVTRHAN - Transaction historical summary: See Transactions After Rollback Date? (Doc ID 2529628.1)

Last updated on MAY 02, 2019

Applies to:

Goal

How are the Transaction Historical Summary (INVTRHAN.rdf) columns calculated using the current and rollback dates?

Concern
See a discrepancy in the "Transactions Historical Summary" report (INVTRHAN) when comparing to inventory transactions.
See transactions in the report for dates AFTER the rollback date.

Example
As an example, run the report on April 11, 2019 with a rollback date of April 10, 2019 -- one day prior. Here is an example of the output:

####### Manufacturing                                                                               Report Date:  11-APR-2019 14:39
Sorted by Subinventory, Item                   Transaction Quantity Historical Summary                     Page:                  1
                                                       Value On: 10-APR-2019
  Category Set:  Inv.Items
  Items From:  JBP Rollback
          To:  JBP Rollback


 Subinventory: FGI
                                 10-APR-2019                                                                               Current
 Item       Description    UOM      Quantity Purchase order        Account Account alias Job or Schedu         Other      Quantity
 ---------- -------------- --- ------------  -------------- -------------- ------------- ------------- ------------- -------------
 JBP        JBP Rollback   Ea         153.00           0.00           0.00          0.00          0.00        101.00        254.00
 Rollback


                                                     **** End of Report ****

Solution

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