加载中…
个人资料
  • 博客等级:
  • 博客积分:
  • 博客访问:
  • 关注人气:
  • 获赠金笔:0支
  • 赠出金笔:0支
  • 荣誉徽章:
正文 字体大小:

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

(2023-12-06 18:26:41)
标签:

物料事务处理错误代码

mtl_material_transac

reason_error_code

分类: OracleEBS库存模块
Oracle EBS MTL_MATERIAL_TRANSACTIONS REASON_ERROR_CODE 物料事务处理错误代码信息参考

OracleEBSMTL_MATERIAL_TRANSACTIONSREASON_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';

-- 刘轶鹤

0

阅读 收藏 喜欢 打印举报/Report
  

新浪BLOG意见反馈留言板 欢迎批评指正

新浪简介 | About Sina | 广告服务 | 联系我们 | 招聘信息 | 网站律师 | SINA English | 产品答疑

新浪公司 版权所有