My Oracle Support Banner

NRT Either Not Getting Loaded To Item Costs For A Discrete Org Or Getting MULTIPLE AVG COST UPDATES HIT IN THE MTL_MATERIAL_TRANSACTIONS (Doc ID 2463549.1)

Last updated on MARCH 01, 2019

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, GST

ACTUAL BEHAVIOR
---------------
Case 1) NRT not loaded to item cost 

Case 2) Duplicate Avg cost updates have hit in the MTL_MATERIAL_TRANSACTIONS

EXPECTED BEHAVIOR
-----------------------
Expect  NRT to be loaded to item cost no Duplicate Avg cost updates hit MTL_MATERIAL_TRANSACTIONS

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply Recoverable and Non recoverable taxes in the PO and Receipt
2. perform Receive and then Delivery
3. See that the multiple Average cost update have took place for the Nonrecoverable tax amounts

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get the exact cost and so the cost gets hugely inflated

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.