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 JANUARY 03, 2017

Applies to:

Oracle Argus Safety - Version 7.0.2 and later
Information in this document applies to any platform.


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

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


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