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

Like • Show 1 Like1
Comment • 6

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

Boris Lekumovich

Sep 12, 2017 4:02 AM

Correct Answer

As Frank wrote in Termination Date is not populating

Termination date is more complex, since there's additional logic in there.
If collected, and is_terminated is also collected----- When the user becomes terminated, the collected date will be saved. If you attempt to collect into the termination date for someone who is not terminated, it does not save.

See the reply in context

1 person had this question

Outcomes

Boris Lekumovich

Sep 11, 2017 7:42 AM

See if the following helps:

Termination Date is not populating

000028129 - KB-1390 - What date formats are accepted in the collectors

Search in the help section for "Supported Date Formats for Collectors"

1 person found this helpful

Actions

Gunpreet Singh @ Boris Lekumovich on Sep 12, 2017 3:22 AM

Thanks Boris!

Even after using the supported Date formats, Termination_Date is not getting populated.

SQL IDC Query - select TO_DATE(To_CHAR(TO_Date(EMP_TERM_DATE,'MM/DD/YYYY'),'YYYY-MM-DD HH:MI:SS'),'YYYY-MM-DD HH:MI:SS') AS Emp_Term_date
from table_name;

Test Data is showing the correct date as expected.

Raw Data of IDC Run -

Even the raw data for IDC Run is showing correct value (supported date format) but eventually Termination Date attribute in UI is NULL.

Kindly suggest!

Is this a bug in the release Version 7.0.1.116052

Actions

Boris Lekumovich

@ Gunpreet Singh on Sep 12, 2017 4:02 AM

As Frank wrote in Termination Date is not populating

Termination date is more complex, since there's additional logic in there.
If collected, and is_terminated is also collected----- When the user becomes terminated, the collected date will be saved. If you attempt to collect into the termination date for someone who is not terminated, it does not save.

Actions

Gunpreet Singh @ Boris Lekumovich on Sep 12, 2017 4:08 AM

So this means if we collect in another date type RSA attribute, it shall work?

The basic requirement here is we need to perform actions before x no. of days from Term Date as maintained in the Auth system, so need to populate the exact Term date in RSA as well

Actions

Boris Lekumovich

@ Gunpreet Singh on Sep 12, 2017 4:19 AM

Yes. Give it a try.

Create a new custom user attribute and store the future termination date in it.

Actions

Gunpreet Singh @ Boris Lekumovich on Sep 12, 2017 5:08 AM

Yes it worked. Termination Date is handled in a complex way in RSA, other date attributes are working fine.

Thanks Boris!

Actions

6 Replies

Boris Lekumovich Sep 11, 2017 7:42 AM
Mark Correct
Correct Answer
See if the following helps:
Termination Date is not populating
000028129 - KB-1390 - What date formats are accepted in the collectors

Search in the help section for "Supported Date Formats for Collectors"

1 person found this helpful
Like • Show 0 Likes0
Actions
- Gunpreet Singh @ Boris Lekumovich on Sep 12, 2017 3:22 AM
  Mark Correct
  Correct Answer
  Thanks Boris!
  Even after using the supported Date formats, Termination_Date is not getting populated.
  
  SQL IDC Query - select TO_DATE(To_CHAR(TO_Date(EMP_TERM_DATE,'MM/DD/YYYY'),'YYYY-MM-DD HH:MI:SS'),'YYYY-MM-DD HH:MI:SS') AS Emp_Term_date
  from table_name;
  
  Test Data is showing the correct date as expected.
  Raw Data of IDC Run -
  
  Even the raw data for IDC Run is showing correct value (supported date format) but eventually Termination Date attribute in UI is NULL.
  
  Kindly suggest!
  
  Is this a bug in the release Version 7.0.1.116052
  Like • Show 0 Likes0
  Actions
  - Boris Lekumovich @ Gunpreet Singh on Sep 12, 2017 4:02 AM
    Unmark Correct
    Correct Answer
    As Frank wrote in Termination Date is not populating
    
    Termination date is more complex, since there's additional logic in there.
    If collected, and is_terminated is also collected----- When the user becomes terminated, the collected date will be saved. If you attempt to collect into the termination date for someone who is not terminated, it does not save.
    Like • Show 0 Likes0
    Actions
    - Gunpreet Singh @ Boris Lekumovich on Sep 12, 2017 4:08 AM
      Mark Correct
      Correct Answer
      So this means if we collect in another date type RSA attribute, it shall work?
      
      The basic requirement here is we need to perform actions before x no. of days from Term Date as maintained in the Auth system, so need to populate the exact Term date in RSA as well
      Like • Show 0 Likes0
      Actions
      - Boris Lekumovich @ Gunpreet Singh on Sep 12, 2017 4:19 AM
        Mark Correct
        Correct Answer
        Yes. Give it a try.
        Create a new custom user attribute and store the future termination date in it.
        Like • Show 0 Likes0
        Actions
        Gunpreet Singh @ Boris Lekumovich on Sep 12, 2017 5:08 AM
        Mark Correct
        Correct Answer
        Yes it worked. Termination Date is handled in a complex way in RSA, other date attributes are working fine.
        
        Thanks Boris!
        Like • Show 0 Likes0
        Actions

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

Outcomes

Related Content

Recommended Content