My Oracle Support Banner

How Is The Value Stored in cst_item_cost_details.ITEM_COST Rounded (Doc ID 3012742.1)

Last updated on MARCH 26, 2024

Applies to:

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

Goal

When entering the cost via UI/Import, the value stored in cst_item_cost_details.ITEM_COST is not rounded.
But after Cost Rollup, some value in cst_item_cost_details.ITEM_COST are rounded.
How is the value stored in cst_item_cost_details.ITEM_COST rounded?

*The UI round the value in Unit Cost field based on Extended Precision. But in this document, it is discussed how the value stored in cst_item_cost_details.ITEM_COST is rounded.

Setup:
1.Confirm the extended precision.
Cost(N)Setup > Financials > Currencies > Currencies
Query the currency.
Extended Precision field shows 5

2.Confirm the BOM is defined.
Bills of Materials(N)Bills > Bills
Query item FG1.
It has Comp1 as a component.

Example1: UI (Not rounded).

1.Navigate to Item Costs form.
Cost(N)Item Costs > Item Costs
(B)Find
Query the item Comp1
(B)Costs

2.On Item Costs Enter following 2 records.
Cost Element:Material
Sub-Element:Material
Basis:.0004

Cost Element:Material Overhead
Sub-Element:Material Mat'lHndlg
Basis Total Value:.00000000000008

3.Save it.

Result:
Unit Cost field for Material Overhead shows 0.00000.(This is because Extended Precision is set to 5.)

select * from cst_item_cost_details
where organization_id = <org_id>
and inventory_item_id=<item_id>;

ITEM_COST shows 0.000000000000000032 (Not rounded).

Example2: Cost Import Process
1.Insert one record into CST_ITEM_CST_DTLS_INTERFACE and issue commit.

INSERT INTO CST_ITEM_CST_DTLS_INTERFACE
(INVENTORY_ITEM_ID
,ORGANIZATION_ID
,COST_ELEMENT_ID
,RESOURCE_ID
,USAGE_RATE_OR_AMOUNT
,PROCESS_FLAG
,GROUP_ID
,BASED_ON_ROLLUP_FLAG
,INVENTORY_ASSET_FLAG
,SHRINKAGE_RATE
,LOT_SIZE

)
VALUES
(
<ITEM_ID for Comp1> ---ITEM ID
,<ORG_ID> ---ORG ID
,1 --cost element id
,41 --sub element id
,0.00000000001 --rate
,1 ---'1'
,CST_LISTS_S.NEXTVAL ---GROUP_ID
,1 ---based_on_roll_up
,1 ---asset_flag
,0 ---shrinkage_rate
,1 ---lot_size
);
2.Run Cost Import Process.
Cost(N)Cost Mass Edits > Import Cost Information.

Result:
select * from cst_item_cost_details
where organization_id = <ORG_ID>
and inventory_item_id=<ITEM_ID for Comp1>
and cost_type_id=3;

ITEM_COST shows 0.00000000001(not rounded)

Example3: Supply Chain Cost Rollup (Rounded)
0.This is continuous of Example2.
1.Run Supply Chain Cost Rollup for FG1.
Cost(N) Supply Chain Costing > Supply Chain Cost Rollup

Result:
select * from cst_item_cost_details
where organization_id = 207
and inventory_item_id=<ITEM_ID for FG1>
and cost_type_id=3;

It shows followings.
level_type:2
Usage_rate_or_amount:0.00000000001
Item_cost:0 (Rounded)

Solution

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
Goal
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.