On running Identity Collection from Oracle HRMS system (via Oracle DB), Termination Date is not getting reflected in RSA System.
Termination Date is mapped in collector with Oracle DB column of type varchar, in the Identity Collection query we are using To_Date function as well to convert string column into Date so that it can be collected into 'Termination Date' RSA attribute.
On running collection, no data is getting stored into termination date even though the date is coming as 'YYYY-MM-DD HH:MI:SS' under Raw data records for that collection
Checked RSA Oracle date format & tried to give same in the query using embedded To_Date & To_Char functions, but still no luck
Kindly suggest any workarounds here