1. HCM Data Loader
  2. The DELETE Instruction

The DELETE Instruction

The DELETE instruction identifies a business-object component to purge from Oracle HCM Cloud. The component doesn't have to have been loaded using HCM Data Loader.

Instruction Format

The DELETE instruction has this format:

DELETE|<DISCRIMINATOR>|<ATTRIBUTE 1>|<ATTRIBUTE 2>|ATTRIBUTE n>

For example:

METADATA|JobFamily|EffectiveStartDate|EffectiveEndDate|JobFamilyName
DELETE|JobFamily|2012/10/01|4712/12/31|Sales01

Restrictions

These restrictions apply to the DELETE instruction:

  • You can delete a business object or a component of a business object. However, you can't delete individual date-effective records.

  • You can't provide MERGE and DELETE instructions for the same record in a single data file. The order in which HCM Data Loader processes instructions is unpredictable.

  • You can't recover deleted records. Therefore, try to correct data rather than delete and recreate it.

  • Not all business-object components can be deleted. For information about deletion support, see the business-object details available from the View Business Objects page in the Data Exchange work area.

Related Topics