Getting Error ORA-06512: at "ARGUS.SP_CS_FILTER_ADV_COND", line 48 When Running PBRER Report With An Advanced Condition (Doc ID 2576118.1)

Last updated on JULY 13, 2023

Applies to:

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

On Applications Oracle Life Sciences Argus Safety Version : 8.1

When running the PBRER the below error is thrown:

Argus Safety.COM :- Oracle error -1 occurred.

ORA-20004: Please verify the SQL Embedded in Advanced Condition : "EXAMPLE_AC_NAME"

ORA-06502: PL/SQL: numeric or value error

ORA-06512: at "ARGUS.SP_CS_FILTER_ADV_COND", line 48

ORA-06512: at line 1

SQL: BEGIN SP_CS_FILTER_ADV_COND(:PI_REG_REPORT_ID, :PI_AC_ID, :PI_USER_ID); END;

PL/SQL Call Stack: SQL674

PKG_CONSOLE_COMMON.P_ERROR_LOG1 __anonymous_block

The same report runs fine when the Advanced Condition "EXAMPLE_AC_NAME" is removed from the report inclusion criteria.

	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

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