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

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

   SELECT * FROM MTL_MATERIAL_TRANSACTIONS MMT WHERE MMT.COSTED_FLAG = 'E';

2. 如果无数据，查看“实际成本处理程序”【成本管理器】请求的日志，查看具体的报错信息；

   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 ).

3. 查看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博客 ” ，链接：http://blog.itpub.net/17087603/viewspace-2643612/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17087603/viewspace-2643612/