Deploy Compensation Plan Program Ends With User-defined Exception Error (Doc ID 2119019.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

Deploy compensation plan program ends with an error.

ERROR MESSAGE

1 User-defined Exception

 

When debug is enabled the log file shows the following:

SQLCODE : -1400
19480 SQLERRM : ORA-01400: cannot insert NULL into ("FUSION"."CN_SRP_COMP_PLANS_INT"."CUSTOMIZED_FLAG")
19481 Exception in insert_srp_comp_plan_INT
19482 SQLCODE : -1400
19483 SQLERRM : ORA-01400: cannot insert NULL into ("FUSION"."CN_SRP_COMP_PLANS_INT"."CUSTOMIZED_FLAG")
19484 Exception in create_srp_cp_role_INT
19485 Populating the Shadow table for Role based assignment => FAILED



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