Uncosted Transaction Error: CSTPACIN.COST_INV_TXN:CSTPACDP.inv_cost_txn (10): ORA-01403: no data found (Doc ID 246762.1)

Last updated on SEPTEMBER 21, 2022

Applies to:

Oracle Cost Management - Version 11.5.10.2 and later
Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
FORM:INVTVTXN.FMB - View Transactions
EXECUTABLE:CMCACW - Actual Cost Worker
This document includes all versions of Oracle EBS 11i and R12 and later

Goal

This document provides the detailed instructions for fixing transactions in the MTL_MATERIAL_TRANSACTIONS MMT table with error "CSTPACIN.COST_INV_TXN:CSTPACDP.inv_cost_txn (10)". This issue can occur when Processing Transactions, running the Cost Manager, or Closing an Inventory Accounting Period. The full error that occurs in MMT:

The following errors are different and NOT addressed by this document:

CSTPACIN.COST_INV_TXN:CSTPACDP.insert_account (3) ORA-01403: no data found
CSTPACIN.COST_INV_TXN:CSTPAVCP.interorg (6): ORA-01403: no data found
CSTPACIN.COST_INV_TXN:CSTPACDP.insert_account (10) ORA-01403: aucune donnée trouvée
CSTPACDP.cost_txn30ORA-01403: no data found
CSTPACIN.COST_INV_TXN:CSTPACDP.inv_cost_txn (35): ORA-01403: no data found
CSTPACIN.COST_INV_TXN:CSTPACDP.inv_cost_txn (60): ORA-01403: no data found

This document will also show all the available information regarding the Root Cause of this data corruption.

Please use this document in the following order:
A. Identification Scripts: This will confirm if you are having this data corrution.
B. Verifying your file versions: This will allow you and Support to confirm if you are already using a known fixed version.
C. Root Cause Analysis. It shows all the relevant information about this issue Root Cause.
D. Datafix Intructions. It will provide steps for fixing the data corruption.