PAC: Unexpected Cost for Miscellaneous Issue With Zero Cost (Doc ID 2225700.1)

Last updated on FEBRUARY 04, 2017

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
After PAC processes ran, cost is calculated as below on CST_AE_LINES. But fourth transaction cost is unexpected.

1.Miscellaneous Receipt -- Quantity:1 -- Unit Cost :0 (Not null)
transaction_date=2016-07-20

2.Miscellaneous Issue -- Quantity:1 -- Unit Cost:1248158
transaction_date=2016-07-20

3.Miscellaneous Receipt-- Quantity:1-- Unit Cost:1248156
transaction_date=2016-07-20

4.Miscellaneous Issue -- Quantity:1-- Unit Cost:0 (Not null)
transaction_date=2016-07-20

* There is no initial balance for the item at the beginning of July 16.

On CST_AE_LINES, we see distribution records are created as below.

1.Misc Receipt
DR:Inv valuation:0
CR:Account:0

2.Misc Issue
DR:Account:1248158
CR:Inv Valuation:1248158

3.Misc Receipt
DR:Inv valuation:1248156
CR:Account:1248156

4.Misc Issue
DR:Inv valuation:2
DR:Cost variance:2
CR:Account:4

EXPECTED BEHAVIOR
Cost of fourth transaction (Misc issue) should be set as below;
DR:Inv valuation:2
DR:Account:0
CR:Cost variance:2

After performing all these transactions, balance is (1*0-1*1248158+1*1248156-1*0)= -2 ,quantity is zero,and -2 will become the variance amount which stamped into the last cost owned transaction, for forth transaction. Hence the accounting for that is Debit: Inv valuation 2 , offset account 0 and Credit: Cost variance 2.

 

Changes

 

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