INVTRHAN - Transaction historical summary: See Transactions After Rollback Date?
(Doc ID 2529628.1)
Last updated on MARCH 28, 2022
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterInformation 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 |