Hi,
I was trying to load the SalaryBasis business object in Oracle Cloud HCM (i.e. on release 11) through HDL loader. Below is the SalaryBasis.dat file:
COMMENT Data for Business Object: SalaryBasis Version: V2 Created on: 18-04-2016
METADATA|SalaryBasis|ComponentUsage|Description|ElementTypeId|GradeRateId|InputValueId|Language|LegalEntityId|LegislativeDataGroupId|SalaryAnnualizationFactor|SalaryBasisCode|SalaryBasisId|SalaryBasisName|LegislativeDataGroupName|ElementName|InputValueName|GradeRateName|SourceSystemOwner|SourceSystemId|GUID|Code|SalaryBasisType|AmountDecimalPrecision|AmountRoundingCode|Status|SourceRefTableName=<source-table-name>|SourceRef001=<source-column-001>|SourceRef002=<source-column-002>|SourceRef003=<source-column-003>|SourceRef004=<source-column-004>|SourceRef005=<source-column-005>|SourceRef006=<source-column-006>|SourceRef007=<source-column-007>|SourceRef008=<source-column-008>|SourceRef009=<source-column-009>|SourceRef010=<source-column-010>
METADATA|SalaryBasisComponent|AttributeValue|SalaryBasisId|LookupUsageId|SalaryBasisName|SourceSystemOwner|SourceSystemId|GUID|KeyValue|SourceRefTableName=<source-table-name>|SourceRef001=<source-column-001>|SourceRef002=<source-column-002>|SourceRef003=<source-column-003>|SourceRef004=<source-column-004>|SourceRef005=<source-column-005>|SourceRef006=<source-column-006>|SourceRef007=<source-column-007>|SourceRef008=<source-column-008>|SourceRef009=<source-column-009>|SourceRef010=<source-column-010>
METADATA|SalaryBasisPayRate|BasisPayRateId|SalaryBasisId|PayRateId|DisplaySequence|ValueRequired|UseForMetrics|SourceSystemOwner|SourceSystemId|GUID|SalaryBasisName|PayRateName|SourceRefTableName=<source-table-name>|SourceRef001=<source-column-001>|SourceRef002=<source-column-002>|SourceRef003=<source-column-003>|SourceRef004=<source-column-004>|SourceRef005=<source-column-005>|SourceRef006=<source-column-006>|SourceRef007=<source-column-007>|SourceRef008=<source-column-008>|SourceRef009=<source-column-009>|SourceRef010=<source-column-010>
MERGE|SalaryBasis|USER_DECIDES_USAGE|KK Test USA Annual Sal|||||||1|ANNUAL||KK Test US Annual1|USA LDG|MV Regular Wages|Rate|MS 1|PeopleSoft|testsal|||||||||||||||||
MERGE|SalaryBasisComponent|MERIT|||KK Test US Annual1|PeopleSoft|Test|||||||||||||
MERGE|SalaryBasisPayRate||||1|||PeopleSoft|Test||KK Test US Annual1|Rate1|||||||||||
While loading the above file using HDL, I am facing error- "The value- Rate1 is not valid for attribute PayRateId". When i research this on oracle support, I found attached SalaryBasis business object spreadsheet for HDL load. However I don't find metadata-"SalaryBasisPayRate" details on attached spreadsheet. Can you please help me in understanding "PayRateName" in Oracle Cloud HCM. How that will be linked to SalaryBasis? Where can we configure this in Oracle cloud?
FYI. I was able to load my SalaryBasis file without metadata- SalaryBasisPayRate. Any help would be much appreciated to load SalaryBasis with PayRates.
Thanks,
Kranti