Tuesday, 14 July 2015

CST_INVALID_INTERORG Material Transacton Cost Manager Error

CST_INVALID_INTERORG Material Transaction Cost Manager Error

At the time Actual Cost Worker concurrent, Material transaction struck with CST_INVALID_INTERORG error for Internal sales order Receipt transactions

To Find the Costing error Transactions




select count(costed_flag)total,
costed_flag cslag,
substr(error_code,1,40) code,
substr(error_explanation,1,100) explain
from mtl_material_transactions
where costed_flag in ('E','N')
group by costed_flag,error_code,error_explanation;

Output of the SQL script will be

 12 E CST_INVALID_INTERORG
CST_INVALID_INTERORG

 There is the mismatch or wrong updation in Transfer_Organization_id

Transaction_organization_id is the Source organization id.

XFR_OWNING_ORGANIZATION_ID and XFR_PLANNING_ORGANIZATION_ID is the Receiving organization id.


1. Run the following update statement...
update mtl_material_transactions
set TRANSFER_ORGANIZATION_ID = ,
TRANSFER_COST_GROUP_ID=,
XFR_OWNING_ORGANIZATION_ID = ,
XFR_PLANNING_ORGANIZATION_ID=,
costed_flag = 'N',
error_code = NULL,
error_explanation = NULL,
transaction_group_id = NULL,
transaction_set_id = NULL
where organization_id and transaction_id in (xxx)

2. Select  and submit the Material transaction uncosted lines.