Upload Date Type DFF Attributes via Customer Import Template FBDI

Summary:

There is a Business requirement to define DFF of a date type both at Customer Account and Customer Site level, and load it in bulk via FBDI as part of Customer Data migration.

However, the ATTRIBUTE_DATE1, ATTRIBUTE_DATE2 fields that are available on the base table for Customer Accounts and Sites are not available in the HZ_IMP_ACCTSITES_T and HZ_IMP_ACCTSITES_T tab of the Customer Import Template FBDI spreadsheet.

We have found that there is an ER raised for the issue: Enh 28451306 - ATTRIBUTE_DATE COLUMNS TO BE ADDED TO UPLOAD CUSTOMERS SPREADSHEET.

We would like to understand if anyone had a similar requirement and if there is any workaround for it other than creating a DFF with data type as Character.