-
查找系统中物料事物处理失败的数据;
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 = 2045067Failing 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;