How to inactivate the Other Classifications for a Department using HDL — Cloud Customer Connect
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 with Redwood: Oracle Cloud SCM and Purchasing

How to inactivate the Other Classifications for a Department using HDL

Summary:

How to inactivate the Other Classifications for a Department using HDL

Content (required):

I tried using the HDL to make the other classification as inactive but it's loading successfully but still display the same in the UI.


HDL:

METADATA|OrgUnitClassification|OrganizationId|OrgUnitClassificationId|EffectiveStartDate|EffectiveEndDate|Status

MERGE|OrgUnitClassification|300000006651769|300000007346934|2023/04/01||I

MERGE|OrgUnitClassification|300000006651769|300000007346931|2023/04/01||I



Code used to fetch the Organization Id and Organization Unit Classification ID.


select

hrorg.ORGANIZATION_ID orgid,

hrorgtl.NAME orgname,

houc.ORG_UNIT_CLASSIFICATION_ID orgunitclass,

hoctl.classification_name Orgunitclassificationname,

hoctl.CLASSIFICATION_CODE orgunitclasscode

from

hr_all_organization_units_f hrorg,

   hr_organization_units_f_tl hrorgtl,

   hr_org_unit_classifications_f houc,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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