My Oracle Support Banner

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 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Goal

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
(N) Administration
Incentive
External table
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
(N) Transaction
Calculate
Fails as follows:

Failed Calculation (calculation status = XCALC) with
ERROR_REASON attribute of CN_COMMISSION_LINES table
having value = 'ORA-01422: exact fetch returns more than requested number of rows'.



Solution

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
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.