My Oracle Support Banner

Calculation Fails With ORA-01403 in Column Error_Reason (Doc ID 248915.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Incentive Compensation - Version 11.5.8 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

Calculation fails for some transactions and no errors are reported in the calculation log.  Transactions not calculated have a status of XCALC.

The column ERROR_REASON in the table CN_COMMISSION_LINES for transactions with status XCALC shows the following error:

ORA-01403: No data found.

Column RATE_TIER_ID in the table CN_COMMISSION_LINES for transactions with status XCALC has been populated with 0 (zero).

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.