Thursday, 2 July 2015

How to update uncosted or error costed transactions for reconsideration by Cost Manager for Costing

update mtl_material_transactions
set costed_flag = 'N',
error_code = NULL,
error_explanation = NULL,
transaction_group_id = NULL,
transaction_set_id = NULL
where organization_id = &organization_id
and costed_flag in ('N','E');

No comments:

Post a Comment