Oracle EBS MTL_MATERIAL_TRANSACTIONS REASON_ERROR_CODE 物料事务处理错误代码信息参考

Oracle EBS MTL_MATERIAL_TRANSACTIONS REASON_ERROR_CODE 

物料事务处理错误代码信息对应参考


APPS.CST_COSTPROCVALIDATION_PVT dependencies on MTL_MATERIAL_TRANSACTIONS
  -- retrieve material cost worker program ID
   l_concurrent_program_name := 'CMCMCW';

-- retrieve actual cost worker program ID
   l_concurrent_program_name := 'CMCACW';

   -- retrieve layer cost worker program ID
   l_concurrent_program_name := 'CMCLCW';

  -- VALIDATION 7,10: Interorg txns should not be from and to the same org. 
   l_error_code := 'CST_INVALID_INTERORG';

 -- VALIDATION 3,4,5: Txfr txns should have all txfr columns populated. 
   l_error_code := 'CST_INVALID_TXFR';

-- VALIDATION 1: Acct_period_id should match txn date. 
   l_error_code := 'CST_MATCH_DATE_PERIOD';

-- VALIDATION 2,6,8,9,11,12: Cost group validation (non null, must be in ccga or default). 
   -- ignore scrap, wip/inv lot transactions, periodic cost update, pack/unpack, container 
   l_error_code := 'CST_INVALID_CG';

  -- VALIDATION 6,9,12: Txfr CG validation in org (non null, must be in ccga or default). 
   l_error_code := 'CST_MATCH_TXFR_CG_ORG';

 -- VALIDATION 8,11: Txfr CG validation in txfr org (non null, must be in ccga or default). 
   l_error_code := 'CST_MATCH_TXFR_CG_TXFR_ORG';

 -- VALIDATION 13: make sure that acct alias is valid 
   l_error_code := 'CST_INVALID_ACCT_ALIAS';

-- VALIDATION 14: Issues and receipts should have valid subinventories. 
   l_error_code := 'CST_INVALID_SUB';

-- VALIDATION 15, 16: WIP transactions should refer to valid wip entity and be in wpb. 
   l_error_code := 'CST_INVALID_WIP';

  -- VALIDATION 17: txn date not less than job/schedule release date 
   l_error_code := 'CST_INVALID_JOB_DATE';

-- 刘轶鹤

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值