My Oracle Support Banner

Transaction Historical Summary Does Not Rollback Transaction Dated On Target Date (Doc ID 1369846.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Cost Management - Version 12.1.2 and later
Information in this document applies to any platform.
***Checked for relevance on 1-Apr-2015***

Symptoms


On : 12.1.2 version,

Transaction historical summary report (shortname INVTRHAN) , For balance option, does not rollback from current quantity those transaction dated on target date + 1 at 00:00:00 (ie: if target date is July 31th, then it does not rollback transactions dated on August 1st 00:00:00).

STEPS
-----------------------
(N) Inventory > Change Organization
Organization [Select] (any organization, in this case )
(M) View > Request
Button Submit a new request
Button Ok
Name [Select] Transaction historical summary
Enter parameters:
Select option [Select]  Balance
RollBack to this date [Enter] (any date)
Items from [Enter] (any item)
Items from [Enter] (same item)
Button  Ok
Button Submit
View resulting output
Take note of current and target quantity, current quantity and change quantity
 
(N) Inventory > Transactions > Miscellaneous transaction
Date [Enter] (target date + 1 at 0am)
Type [Select] Miscellaneous receipt
[Button] Transaction Lines
Item [Enter] (same item)
Subinventory [Select] (any subinventory)
Locator [Select] (any locator)
Quantity (any quantity but take note)
Account (any proper account combination)
{Save}
Wait for transaction to be processed and costed.
(M) View > Request
Button Submit a new request
Button Ok
Name [Select] Transaction historical summary
Enter parameters:
Select option [Select] Balance
RollBack to this date [Enter] (any date)
Items from [Enter] (any item)
Items from [Enter] (same item)
Button Ok
Button Submit
View resulting output
Current Quantity changed according to transaction quantity
Error: Target Quantity changed according to transaction quantity
Error: Change Quantity is the same as 1st report submission


To verify that no other transactions were entered between 1st report submission and now, execute the following SQL statement on SQL Plus (should return 1):

SELECT COUNT(1)
FROM MTL_MATERIAL_TRANSACTIONS T
,MTL_SYSTEM_ITEMS_KFV I
WHERE T.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
AND T.ORGANIZATION_ID = I.ORGANIZATION_ID
AND I.CONCATENATED_SEGMENTS = '&ITEM_NUMBER'--ITEM
AND T.CREATION_DATE
BETWEEN TO_DATE('&DD-&MM-&YYYY &HH:&MIN:&SS, 'DD-MM-RRRR HH24:MI:SS') --1ST REPORT SUBMISSION
AND SYSDATE;

Cause

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
Symptoms
Cause
Solution
References


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