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

Last updated on OCTOBER 15, 2014

Applies to:

Oracle Argus Safety - Version 6.0.2.1 and later
Information in this document applies to any platform.
*** Checked for Relevance 15-Oct-2014 ***

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms