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 JUNE 29, 2017

Applies to:

Oracle Argus Safety - Version 7.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 29-JUN-2017***

Goal

 While Running the  PSUR report for a product we are facing the error at Loading line listing case information

The respective error log noticed for that error while running the draft PSUR report 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

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