查找系统中物料事物处理失败的数据；

SELECT * FROM MTL_MATERIAL_TRANSACTIONS MMT WHERE MMT.COSTED_FLAG = 'E';
如果无数据，查看“实际成本处理程序”【成本管理器】请求的日志，查看具体的报错信息；

SELECT

           T.REQUEST_DATE,

           T.REQUEST_ID,

           T.PHASE_CODE,

           T.ARGUMENT_TEXT,

   SUBSTR(T.ARGUMENT_TEXT,INSTR(T.ARGUMENT_TEXT,',',1,1)+2,INSTR(T.ARGUMENT_TEXT,',',1,2) - INSTR(T.ARGUMENT_TEXT,',',1,1)-2)

FROM FND_CONC_REQ_SUMMARY_V T

WHERE (DESCRIPTION || '(' USER_CONCURRENT_PROGRAM_NAME ||')' LIKE '实际成本处理程序' OR USER_CONCURRENT_PROGRAM_NAME LIKE '实际成本处理程序')) OR (REQUEST_DATE >= TRUNC(SYSDATE-1)))

Inside res_ovhd: Validation in WIP Completion Transaction Interface failed.
Process Status = 3 for TRANSACTION_SOURCE_ID = 2045067

Failing transaction id is 50475405
res_ovhd failed in WIP completion or scrap transactions.
res_ovhd returned error code :1
Processing of Resource or Overhead transactions failed during WIP Completion or Scrap
Records stuck in WIP_COST_TXN_INTERFACE with Process status = 3 (Error ).
查看WIP_COST_TXN_INTERFACE 表中 process_status=3的数据

Update WIP_COST_TXN_INTERFACE
Set Group_Id = NULL, Transaction_ID = NULL, Request_Id = NULL, Process_Status = 1
Where Process_Status = 3;

ITPub博客

EBS-COST：物料分配不产生的问题处理