Integration updates

Action required for customers using Data Lake

The data replication date serialization rules were corrected for these tables:

  • ENT_DETAIL (ENTDET_YEAR_START column)
  • ENTPOLENT_END_DATE (ENTPOLENT_END_DATE column)
  • WB_CUSTOM_DATA (WBCD_DATE1~10 columns)
  • WB_CUSTOM_LOOKUP_DATA (WBCLD_DATE1~10 columns)

To be accessible by Compass queries, upgrading customers must delete the existing data for these tables in Data Lake to match the new schema before running the Data Replication task. Use the Data Lake Purge function for these four data objects to remove all the objects that were created before the upgrade.

After the data objects have been purged, the data in these tables will be replicated when the Data Replication task is restarted.

Replication of custom tables

Support has been added for replicating custom tables in single-tenant cloud deployments. To replicate custom tables, a separate task named Data Replication For Custom Tables must be configured.

For implementation information, see the Infor Workforce Management Configuration Guide for Infor Operating Service – Cloud Edition.

Deleted records generated by archiving are no longer replicated

As of this release, deleted records that are generated by table archiving are no longer replicated to Data Lake. When a record is archived, only the archived record is replicated.

Note: When a record is purged instead of archived, the deleted record is replicated to Data Lake.

Data replication support added for additional WFM tables

Data replication support was added for these additional MVS and Time and Attendance tables:

  • ES_DATA_ELEMENT
  • ES_ROTATION
  • ES_ROTATION_ROW
  • ES_ROTATION_ROW_SKILL
  • ES_ROTATION_STATUS
  • ES_ROTATION_TYPE
  • ES_ROTROW_ASGMT
  • ES_ROTROW_COMMENT
  • ES_ROTROW_DATA_ELEMENT
  • ES_ROTROW_DATA_ELEMENT_LTA
  • ES_ROW_LM
  • ES_ROW_SHIFTS
  • ES_ROW_VERSION
  • ES_ROW_VERSION_BLOCK
  • ES_RRVER_STATUS
  • ES_SHIFT_COMMENT
  • ST_EMP_SKILL
  • ST_SKILL
  • TIME_OFF_TYPE

For more information on the Data Lake integration, see the Infor Workforce Management Configuration Guide for Infor Operating Service – Cloud Edition.