R12 Cost Manager

R12 Cost Manager

--SQL Query to find out uncosted transactions

SELECT * FROM mtl_material_transactions WHERE costed_flag = 'N';

--Look for costing errors

select
count(*),organization_id,costed_flag
from apps.mtl_material_transactions
where 1=1
and costed_flag is not null
group by organization_id,costed_flag

--