My Oracle Support Banner

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 later
Information 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

SELECT 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
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!

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