解决:
成本管理器(缩写是CMCTCM)是一个触发“资源成本工作流程”(缩写是CMCCTW)或者“间接成本工作流程”(缩写是CMCOCW)来处理WIP_COST_TXN_INTERFACE表中的资源或者间接资源事务处理的管理器。如果在待定资源实务处理界面的错误信息不够明确,查看“成本工作流程”日志文件能提供更多信息来帮助解决错误。更改调试配置文件:MRP:Debug Mode 设置为“Yes”,CST: Cost update debug level 设置为 “Full"。请在提交成本工作流程之前设置这些配置文件,这样日志文件中会提供更多信息。
1、查看接口表WIP_COST_TXN_INTERFACE发现数据从19号就卡在接口表。
2、备份接口表 create table WIP_COST_TXN_INTERFACE_bak as (select * from WIP_COST_TXN_INTERFACE)
3、更新接口表,让成本管理器重新抓取数据。
Update WIP_COST_TXN_INTERFACE
Set GROUP_ID = NULL,
TRANSACTION_ID = NULL,
REQUEST_ID = NULL,
PROCESS_STATUS = 1
Where PROCESS_STATUS in (1,3)
4、启动成本管理器
可以偿试这个补丁:9323105
Oracle Cost Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
CMCTCM, CMCCTW
.
***Checked for relevance 13-OCT-2012***
Symptoms
When attempting to launch the Cost Manager, the Resource Cost Worker fails with the following error in the 'Resource Cost Worker' logfile:
ERROR:
Concurrent Manager encountered an error while attempting to start your immediate concurrent program &PROGRAM.
Routine &ROUTINE received a return code of failure.
The issue can be reproduced at will with the following steps:
1. Launch the Cost Manager
Cause
In the file cmlctw.lpc, there were two queries which have binding condition between different data types.
This is explained in the following bug:
Bug 9323105 - RESOURCE COST WORKER COMPLETING IN ERROR
Solution
To implement the solution, please execute the following steps:
1. Download and review the readme and pre-requisites for Patch 9323105.
2. Ensure that you have taken a backup of your system before applying the recommended patch.
3. Apply the patch in a test environment.
4. Confirm the following file versions:
cmlctw.lpc 120.0.12010000.3
You can use commands like the following:
strings -a $BOM_TOP/src/cmlctw.lpc |grep '$Header'
5. Retest the issue.
6. Migrate the solution as appropriate to other environments.