Saturday, June 16, 2018

Oracle Fusion: sample datafile .dat file to upload HR Job Family


METADATA|JobFamily|SourceSystemOwner|SourceSystemId|JobFamilyId|EffectiveStartDate|EffectiveEndDate|JobFamilyName|ActionReasonCode|ActiveStatus
MERGE|JobFamily|HRC_SQLLOADER|600||1951/01/01|4712/12/31|AA-Pharmaceutical Development||A
MERGE|JobFamily|HRC_SQLLOADER|601||1951/01/01|4712/12/31|AA-Legal||A
MERGE|JobFamily|HRC_SQLLOADER|602||1951/01/01|4712/12/31|AA-Information Technology||A

After sucessfully loading the datafile navigate to My Workforce -> Workforce Structures to validate if all the data got loaded correctly













No comments: