SQL execution error, ORA-01403: no data found, While Running An NDA Report. (Doc ID 1450138.1)

Symptoms

Getting a report execution error while running an NDA Periodic report. The error appears during the PDF generation stage .


The actual error pop up on screen is blank. Below is the error which appears in the cmn_error_log for the report execution failure:

Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-01403: no data found
ORA-06512: at line 1

SQL: 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;

Cause

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