My Oracle Support Banner

Unique Constraint Error Due To Creating Manual Transactions (Doc ID 824573.1)

Last updated on FEBRUARY 07, 2021

Applies to:

Oracle Incentive Compensation - Version to [Release 11.5]
Information in this document applies to any platform.


When creating manual transactions, Oracle Incentive Compensation allows you to create a transaction, then change the values and create another one without navigating back to Transaction > Adjust > New Transaction. 

If you have already created one transaction, Oracle Incentive Compensation allows you to change the Resource Number and create another transaction without first selecting the resource from the list of values.  When you do this, the salesrep_id from the first transaction and the new resource number you entered are associated with the new transaction, which is incorrect.  This causes the below error when trying to load the transactions.

Error ORA-00001 : unique constraint (CN.CN_PROCESS_BATCHES_U3) violated in Package CN_TRANSACTION_LOAD_PUB Procedure Load

Steps To Reproduce:


(R) Incentive Compensation Super User
(N) Transaction


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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