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 JULY 13, 2023

Applies to:

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

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