Crediting Error ORA-12899: value too large for column "FUSION"."CN_TP_1001_CREDIT_WINNERS"."REVENUE_TYPE" (actual: 21, maximum: 15)

(Doc ID 2312139.1)

Last updated on SEPTEMBER 28, 2017

Applies to:

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

Symptoms

Crediting process failed due to REVENUE_TYPE code is longer than 15 characters.  The lookup_code allows user to enter a 30 character length code.

ERROR
Unexpected exception in process_all_mode
SQLCODE : -12899
SQLERRM : ORA-12899: value too large for column "FUSION"."CN_TP_1001_CREDIT_WINNERS"."REVENUE_TYPE" (actual: 21, maximum: 15)
CN_TP_DIRECT_CREDITS.generate_direct_credits.g_exc_error
SQLCODE : 1
SQLERRM : User-Defined Exception
CN_TP_CREDIT_TXNS.generate_credits.g_exc_error
CN_TP_DIRECT_CREDITS.process_all_mode.others
SQLCODE : 1
SQLERRM : User-Defined Exception
End of cn_tp_credit_txns.generate_credits

STEPS
1. Create revenue type lookup codes
    Navigator > Setup and Maintenance > Task : Manage Incentive Compensation Lookups
    Revenue Type Code                                               Meaning
    REVENUE_TYPE_15                                             15 Char Revenue
    REV_TYPE_15_M30                                             15 Character Revenue Type Code
    REVENUE_TYPE_30_CHARACTERS_M15        30 Char Revenue
2. Create Credit Rules
     Navigator > Participant Assignments > Manage Direct Credit Rules
     Hierarchy :  IC Support Direct Credit Hierarchy 2017
            Rule :   Test RevType 15 ( Source Code = REVTYPE15 , IC Salesrep1 , 15 Char Revenue )
            Rule :   Test RevType 15M30 ( Source Code = REVTYPE15M30 , IC Salesrep1 , 15 Character Revenue Type Code )
            Rule :   Test RevType 30 ( Source Code = REVTYPE30 , IC Salesrep1 , 30 Char Revenue )
3. Run Deploy Credit Rules
4. Create Transaction
    Navigator > Credits and Earnings > Create Transaction
          TestRevType15
          TestRevType15M30
          TestRevType30M15
5. Run Crediting ( request_id 388480 )
     ... child assignment jobs ( request_id 388481, 388482, 388483) completed successfully
     ... parent job ( request_id 388480)  - completed with Error status
          Unexpected Error SQLCODE=-12899:SQLERRM=ORA-12899: value too large for column "FUSION"."CN_TP_CREDITS_ALL"."REVENUE_TYPE" (actual: 30, maximum: 15)


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