My Oracle Support Banner

Wrong Class Revenue ID in CN_COMMMISSION_LINES when Class Overlaps with its Parent (Doc ID 257301.1)

Last updated on MARCH 06, 2019

Applies to:

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


A compensation plan is created with the checkbox : Allow Class Overlap checked.

An external file was imported with mapping on attributes:

TEST_ATTRIBUTE1 = Attribute49
TEST_ATTRIBUTE2 = Attribute39

Both attributes determine a child revenue class : CHILD_REVENUE_CLASS which has as a parent PARENT_REVENUE_CLASS

One plan element is setup with child CHILD_REVENUE_CLASS as a revenue class.  Another plan element is setup with parent PARENT_REVENUE_CLASS as a revenue class.

Then loading feed tables CN_COMMISSION_HEADER and CN_COMMISSION_LINES the loaded line in CN_COMMISSION_LINES has as a revenue_class_id the child revenue class_id
with value 'ROLL' in CREATED_DURING field .

Then run calculation:

A new line is generated in CN_COMMISSION_LINES with the calculation of plan element setup with parent revenue class_id with value 'POP' in CREATED_DURING field .

All calculated amount are ok.

The QUOTA_ID field includes the right plan element in each line (one with the child revenue class and one with the parent revenue class), but the 2 lines in CN_COMMISSION_LINES have the same REVENUE_CLASS_ID which is the child's one.  Therefore the information of the Parent Revenue Class Id for the second Plan Element is not included in CN_COMMISSION_LINES.

Is this the product's design or should the POP (calculation generated) line have in revenue_class_id field the parent revenue class id?


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.