My Oracle Support Banner

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 AUGUST 20, 2019

Applies to:

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

Symptoms

 On Applications Oracle Argus Safety Version : 8.1

When running the PBRER at customer site 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 remove the Advanced Condition "EXAMPLE_AC_NAME" from the report inclusion criteria


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.