My Oracle Support Banner

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

Last updated on MAY 02, 2019

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
REPORT:INVTRHAN.RDF - Transaction historical summary

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

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
Goal
Solution


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