Unexpected Exception In CN_TP_COLLECT_TXNS.collect_transactions ORA-00001: unique constraint (FUSION.CN_TP_TRANSACTIONS_U1) violated
Last updated on JULY 31, 2017
Applies to:
Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.11.1.0 and laterOracle 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