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 and later
Oracle Fusion Incentive Compensation Cloud Service - Version and later
Information in this document applies to any platform.


Deploy compensation plan program ends with an error.


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


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