Un Costed Sales Order Line in R12

UNCosted Lines in Sales Order 　

　

 The number of processed rows in MTL_MATERIAL_TRANSACTIONS:
select count (*)
from MTL_MATERIAL_TRANSACTIONS
where COSTED_FLAG like NULL;
To resubmit the erred records in the MTL_MATERIAL_TRANSACTIONS table, it
must be done via a SQL statement by updating the costed_flag = ‘N’ and the
transaction_group_id = NULL.
Update MTL_MATERIAL_TRANSACTIONS
set COSTED_FLAG = ‘N’,
set TRANSACTION_GROUP_ID = NULL
where COSTED_FLAG = ‘E’ or COSTED_FLAG = ‘N’;



You can also Cross check data with this

We need a test instance to test this script

　

　1. Please run the following SQL to identify the transactions in error.

select * from mtl_material_transactions where costed_flag IN ('E','N');

2. In case the isssue is in the interface table, please run:

select

count(process_flag) total,

process_flag pflag,

substr(error_code,1,40) Code,

substr(error_explanation,1,65) Explan

from

mtl_transactions_interface

group by

process_flag, error_code, error_explanation;

3. Also check the temp table with the sql

select

count(process_flag),

process_flag,

substr(error_code,1,40) Code,

substr(error_explanation,1,65) Explan

from

mtl_material_transactions_temp

group by

process_flag, error_code, error_explanation;