My Oracle Support Banner

CTPR Line Listing Failed When Not Related Inclusion Criteria Is Unchecked (Doc ID 2620057.1)

Last updated on MAY 11, 2020

Applies to:

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

Symptoms

On Applications Oracle Argus Safety Version : 8.1.1

Generating the CTPR Line Listing, and this is failing when 'Not related' inclusion criteria is unchecked

The issue is with all CTPR

If user opts to check the Not-Related option, then the report runs successfully.

The following error is found in the CMN_ERROR_LOG (or when checking [Utilities] - Logs - View Error Log) at time of report run :

Argus Safety.COM :- Oracle error 1 occurred.
ORA-20004: ORA-06502: PL/SQL: numeric or value error: character string buffer
too small
ORA-06512: at "ARGUS_APP.GSS_PERIODIC", line 4366
ORA-06512: at line 1
SQL: BEGIN GSS_PERIODIC.P_PSUR_INCLUSION_FILTER(:PI_REG_REPORT_ID,
:PI_USER_ID, :PI_SERIOUSNESS, :PI_LISTEDNESS,
  :PI_RELATED, :PI_FATAL, :PI_HCP_REPORTER, :PI_PRIMARY_REPORTER,
:PI_REPORT_TYPEID, :PI_DATASHEETNAME, :PI_SERIOUSNESS_SWITCH,
  :PI_RELATED_SWITCH, :PI_LISTEDNESS_SWITCH, :PI_NOT_INCLUDED,
:PI_INCLUDE_UNLOCKED,:PI_ISPSUR,:PI_LICENSE_CONFIG,:PI_REPORT_FORM_ID,
  :PI_ALL_DATES,:PI_ACTIVATION_DATE); END;
PL/SQL Call Stack:
 SQL
673 PKG_CONSOLE_COMMON.P_ERROR_LOG
1 __anonymous_block

 


Steps to Repeat

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.