HDL – HDL to Load US EEO Information against location

There are many legislative required attributes defined against location object in HCM. These attributes are setup as EFF in Oracle fusion. These EFF attributes are protected against any updates.

One of the requirements is to bulk upload data against these EFF attributes and HDL can be used for this.

Below is a sample HDL to load “HR Reporting Location” attribute under “United States EEO and Veteran Reporting Information”:

METADATA|LocationLegislative|FLEX:PER_LOCATION_LEG_EFF|EFF_CATEGORY_CODE|_HR_REPORTING_LOCATION(PER_LOCATION_LEG_EFF=HRX_US_LOC_EEO_VETS_INF)|EffectiveStartDate|EffectiveEndDate|SourceSystemOwner|SourceSystemId|SetCode|LocationCode|LleInformationCategory|SequenceNumber|LegislationCode
MERGE|LocationLegislative|HRX_US_LOC_EEO_VETS_INF|HCM_LOC_LEG|Y|1951/01/01|4712/12/31|HRC_SQLLOADER|LOC_1001|COMMON|TEST_LOC_1|HRX_US_LOC_EEO_VETS_INF|1|US

Some of the important fields in above HDL are:

FLEX:PER_LOCATION_LEG_EFF – EFF Context – HRX_US_LOC_EEO_VETS_INF

EFF_CATEGORY_CODE – Should be HCM_LOC_LEG

LleInformationCategory – Should be same as EFF Context – HRX_US_LOC_EEO_VETS_INF

In case any of these attributes are not passed correctly, you will get an error:

An error occurred. To review details of the error run the HCM Data Loader Error Analysis Report diagnostic test.
Message details: JBO-26037: Cannot find matching EO from discriminator columns for view object LocationLegislativeHRX_5FUS_5FLOC_5FEEO_5FVETS_5FINFprivateVOLogical, entity base LocationLegislativeHRX_5FUS_5FLOC_5FEEO_5FVETS_5FINFprivateEO, discr value Discr values: HCM_LOC_LEG..