Salesrep assigned twice to Compensation Plan resulting in double Calculation
(Doc ID 1063804.1)
Last updated on DECEMBER 03, 2019
Applies to:
Oracle Incentive Compensation - Version 11.5.10.2 and laterInformation in this document applies to any platform.
Symptoms
Some salesreps are assigned to a compensation plan with some roles overlapping causing duplicate commission during calculation
ROLE_ID,SRP_ROLE_ID,START_DATE,END_DATE,ROLE_PLAN_ID,
CREATED_BY,CREATION_DATE
FROM CN_SRP_PLAN_ASSIGNS_ALL
WHERE SALESREP_ID = 100000032;
SRP_PLAN_ASSIGN_ID SALESREP_ID COMP_PLAN_ID ORG_ID ROLE_ID SRP_ROLE_ID START_DATE END_DATE ROLE_PLAN_ID CREATED_BY CREATION_DATE
1436 100000032 1004 21 10024 10808 10/1/2005 12/31/2005 10005 1435 5/15/2006 16:14
=====================================================================================================
1437 100000032 1004 21 10024 10985 1/1/2006 12/31/2090 10005 1435 5/15/2006 16:14
1139 100000032 1004 21 10024 10621 1/1/2004 12/31/2090 10005 1028 4/20/2004 12:50
=====================================================================================================
1317 100000032 1000 21 10011 10808 1/1/2004 9/30/2005 10001 1061 1/10/2006 11:57
Changes
During upgrade, some migration scripts had duplicated rows in CN_SRP_PLAN_ASSIGNS_ALL
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! |