You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

how to load HDL for inactivating existing Department

Summary:

Can yo please suggest how to load HDL for inactivating existing Department?

Content (required):

We have same old Departments to be inactivated and I used the following HDL:

METADATA|Organization|EffectiveStartDate|EffectiveEndDate|ClassificationCode|InternalAddressLine|LocationCode|LocationSetCode|Name|OrganizationId

MERGE|Organization|2023/04/01|4712/12/31|DEPARTMENT||LOCATION_1|SET1|Department_XX|300000109164000

METADATA|OrgUnitClassification|EffectiveStartDate|EffectiveEndDate|ClassificationCode|LegislationCode|OrganizationId|SetCode|Status

MERGE|OrgUnitClassification|2023/04/01|4712/12/31|DEPARTMENT||300000109164000|SET1|I

I am getting the following error:

The line for component {DISCRIM} with instruction {INSTR} doesn't include values that define a unique reference to the record. Include values for at least one of the supported keys.

Any idea what I am missing?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!