The E2B Difference Report Is Blank - ORA-00001: unique constraint (ESM_OWNER.PK_ESM_DIFFERENCE_REPORT) violated
(Doc ID 2526916.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Interchange - Version 8.1.2 and laterInformation in this document applies to any platform.
Symptoms
Post upgrade from 7.0.0.1 to 8.1.2.2, no E2B Difference Reports can be viewed.
The following error is observed in ERROR_LOG:
ORA-00001: unique constraint (ESM_OWNER.PK_ESM_DIFFERENCE_REPORT) violated
ORA-06512: at "ESM_OWNER.ESM_IMP_DIFF_REPORT", line 171
ORA-06512: at "ESM_OWNER.ESM_IMP_DIFF_REPORT", line 644
ORA-06512: at "ESM_OWNER.ESM_IMP_DIFF_REPORT", line 3714
. Stored Procedure: ESM_IMP_DIFF_REPORT.P_GET_DIFF_REPORT
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 |