My Oracle Support Banner

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

Last updated on JANUARY 03, 2022

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

Determining hierarchy for rule : 300000017486125
End of the procedure CN_RS_DENORM_RULES_PVT.process_rule_rank: no data found
CN_RS_DENORM_RULES_PVT.process_rule_rank API has failed
End of the procedure CN_RS_DENORM_RULES_PVT.process_attr_and_rank:
FND_API.G_EXC_ERROR exception
End of the procedure CN_RS_DENORM_RULES_PVT.process_rule_rank: no data found
CN_RS_DENORM_RULES_PVT.process_attr_and_rank API has failed
End of the procedure CN_RS_SYNC_RULE_ENGINE_PVT.gen_rule_engine_incremental
FND_API.G_EXC_ERROR exception
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

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
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.