Deploy Credit Rule Ends In Error: CN_RS_DENORM_RULES_PVT.process_rule_rank: No Data Found (Doc ID 2135793.1)

Last updated on MAY 09, 2016

Applies to:

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

Symptoms

When attempting to run Deploy Crediting Rules, the following error occurs.

ERROR
End of the procedure CN_RS_DENORM_RULES_PVT.process_rule_rank: no data found


STEPS
1. Create crediting rules using webservices.
    Webservice fails when number of records over 3500.
2. User deleted the parent rule via application
    Navigator > Participant Assignments > Manage Direct Credit Rules
3. Recreate the crediting rules in batches of 3500 records till load in all direct credit rules.
4. Run deploy and got error.

Cause

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 hundreds of Community platforms