Deploy Compensation Plan Process is Not Assigning the Compensation Plan for a Role to Participants. (Doc ID 1609106.1)

Last updated on JUNE 20, 2017

Applies to:

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

Symptoms

User create a compensation plan "Q22013 TEAM1 REP SEG3" and assign it to role "Team1 REP SEG3".
Run plan deployer process and it completed successfully but the compensation plan is not assigned to any participant that is assigned to the participant.

Process might complete with status = Succeeded or have the following error message :

ERROR

...
CnSrpFormRateTablesPkg : insert into rate value only if customized flag is Y
CnSrpFormRateTablesPkg : End of insert_record with SUCCESS
No intersection of role-compplan and role-srp start date and end date
No intersection of role-compplan and role-srp start date and end date
No intersection of role-compplan and role-srp start date and end date
No intersection of role-compplan and role-srp start date and end date
No intersection of role-compplan and role-srp start date and end date
No intersection of role-compplan and role-srp start date and end date
No intersection of role-compplan and role-srp start date and end date
CnSrpFormRateTablesPkg : Out of insert in formula rate table
CnSrpFormRateTablesPkg : insert into rate value only if customized flag is Y
CnSrpFormRateTablesPkg : End of insert_record with SUCCESS
CnSrpFormRateTablesPkg : Out of insert in formula rate table
CnSrpFormRateTablesPkg : insert into rate value only if customized flag is Y
CnSrpFormRateTablesPkg : End of insert_record with SUCCESS
CnSrpFormRateTablesPkg : Out of insert in formula rate table
CnSrpFormRateTablesPkg : insert into rate value only if customized flag is Y
CnSrpFormRateTablesPkg : End of insert_record with SUCCESS
SQLCODE : 100
SQLERRM : ORA-01403: no data found
Exception in CN_SRP_COMP_PLANS_PKG.insert_record
SQLCODE : 100
SQLERRM : ORA-01403: no data found
Other Exception in CN_SRP_COMP_PLANS_PVT.create_srp_comp_plan_role


EXPECTED BEHAVIOR
Any participant assigned to role "Team1 REP SEG3" should also get compensation plan "Q22013 TEAM1 REP SEG3". 

 

STEPS
1. Create compensation plan "Q22013 TEAM1 REP SEG3"
2. Assign role "Team1 REP SEG3" to compensation plan
3. Run Deploy Compensation Plans
    Navigator > Participant Assignments > Deploy Compensation Plan

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