1. HCM Data Loader
  2. File Line Instructions and File Discriminators

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 (|).

Related Topics