Behavior of Cost Manager:
Cost manager is not a typical concurrent manager that it finishes after is costing some transactions.
Cost manager it is rescheduling itself based on the the process interval specified in interface managers form.
Cost Manager should stay in this status : “Pending Scheduled” and will restart itself based on the process interval specified in interface managers form. It calculates the re-launch time as start time + process interval.
2 – Run the cmclean.sql script available from MOS Note 134007.1
3 – Restart the Cost Manager
Inventory> Setup : Transactions> Interface Managers
Select ‘Cost Manager’ – choose Tools > Launch Manager
Also review << Note 304313.1>>
- Restart the concurrent processes.
- Run the below select and update scripts to update the uncosted and/or erred records in the tables indicated.
- Relaunch the Cost Manager. Select and Update scripts for paragraph 5. above:
SQL> select count(*) from MTL_MATERIAL_TRANSACTIONS where COSTED_FLAG = ‘E’;
SQL> select count(*) from MTL_MATERIAL_TRANSACTIONS where COSTED_FLAG = ‘N’;
SQL > Update MTL_MATERIAL_TRANSACTIONS set COSTED_FLAG = ‘N’, TRANSACTION_GROUP_ID = NULL where COSTED_FLAG = ‘E’ or COSTED_FLAG = ‘N’;
If there are unprocessed records in MTL_MATERIAL_TRANSACTIONS_TEMP, then, also run the following:
- To see if there are records in mtl_material_transactions_temp, run:
SQL> select * from mtl_material_transactions_temp;
- If rows are returned from the SQL in a. above, then run:
SQL> Update MTL_MATERIAL_TRANSACTIONS_TEMP Set PROCESS_FLAG = ‘Y’, LOCK_FLAG = ‘N’, TRANSACTION_MODE = 3, ERROR_CODE = NULL Where TRANSACTION_HEADER_ID = ;
(OR)
Resubmit all transactions using this procedure:
- Shut down the cost manager
- Make a backup of the table mtl_material_transactions
- Perform the following update
SQL > update mtl_material_transactions
set costed_flag = ‘N’,
transaction_group_id = NULL,
transaction_set_id = NULL
where costed_flag = ‘E’ or costed_flag = ‘N’ ;
Commit ;
Update MTL_MATERIAL_TRANSACTIONS set COSTED_FLAG = ‘N’, TRANSACTION_GROUP_ID = NULL where COSTED_FLAG = ‘E’ or COSTED_FLAG = ‘N’;
Uncosted/failed transactions can be resubmitted through the application itself.
Costs -> View Transactions -> Material Transactions.
From the menu, Tools Select All: Tools Submit All
Else, use the following script to submit the records in MMT table:
update mtl_material_transactions MMT set MMT.costed_flag = 'N', MMT.error_code = NULL, MMT.error_explanation = NULL, MMT.transaction_group_id = NULL, MMT.transaction_set_id = NULL where MMT.organization_id = &organization_id and MMT.costed_flag in ('N','E') and NOT EXISTS ( SELECT 1 FROM MTL_TRANSACTION_ACCOUNTS MTA WHERE MMT.TRANSACTION_ID = MTA.TRANSACTION_ID);
commit;
- Re-start the cost manager.
Restart the cost manager via Inventory > Setup > Transactions >
Interface Managers > Tools > Launch Manager. Set up a periodic scheduling interval of every five
minutes.
Note — Cost Manager should not be scheduled through request form to run Periodically.
Cost Manger should be scheduled through Interface managers only.
Comments
Tags: APPS DBA, How To Cancel or Restart the Cost Manager, Interface Managers, Oracle Application, Oracle DBA