CST_MAT_OVERHEAD

CSTPACIN.COST_INV_TXN:Cannot apply material overhead because this level material overhead subelements already exist.

Applies to:

Oracle Cost Management - Version: 11.5.8 to 11.5.10.3 - Release: 11.5 to 11.5
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
On 11.5.8 in Production:
When attempting to cost PO receipt transactions , the following error occurs:


ERROR_CODE =  CST_MAT_OVERHEAD
ERROR_EXPLANATION : CSTPACIN.COST_INV_TXN:Cannot apply material overhead because this level material overhead subelements already exist.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Responsibility: Cost Management Responsibility
2. Wait for Cost Manager to run. Cost Manager completes normal
3. Navigation: Inventory ,Material Transactions:
4. Check Material Transactions:
Repsonsibility: Inventory Super User
5. Transactions -> Material Transactions
Default date from and to: Today’s date,Find
6. Lines complete with status Error
7.Check Material Transactions "Reason, Reference" Tab

Cause

There is no record in mtl_cst_txn_cost_details for the PO receipt transaction.

The following bug was logged for this specific customer to receive a datafix
from Oracle Development:
Bug 6346329: INCTGL TRANSFER TO GL FINISHES WITH MESSAGE ERROR
Oracle Development stated that the issue is due to invalid / incorrect data.

The following SQL identified the invalid / incorrect data:

from inv.mtl_transaction_accounts
where transaction_id = &error txn;

Select *
from inv.mtl_cst_actual_cost_details
where transaction_id = &error txn;


Select *
from inv.mtl_cst_txn_cost_details
where transaction_id = &error txn;

Solution

-- To implement the solution, please execute the following steps::
The issue is resolved by:

1. Ensure that you have taken a backup of your system before applying the recommended solution.

2. Run the following scripts in a TEST environment first:

insert into mtl_cst_txn_cost_details(
transaction_id
,organization_id
,cost_element_id
,level_type
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,request_id
,program_application_id
,program_id
,program_update_date
,inventory_item_id
,transaction_cost
,new_average_cost
,percentage_change
,value_change)
.
select
transaction_id
,organization_id
,1
,1
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,request_id
,program_application_id
,program_id
,program_update_date
,inventory_item_id
,transaction_cost
,null
,null
,null
from mtl_material_transactions
where transaction_id = &error txn;

If this sql also inserts a row with NULL OR ZERO cost, please use following
sql to update the correct cost. PO_UNIT_PRICE has to be provided as input here:
.
update mtl_cst_txn_cost_details
set transaction_cost = &po_unit_price
where transaction_id = &error txn
and cost_element_id = 1
and level_type = 1;


3. Resubmitting the transactions for costing should resolve the issue.

4. If you are satisfied with the results, issue a commit.

5. Migrate the solution as appropriate to other environments.

References

NOTE:316837.1 - Subinventory Transfer Fails With Cstpacin.Cost_inv_txn: (70): ORA-20100

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15225049/viewspace-701532/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15225049/viewspace-701532/