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 laterMicrosoft 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
(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 |