ITPub博客

首页 > 数据库 > Oracle > Costing Transaction Errors (文档 ID 1274319.1)

Costing Transaction Errors (文档 ID 1274319.1)

Oracle 作者:chenshm329 时间:2019-09-11 15:06:49 0 删除 编辑

Costing Transaction Errors In MTL_MATERIAL_TRANSACTIONS table (文档 ID 1274319.1)



Questions and Answers

ERROR GENERIC CAUSES OF CORRUPTION Recommended Solution
CST_MATCH_DATE_PERIOD The acct_period_id in MTL_MATERIAL_TRANSACTIONS table is invalid.

Review Document ID 360117.1

 

CST_MATCH_TXFR_CG_ORG

CST_MATCH_TXFR_CG_TXFR_ORG
CST_NO_CG_ACCTS is triggered when the actual / layer cost worker processes transactions with a cost group / transfer cost group of 1. This is due to a change in view CST_AVG_DIST_ACCTS that both cost worker uses when creating distributions.

CST_INVALID_CG, CST_MATCH_TXFR_CG_ORG or CST_MATCH_TXFR_CG_TXFR_ORG are caused by the validation logic introduced in 11.5.10.

The Common cost group was associated with the project even though there are no accounts defined for the common project. The common cost group is a multi-org cost group and, as such, does not have accounts of its own. The accounts are held at the organization level. Accounts should be entered for a cost group before associating it with a project



Review Document ID 453138.1
CST_NO_TXN_INVALID_ACCOUNT
CST_NO_TXN_INVALID_ACCOUNT CSTPACIN.COST_INV_TXN:An invalid account is associated with the item being transacted
Invalid Account in MTL_MATERIAL_TRANSACTIONS table.

Review Document ID 1941726.1
CSTPACIN.COST_INV_TXN:CSTPACDP.inv_cost_txn (10): ORA-01403: no data found  Subinventory Code and the cost group id are missing in MTL_MATERIAL_TRANSACTIONS table  Review Document ID 246762.1
 CSTPLCIN.COST_INV_TXN:Failure in procedure CST_RevenueCogsMatch_PVT.Process_RmaReceipt The 'RMA Receipt' transaction date is earlier than the reference 'SO Issue'  transaction date   Review Document ID 733275.1
ERROR_CODE= CST_INVALID_INTERORG
ERROR_EXPLANATION= The inter-organization transfer transaction is from and to the same organization
The transfer_organization_id in MTL_MATERIAL_TRANSACTIONS table is incorrect.

Review Document ID 1461380.1

 

CST_INVALID_ACCT_ALIAS Missing TRANSACTION_SOURCE_ID in MTL_MATERIAL_TRANSACTIONS or missing data in MTL_GENERIC_DISPOSITIONS for the corresponding TRANSACTION_SOURCE_ID.

 Review Document ID 428403.1

 




CST_INVALID_WIP Missing data in WIP_PERIOD_BALANCES or missing TRANSACTION_SOURCE_ID in MTL_MATERIAL_TRANSACTIONS table . Review Document ID 1080033.6
CST_INVALID_JOB_DATE The TRANSACTION_DATE precedes the release date of the corresponding job Review Document ID 549311.1

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17087603/viewspace-2656751/,如需转载,请注明出处,否则将追究法律责任。

上一篇: CSTPLCIN.COST_INV_TXN
下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2009-08-09

  • 博文量
    182
  • 访问量
    112811