Collect Statistics ORA-00001: unique constraint (FUSION.CN_TP_CREDIT_STATUS_ALL_U1) violated
(Doc ID 3002228.1)
Last updated on FEBRUARY 05, 2024
Applies to:
Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.23.04.0 and laterInformation in this document applies to any platform.
Symptoms
Run Collect Statistics process error.
ERROR
Unexpected exception in CN_TP_REFRESH_STATISTICS.refresh_statistics
SQLCODE : -1
SQLERRM : ORA-00001: unique constraint (FUSION.CN_TP_CREDIT_STATUS_ALL_U1) violated
STEPS
1. Imported Transactions
2. Run Collect Transactions and see that there are some transactions with Collection Error status with event date = 12/31/2022
3. Run Collect Statistics with different date range 8/1/2023 - 8/31/2023 and process error
Cause
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
Symptoms |
Cause |
Solution |