How to change the user account status from Inactive to Active using HDL?
To activate an user, HDL USER business object could be used.
Examples of Loading User-Update Requests
-------------------------------------------------------
The USER business object can be used to manage existing users and their roles.
This topic provides examples showing how to create some typical user-update requests.
User.dat samples
Updating a User
----------------------------
This example creates a request to update the user name for the user identified by the specified person number.
METADATA|User|PersonNumber|Username
MERGE|User|<PERSON_NUMBER>|<USERNAME>
This example creates a request to suspend an active user.
----------------------------
METADATA|User|PersonNumber|Suspended
MERGE|User|<PERSON_NUMBER>|Y
This example creates a request to activate a suspended user.
----------------------------
METADATA|User|PersonNumber|Suspended
MERGE|User|<PERSON_NUMBER>|N
This example updates the CredentialsEmailSent indicator, which determines whether an email containing the user credentials is sent to the user.
If the CredentialsEmailSent indicator is Y, then no email is sent. If the indicator is N, then an email is sent. In this example, the indicator is changed from Y to N.
METADATA|User|PersonNumber|CredentialsEmailSent
MERGE|User|<PERSON_NUMBER>|N
----------------------------------------------------------------------
More details can be found in public documentation.
Navigate to https://docs.oracle.com/en/cloud/saas/human-resources/22b/fahbo/index.html and search for "Guidelines for Loading User-Update Requests" or "Examples of Loading User-Update Requests"
Miscellaneous
How to change the username using HDL
METADATA|User|PersonNumber|Username
MERGE|User|123|XYZ