My Oracle Support Banner

ORA-01422 when trying to generate PSUR report (Doc ID 2187749.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Attempting to generate a PSUR report, the following error is generated during the "Batch background AG Service process" of the report generation.

Error:
-------
Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "ARGUS_SAFETY_SCHEMA.GSS_PERIODIC", line 9829
ORA-06512: at "ARGUS_SAFETY_SCHEMA.GSS_PERIODIC", line 2716
ORA-06512: at line 1

SQL: BEGIN GSS_PERIODIC.P_CLEAR_PERIODIC_TEMP_TABLES(:PI_USER_ID, :PI_REG_REPORT_ID); END;


Changes

 Upgrade from v7.0.1 to v7.0.4 and data migration

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.