My Oracle Support Banner

Unable To Generate PBRER Report In Argus Safety Via BIP (Doc ID 2714366.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 8.1.2 and later
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)

Symptoms

Unable to generate PBRER Report in Argus Safety using BI Publisher. The system indicated "ERROR" in Reports -> Compliance -> Background Periodic Report Status screen.

Following detailed error message was logged in Utilities -> Logs -> View error log screen :

 

AS CIP Report.f_before_date:- ORA-20010: ORA-00001: unique constraint
(BIPC_OWNER.PK_GTT_RPT_AGG_EVENT) violated ORA-06512: at "BIP_OWNER.PKG_AGG_RPT", line 501--ERROR while processing p_pop_psur_event_temp AT 04-aUG-2020 09:51:53 ORA-06512:
at "ARGUS_APP.PKG_RPT_LOG", line 53 ORA-06512: at "BIP_OWNER.PKG_AGG_RPT", line 648 ORA-06512: at "BIP_OWNER.PKG_AGG_RPT", line 2636 PL/SQL Call Stack: SQL673 PKG_CONSOLE_COMMON.P_ERROR_LOG 47 PKG_RPT_LOG.P_REP_EXECUTION_LOG2683 PKG_AGG_RPT.F_BEFORE_DATA4 __anonymous_block



Changes

 

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
Changes
Cause
Solution
References


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