請教一個 cost manager 問題:

tsanshun

請教一個 cost manager 問題:
ｄｅａｒ all請教一個 cost manager 問題:===========================cost managerview transactions-pending resource transactions-phase= Resource processing-status=Pending-type=Resource transactiontype=Overhead transaction解決方式：＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝Step no 1:-============Step 1SELECT request_id RequestId,request_date RequestDt,phase_code Phase,status_code StatusFROM fnd_concurrent_requests fcr,fnd_concurrent_programs fcpWHERE fcp.application_id = 702AND fcp.concurrent_program_name = 'CMCTCM'AND fcr.concurrent_program_id = fcp.concurrent_program_idAND fcr.program_application_id = 702AND fcr.phase_code <> 'C'Cancel all the requests from the above output.Step 2:-============c) Perform the following updateUPD ATE mtl_material_transactionsSET costed_flag = 'N',transaction_group_id = null,error_code = null,error_explanation = null,cost_update_id = nullWHERE costed_flag in ('N','E');CommitStep no 3=========Set the MRP DEBUG mode to Yes(Profile option)Lauch the cost Manager and then Provide the log filesAs i explained before ..If you are using Average Costing? the cost manager will not launch a worker if you have erred or pending records in the Mtl_material_transactions (MMT) table - the View Material Transactions screen,or the WIP_Cost_txn_interface (WCTI) table - the Pending Resource transactions screen. Please provide the following script outputs in Excel Spreadsheet format so we can check this:select transaction_id, last_update_date, request_id,inventory_item_id, organization_id, subinventory_code, locator_id, cost_group_id, transaction_type_id, transaction_action_id, transaction_source_type_id, transaction_source_id, transaction_source_name, transaction_quantity, transaction_date, acct_period_id, distribution_account_id, costed_flag, transaction_group_id, actual_cost, transaction_cost, prior_cost, new_cost, completion_transaction_id, task_id, project_id,error_code,error_explanation from mtl_material_transactionswhere costed_flag IN ('N', 'E');select transaction_id, last_update_date, last_updated_by,creation_date,created_by, group_id, request_id, process_phase, process_status, transaction_type,organization_id, wip_entity_id, wip_entity_name, entity_type, repetitive_schedule_id, transaction_date, acct_period_id, transaction_quantity,primary_quantity, actual_resource_rate, move_transaction_id, completion_transaction_id, rcv_transaction_id, po_header_id, project_id,task_id, project_number, task_numberfrom wip_cost_txn_interface;－－－－－－－－－－－－－－－－－－－－－請問：１．ｗｈｙ　ｐｅｎｄｉｎｇ還有．　　ｃｏｓｔ　ｍａｎａｇｅｒ　Active　　都ｒｕｎ　了，有執行了．　　Move transaction　Active．２．ｐｅｎｄｉｎｇ　解不了．是作標準成本．ａｎｈｓｕｎ＿ｔｗ
__________________ＥＲＰＳＨＯＰＦＬＯＯＲＣＲＭ