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;

请使用浏览器的分享功能分享到微信等