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

Last updated on APRIL 01, 2015

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, in this case 31-07-2011 , as in Argentina we use dates in  DD-MM-RRRR  format)
Items from [Enter] (any item, in this case  70140553 )
Items from [Enter] (same item, in this case  70140553 )
Button  Ok
Button Submit
View resulting output
Take note of current and target quantity, current quantity and change quantity (in this case 100720, 100720 and 0).

(N) Inventory > Transactions > Miscellaneous transaction
Date [Enter] (target date + 1 at 0am, in this case 01-08-2011 00:00:00)
Type [Select] Miscellaneous receipt
[Button] Transaction Lines
Item [Enter] (same item, in this case 70140553)
Subinventory [Select] (any subinventory, in this case PLANTA1)
Locator [Select] (any locator, in this case NX.00.01)
Quantity (any quantity but take note, in this case 20)
Account (any proper account combination, in this case 51-64011-202-9000-00-00-0000)
{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, in this case 31-07-2011, as in Argentina we use dates in DD-MM-RRRR format)
Items from [Enter] (any item, in this case 70140553)
Items from [Enter] (same item, in this case 70140553)
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 = '70140553' --ITEM
AND T.CREATION_DATE
BETWEEN TO_DATE('18-08-2011 11:59:42', 'DD-MM-RRRR HH24:MI:SS') --1ST REPORT SUBMISSION
AND SYSDATE;

Cause

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