An Expression With DECODE Function is Not Returning Correct Results. (Doc ID 2010221.1)

Last updated on MAY 14, 2015

Applies to:

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

Symptoms

User has an expression using the DECODE function.  It is not returning the expected / correct value.
If user modify the expression by adding more decode values, the expression becomes INVALID.

STEPS

Navigator > Compensation Plans > Manage Expressions

1. Create expression
DECODE ( Vendor_Code , '9B' , 'Y' , 'AC' , 'Y' , 'QK' , 'Y' , 'YN' , 'Y' , 'ZX' , 'Y' , '3H' , 'Y' , '4N' , 'Y' , 'TS' , 'Y' , '6L' , 'Y' , '5A' , 'Y' , 'JV' , 'Y' , 'J4' , 'Y' , 'MO' , 'Y' , 'C6' , 'Y' , '2T' , 'Y' , '5T' , 'Y' , '9M' , 'Y' , 'EG' , 'Y' , '7F' , 'Y' , 'H3' , 'Y' , 'BH' , 'Y' , 'JB' , 'Y' , 'SG' , 'Y' , 'FK' , 'Y' , '4K' , 'Y' , 'BZ' , 'Y' , 'WJ' , 'Y' , 'HW' , 'Y' , 'J3' , 'Y' , 'PB' , 'Y' , '8P' , 'Y' , 'P6' , 'Y' , 'PD' , 'Y' , '5G' , 'Y' , 'K9' , 'Y' , 'WG' , 'Y' , '9T' , 'Y' , '2R' , 'Y' , 'WT' , 'Y' , '8O' , 'Y' , 'WS' , 'Y' , 'Q5' , 'Y' , 'TZ' , 'Y' , 'ZA' , 'Y' , '3E' , 'Y' , 'ZV' , 'Y' , 'ZP' , 'Y' , 'YI' , 'Y' , 'ZW' , 'Y' , 'FL' , 'Y' , 'AS' , 'Y' , 'J5' , 'Y' , 'G4' , 'Y' , 'AQ' , 'Y' , '0A' , 'Y' , 'HP' , 'Y' , 'AA' , 'Y' , 'MQ' , 'Y' , '2V' , 'Y' , '7S' , 'Y' , 'K7' , 'Y' , 'AD' , 'Y' , 'EV' , 'Y' , '5Y' , 'Y' , '8Q' , 'Y' , 'CH' , 'Y' , '8E' , 'Y' , 'GQ' , 'Y' , '4B' , 'Y' , '1X' , 'Y' , '9K' , 'Y' , '6C' , 'Y' , 'ZQ' , 'Y' , 'OP' , 'Y' , 'MG' , 'Y' , 'S8' , 'Y' , 'RP' , 'Y' , '6P' , 'Y' , '9L' , 'Y' , 'OH' , 'Y' , 'C5' , 'Y' , 'CP' , 'Y' , 'CO' , 'Y' , 'CS' , 'Y' , '3C' , 'Y' , 'DL' , 'Y' , 'AO' , 'Y' , 'EM' , 'Y' , '9E' , 'Y' , 'EO' , 'Y' , '7H' , 'Y' , 'X7' , 'Y' , 'OW' , 'Y' , 'XE' , 'Y' , 'FX' , 'Y' , 'PA' , 'Y' , 'F3' , 'Y' , 'FP' , 'Y' , 'F8' , 'Y' , 'F9' , 'Y' , '2F' , 'Y' , 'YV' , 'G7' , 'Y' , 'GV' , 'Y' , 'ZK' , 'Y' , 'ZO' , 'Y' , 'H6' , 'Y' , 'HA' , 'Y' , 'QX' , 'Y' , '7N' , 'Y' , '2S' , 'Y' , 'WP' , 'Y' , 'B6' , 'Y' , 'M5' , 'Y' , 'JF' , 'Y' , '7Z' , 'Y' , 'BN' , 'Y' , 'J6' , 'Y' , 'XJ' , 'Y' , 'Z1' , 'Y' , 'JI' , 'Y' , 'YX' , 'Y' , 'AL' , 'Y' , 'MC' , 'Y' , 'MW' , 'Y' ,'T2' , 'Y' , 'N7' , 'Y' , 'EJ' , 'Y' , 'NA' , 'Y' , 'NW' , 'Y' , '2G' , 'Y' , 'OY' , 'Y' , '9Q' , 'Y' , '9J' , 'Y' , 'LW' , 'Y' , 'E9' , 'Y' , 'PN' , 'Y' , 'HI' , 'Y' , 'RN' , 'Y' , 'KS' , 'Y' , 'BK' , 'Y' , 'FE' , 'Y' , 'Z3' , 'Y' , 'P1' , 'Y' , 'RW' , 'Y' , 'RD' , 'Y' , 'YR' , 'Y' , 'K5' , 'Y' , 'BB' , 'Y' , '8D' , 'Y' , 'S5' , 'Y' , '3M' , 'Y' , 'OO' , 'Y' , '2E' , 'Y' , 'WN' , 'Y' , 'NK' , 'Y' , 'Z2' , 'Y' , 'SY' , 'Y' , '9X' , 'Y' , '4E' , 'Y' , 'K3' , 'Y' , 'AX' , 'Y' , 'US' , 'Y' , 'UH' , 'Y' , 'U5' , 'Y' , 'UA' , 'Y' , 'X4' , 'Y' , 'NJ' , 'Y' , 'R9' , 'Y' , 'VQ' , 'Y' , 'VX' , 'Y' , 'V2' , 'Y' , '4W' , 'Y' , 'W6' , 'Y' , 'OE' , 'Y' , 'CN' , 'Y' , 'WO' , 'Y' , '8V' , 'Y' , 'XP' , 'Y' , 'YO' , 'Y' , 'N' )

2. Use this expression in a performance measure or plan component

3. Run calculation

4.  Modify the expression and add more decode values, SAVE

5.  When requery the expression, get error message :   View object ExpressionAM.ExpressionDetails1 attempted to fetch rows beyond the row limit

     Note: The Edit Expression section only shows the first 500 sequences.

 

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