SQL execution error, ORA-01403: no data found, While Running An NDA Report.
Last updated on OCTOBER 15, 2014
Applies to:Oracle Argus Safety - Version 22.214.171.124 and later
Information in this document applies to any platform.
*** Checked for Relevance 15-Oct-2014 ***
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;
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