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 220.127.116.11 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.
Import feed CN_COMM_LINES_API
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!