How to use SQL Validation Statement in Collection Element, is there any specific profile for using S

Hi Team,

How to use SQL Validation Statement in Collection Element, is there any specific profile for using SQL statement in a collection element and how to test the query with in a collection element for accuracy.

I've created a Collection Plan for Daily Inspection of Assets, which also contains a column Inspection Date (Collection Element). Client wants that Inspection Date (Collection Element) should pick Current system date by default. I did setup, but receive an error, below is the complete details;

Create Quality Collection Element with the query "SELECT to_date(sysdate) from dual;", snap is as below

Collection Plan