Monday, August 14, 2017

Cost Manager in Inventory Oracle Application



The Inventory Cost Manager will kick off "Actual Cost Worker" Concurrent Program.
You can see any errors or warning in this concurrent requests.

Basically The Transactions not costed issues are:
1) Cost Cutoff date is past dated for that organization.
2) Cost manager is not Running
3) Tables Space issue
4) Resource Overhead cost issue.

-- Cost Cutoff date
select organization_code, COST_CUTOFF_DATE from apps.mtl_parameters
where organization_id = 114

-- Wip transactions errors
select * from apps.WIP_COST_TXN_INTERFACE
where Process_Status = 3


Select mp.organization_code,transaction_id, mmt.Organization_Id, Inventory_Item_Id, Cost_Group_Id, error_explanation, mmt.*
From Inv.Mtl_Material_Transactions mmt, apps.mtl_parameters mp
 Where Costed_Flag = 'E'
 and mp.organization_id = mmt.organization_id
 order by 1 ;


-- Cost manager Concurrent Request
SELECT request_id requestid, request_date requestdt, phase_code phase, status_code status
  FROM apps.fnd_concurrent_requests fcr, apps.fnd_concurrent_programs fcp
 WHERE fcp.application_id = 702 AND fcp.concurrent_program_name = 'CMCTCM'
 AND fcr.concurrent_program_id = fcp.concurrent_program_id AND fcr.program_application_id = 702 AND fcr.phase_code <> 'C'





No comments:

Post a Comment