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 |