Error In PSUR When Using DLP With Case Locked Date > SQL execution error, ORA-20004: ORA-00904: "CLOSE_DATE": invalid identifier (Doc ID 1585581.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

When configure a PSUR with DLP and Case Locked Date as interval inclusion criteria, no cases are returned and the following error can be found in error log table (cmn_error) and the SQLTIMES log file of the AG service task that generates the report.
 
Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-20004: ORA-00904: "CLOSE_DATE": invalid identifier
ORA-06512: at "DLP_APP.PKG_DLP", line 315
ORA-06512: at line 1
SQL: BEGIN PKG_DLP.P_DLP_PSUR_CTPR_FILTER(:PI_INCL_DATE_OPTION, :PI_FROM_DATE, :PI_TO_DATE,:PI_EXCLUDE_FOLLOWUPS, :PI_REPORT_FORM_ID, :PI_USER_ID, :PI_ISPSUR, :PI_LICENSE_CONFIG, :PI_ALL_DATES,:PI_IS_PREVPERRPT_INCL,:PI_PREVPERRPT_FROMDT); END;

The column close_date is a valid column of both tables dlp_case_master and case_master.

Cause

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