Performance Measure With Value Set in Expression Error : The PL/SQL package for the formula could not be generated. Contact your help desk. (CN-1575389) (Doc ID 2516667.1)

Last updated on JULY 28, 2020

Applies to:

Symptoms

Can not create a valid performance measure with an expression that has a value set.

ERROR

The PL/SQL package for the formula could not be generated. Contact your help desk. (CN-1575389)

STEPS

1) Create Value Set
     Setup and Maintenance > Manage Incentive Value Sets
     Value Set Code = REV_UP_CNTRY
     Module = Incentive Compensation
     Value Type = Table
     Value Data Type = Number
     From Clause = ZCA_REF_ENTITIES rs
     Value Column Name = TO_NUMBER(rs.EXTN_ATTRIBUTE_CHAR029)
     WHERE Clause =
          rs.ATTRIBUTE_CATEGORY = 'PartnerRevenueShareRate_c'
      and UPPER(rs.EXTN_ATTRIBUTE_CHAR026) = 'PERCENT'
      and UPPER(rs.EXTN_ATTRIBUTE_CHAR007) = 'Y'
      and rs.EXTN_ATTRIBUTE_CHAR034 =:1 /* VARCHAR2 */
      and rs.EXTN_ATTRIBUTE_CHAR030 =:2 /* VARCHAR2 */
      and rs.EXTN_ATTRIBUTE_CHAR031 =:3 /* VARCHAR2 */
      and :4 /*DATE*/ >= EXTN_ATTRIBUTE_TIMESTAMP002
      and :4 /*DATE*/ <= EXTN_ATTRIBUTE_TIMESTAMP001
      and rs.EXTN_ATTRIBUTE_CHAR033 = :5 /* VARCHAR2 */

2) Add to lookup code
      Setup and Maintenance > Manage Incentive Lookups
      Lookup Type = ORA_CN_USR_DEFN_EXPRSN_VLE_SET
      Lookup Code = REV_UP_CNTRY

3) Enable columns for Calculation
    Setup and Maintenance > Configure Tables and Columns  
    Table = CN_TP_TRANSACTIONS_ALL
    Column                       User Name                Enable for Calculation
    ATTRIBUTE128             Incoming SKU                 Y
    ATTRIBUTE114             Sub Channel Category     Y
    SOURCE_EVENT_DATE    Source Event Date           Y
    ATTRIBUTE12               EU Country                     Y
    COUNTRY                    Country                          Y

4) Create Expression
    Compensation Plans > Manage Expression > Create
    Name = Test VS Country Exp
    Business Unit = IC Support BU
    Expression =   REV_UP_CNTRY ( Credit.Incoming SKU , 'UPSELL' , Credit.Sub Channel Category , Credit.Source Event Date , Credit.EU_Country )

5) Create Performance Measure
    Compensation Plans > Manage Performance Measure
    Name = Test PM 1
    Performance Interval = Period
    Credit Category = IC Simple CC Premium
    Process Transaction = Individually
    Expression Name = Test VS Country Exp
    [ SAVE and CLOSE ]
    ... performance measure is invalid  
        The PL/SQL package for the formula could not be generated. Contact your help desk. (CN-1575389)

6) If create new expression using COUNTRY field then it's valid
    Name = Test Country Exp
    Expression =  REV_UP_CNTRY ( Credit.Incoming SKU , 'UPSELL' , Credit.Sub Channel Category , Credit.Source Event Date , Credit.Country )

Changes

Cause

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