AnsweredAssumed Answered

[Identity Collection]: Termination Date is not coming from Oracle DB

Question asked by Gunpreet Singh on Sep 10, 2017
Latest reply on Sep 12, 2017 by Gunpreet Singh

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

Outcomes