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 126.96.36.199 [Release 11.5]
Information in this document applies to any platform.
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).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!