Calculation Errors With XCALC And ORA-01422 When Using External Tables
(Doc ID 468346.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Incentive Compensation - Version 18.104.22.168 to 22.214.171.124 [Release 11.5]
Information in this document applies to any platform.
Calculation ends with XCALC in the CN_COMMISSION_LINES table. Commission is calculated by using data from CN_COMMISSION_HEADERS and an external table. The status of the calculation is showing as Failed Calculation and the ERROR_REASON attribute of CN_COMMISSION_LINES table shows ORA-01422: exact fetch returns more than requested number of rows
The issue can be reproduced at will with the following steps:
(R) Incentive Compensation Super User
Define an external table with calculation usage:
Source table : custom_table
Target table : CN_COMMISSION_HEADERS_ALL
With join between custom_table.salesrep_id and CN_COMMISSION_HEADERS
(N) Incentive Compensation Super User
Fails as follows:
ERROR_REASON attribute of CN_COMMISSION_LINES table
having value = 'ORA-01422: exact fetch returns more than requested number of rows'.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document