My Oracle Support Banner

NDA Report failing at Summery Tabulations with error Argus Safety.COM :- Oracle error 1 occurred.ORA-01403: no data foundORA-06512 (Doc ID 2472271.1)

Last updated on DECEMBER 05, 2019

Applies to:

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

Symptoms

NDA report failed at summery tabulation while generating.

Below is the error message from the error log.

Argus Safety.COM :- Oracle error 1 occurred.ORA-01403: no data foundORA-06512: at line 1SQL: Declare lregreportid number; begin for z in ( ~select CASE_ID, Max(RPT_TYPE_ID) CASE_REV from USER_PRD_CASES_PREV_RPT_PRD where REG_REPORT_ID is not null and user_id = :PI_USER_ID group by case_id~minus ~select CASE_ID, REVISION_NUMBER from rpt_exp_Incl_event ~) loop SELECT REG_REPORT_ID INTO lregreportid from USER_PRD_CASES_PREV_RPT_PRD where user_id = :PI_USER_ID and CASE_ID = z.case_id and rpt_type_id = z.case_rev and rownum<2; gss_util.CASE_EVENT_REVISION_SNAPSHOT(z.case_id, z.case_rev,lregreportid); end loop; end; PL/SQL Call Stack: SQL673 PKG_CONSOLE_COMMON.P_ERROR_LOG1 __anonymous_block


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
Cause
Solution


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