My Oracle Support Banner

Calculate Earnings Process Ends In Error ORA-01403: no data found (Doc ID 1494028.1)

Last updated on JULY 15, 2020

Applies to:

Oracle Fusion Incentive Compensation - Version 11.1.4.0.0 and later
Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to calculate commission, the following error occurs.

ERROR
Unexpected exception
SQLCODE : 100
SQLERRM : ORA-01403: no data found
End of cn_tp_calculations_pvt.calculate_plan_component with error
cn_tp_calculations_pvt.calculate_comp_plans.g_exc_error
SQLCODE : 1
SQLERRM : User-Defined Exception
cn_tp_calculations_pvt.classify.g_exc_error
SQLCODE : 1
SQLERRM : User-Defined Exception
End of cn_tp_calculations_pvt.calculate for physical batch id : 1 and for phase 1


STEPS
The issue can be reproduced at will with the following steps:
1. Navigate: Credits and Earnings > Manage Calculation Processes
2. Create calculation batch and submit

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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