All Material Transactions Are Erring with Cost_Trx( 1000 ) ORA-01403 no data found (Doc ID 747929.1)

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle Cost Management - Version 12.0.3 and later
Information in this document applies to any platform.
***Checked for relevance 3-NOV-15***

Symptoms

In R12, every Material Cost Transaction worker completes with error. Every Material Transaction
record has an error.   Frozen cost for the items is either zero or a cost value entered.

ERROR
--------
Error_Code = ORA-01403: no data found
Error_Explanation = Cost_Trx( 1000 ): ORA-01403: no data found



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms