Unexpected Exception In CN_TP_COLLECT_TXNS.collect_transactions ORA-00001: unique constraint (FUSION.CN_TP_TRANSACTIONS_U1) violated

(Doc ID 2095577.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

Collection process ending in error status.

ERROR:
Start of collect transactions
Unexpected exception in CN_TP_COLLECT_TXNS.collect_transactions
SQL code : -1
SQLERRM: ORA-00001: unique constraint (FUSION.CN_TP_TRANSACTIONS_U1) violated

 

STEPS:
Submit Collect Transaction with the following parameters:
Source Business Unit = null
Business Unit = MyBU
Start Date = 2015-09-01
End Date = 2015-09-30
Transaction Type = Billing

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