File Line Instructions and File Discriminators
Each line in a data file begins with an instruction, and most lines include a file discriminator. This topic introduces the available instructions and describes the file discriminators.
File Line Instructions
This table identifies the instructions that can appear in an HCM Data Loader data file.
Instruction |
Line Type |
Description |
---|---|---|
METADATA |
Definition |
Identifies the business-object component and the attributes of that component for which you're including values in the data file |
MERGE |
Data |
Provides data to be merged in Oracle HCM Cloud |
DELETE |
Data |
Identifies a business-object component to be purged from Oracle HCM Cloud |
SET |
Control |
Overrides aspects of the default processing for a file |
COMMENT |
Comment |
Adds a comment to the data file |
File Discriminators
METADATA, MERGE, and DELETE lines must include a file discriminator value, which identifies the business-object component to which the instruction applies. For example, the available file discriminators for the Job business object are shown in this table.
Business-Object Component |
File Discriminator |
---|---|
Job |
Job |
Job Valid Grade |
JobValidGrade |
Job Evaluation |
JobEvaluation |
Job Extra Information |
JobExtraInfo |
Job Legislative Extra Information |
JobLegislative |
The file discriminator appears immediately after the instruction in a file line. HCM Data Loader templates for a business object include the file discriminator for each of the object's components. This example shows instructions, the file discriminator, attribute names, and attribute values for the Job business object.
METADATA|Job|EffectiveStartDate|EffectiveEndDate|SetCode|JobCode|Name
MERGE|Job|1950/01/01|4712/12/31|COMMON|CFO|Chief Financial Officer
MERGE|Job|1950/01/01|2013/01/01|COMMON|PM|Manager Projects
MERGE|Job|2013/01/02|4712/12/31|COMMON|PM|Manager Projects
MERGE|Job|1950/01/01|4712/12/31|COMMON|VP_OF_HR|VP Human Resources
MERGE|Job|1950/01/01|4712/12/31|COMMON|PROG_MGR|Program Manager
In this example:
-
The instruction, METADATA or MERGE, appears at the start of the line.
-
The discriminator on all lines is Job.
-
Attribute names appear in the METADATA line after the Job discriminator and separated by the vertical bar character (|).
-
Attribute values appear in MERGE lines after the Job discriminator and separated by the vertical bar character (|).