2594118 - All Userinfo-Element Fields got Deleted When Changing Data Type from Date or Float to Varchar Once a Full HRIS Sync had Been run

All Userinfo-Element Fields got Deleted when Changing Data Type from Date or Float to Varchar Once a Full HRIS Sync had Been run

Employee Central

Employee Profile

Data Change

• Export Succession Data Model
• Change Data Type form Date , Float to Varchar
• Import Succession Data Model

Data Type: Date , Float

<userinfo-element id="CurrentFunctionStartDate" type="date" required="false" reportable="true">
<label>Start date in current function</label>
<label xml:lang="en-GB">Start date in current function</label>
</userinfo-element>
<userinfo-element id="FTE" type="float" required="false" reportable="true">
<label>Work Regime (FTE)</label>
<label xml:lang="en-GB">Work Regime (FTE)</label>
</userinfo-element>

Data Type: Varchar

<userinfo-element id="CurrentFunctionStartDate" type="varchar" required="false" reportable="true">
<label>Start date in current function</label>
<label xml:lang="en-GB">Start date in current function</label>
</userinfo-element>
<userinfo-element id="FTE" type="varchar" required="false" reportable="true">
<label>Work Regime (FTE)</label>
<label xml:lang="en-GB">Work Regime (FTE)</label>
</userinfo-element>

Full Hris Sync job

View test user EP ( Employe profile record)

Run Full Hris Sync job

Result: All Userinfo-element fields got deleted after a Full Hris Sync job

• This is a known issue and reproducible in QACAND.
• The data lost is an escape issue. The issue happens when there is legacy userInfo data in database, then change data type in data model in same case. 

This is a known issue, Please Keep tracking Hris Sync Engineering Ticket: ECT-89664  

Workaround until the release

Step 1: Data Change

• Export Succession Data Model
• Change Data Type to Date and Float 
• Import Succession Data Model

Data Type: Date , Float

<userinfo-element id="CurrentFunctionStartDate" type="date" required="false" reportable="true">
<label>Start date in current function</label>
<label xml:lang="en-GB">Start date in current function</label>
</userinfo-element>
<userinfo-element id="FTE" type="float" required="false" reportable="true">
<label>Work Regime (FTE)</label>
<label xml:lang="en-GB">Work Regime (FTE)</label>
</userinfo-element>

Step 2 : Export all users Userinfos record

• Go to Admin tool-Export Extended User Information
• Export all users records
• Very important: backup your user-infos record before step 4

Step 3 : Import all users Userinfos record

• Go to Admin tool-Import Extended User Information
• Import all users records

Step 4: Run Full Hris Sync job

See Result: All Userinfo-element fields did not change after a Full Hris Sync job

ECT-89153, ECT-89664, Userinfo-element,Data Type, Date , Float, Varchar,Full Hris Sync job , KBA , LOD-SF-EC-HRS , HRIS Sync , LOD-SF-EP , People Profile (Employee Profile / PP3) , Problem