My Oracle Support Banner

Error While Running The PSUR For Product Oracle error 8197 occurred.SQL execution error, ORA-20004: ORA-00001: unique constraint (Doc ID 2052370.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 7.0.4 and later
Information in this document applies to any platform.

Goal

 While Running the  PSUR report for a product you receive the error at Loading line listing case information

The corresponding entry in the error log is

Argus Safety.COM :- Oracle error 8197 occurred.SQL execution error, ORA-20004: ORA-00001: unique constraint (ARGUS_APP.PK_USER_PSUR_CASES) violatedORA-06512: at "ARGUS_APP.GSS_PERIODIC", line 5628ORA-06512: at line 1SQL: BEGIN GSS_PERIODIC.P_USER_PSUR_CASES(:PI_REG_REPORT_ID, :PI_USER_ID, :PI_PRIMARY_CONTACT, :PI_INDICATE_SUBMITTED, :PI_AGENCY_ID, :PI_ISPSUR, :PI_LICENSE_CONFIG, :PI_REPORT_FORM_ID); END;

 

Solution

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
Goal
Solution


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