My Oracle Support Banner

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 later
Information 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


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