Date filter in Custom Security Handler

Hello everyone,

I'm currently facing an issue with a custom security handler for filtering date formats in an ECC custom security package. I've successfully filtered string and numeric attributes, but I'm encountering problems when filtering date attributes.

In my example, I'm trying to filter the creation_date using the following query:

SELECT DISTINCT prl.creation_date BULK COLLECT INTO l_creation_date_lines FROM apps.po_requisition_lines_all prl WHERE prl.creation_date > SYSDATE - 180;

In PL/SQL, the default date format is DD/MM/YYYY. However, when I execute the package, ECC returns the following error:

core_ecc/po-pcc-requisitions: Invalid Date String: '11-SEP-24'