Tables and Columns : CN_SRP_PARTICIPANT_ALL Does Not Include Numeric Attributes Fields for Use in Calculation Expression (Doc ID 2111828.1)

Last updated on FEBRUARY 29, 2016

Applies to:

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

Symptoms


Descriptive Flexfield CN_PARTICIPANTS_DFF have numeric attribute segments / fields (eg. ATTRIBUTE_NUMBER1).
These numeric attributes are not available in Tables and Columns to be enabled to be used for calculation expression.

EXPECTED BEHAVIOR
Expected to see these numeric attributes similar to CN_PARTICIPANTS_DETAILS_DFF flexfield columns.

STEPS
The issue can be reproduced at will with the following steps:
1. Enable numeric attribute
    Navigator > Setup and Maintenance > Task: Manage Incentive Compensation Descriptive Flexfields
    Flexfield Code = CN_PARTICIPANTS_DFF (Participants)
    a. Create Global Segments "Nick Name" on ATTRIBUTE1
    b. Create Global Segments "Annual Salary" on ATTRIBUTE_NUMBER1
2. Deploy Flexfield
3. Enter value for global segments for participant
    Navigator > Participant Snapshot > Manage Participant Details
    Participant = IC Salesrep1
    Annual Salary = 35000
4. Enable fields to be used in calculation expression
    Navigator > Setup and Maintenance > Task: Tables and Columns
    Business Unit = IC Support BU
    Table Name = CN_SRP_PARTICIPANTS_ALL
    ... ATTRIBUTE1 available to [ Enable for Calculation]
    ... none of the ATTRIBUTE_NUMBER% fields are in the list


BUSINESS IMPACT
Due to this issue, users cannot set participant numeric attributes to be used in calculation expression.

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