My Oracle Support Banner

Item Cost Calculated As Average Cost Instead Of FIFO. Cost Type Setup As FIFO (Doc ID 1527911.1)

Last updated on JUNE 05, 2018

Applies to:

Oracle Cost Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Inventory Costing

ACTUAL BEHAVIOR
---------------
We have setup cost type as FIFO, but for Item 'XXXX' there are several layers created by the Item Cost calculated as Average Cost instead of FIFO.


EXPECTED BEHAVIOR
-----------------------
costs to be calculated correctly

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Cost Management
2. Update layer costs
3. Organization S01
4. Item XXXX
5. CG-0000
6. Layer cost update transactions > Average Cost = 26,300.50/20 = 1315.025 (which matches with Item Cost)
7. The cost type setup is FIFO. Then why system is calculating item cost as Average Cost?



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!


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