EBS 在制资源待定事务处理(制造成本工作流程\资源成本工作流程）报错

解决：

        成本管理器（缩写是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.