My Oracle Support Banner

Adding Roles Using User HDL - Cannot Supply Multiple Data Lines For The Same Record (Doc ID 2333425.1)

Last updated on MAY 09, 2023

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

Using User.dat HDL file to add roles for the user, if we are passing one row for a person the file gets loaded successfully.

But if pass more than 1 row in user hdl file we get error as below:

You cannot supply multiple data lines for the same record in the same file because the component User is not date-effective.

Here is the sample User.dat HDL

METADATA|User|PersonNumber|RoleCommonName|AddRemoveRole
MERGE|User|fill_PersonNumber|BI_Adminstrator_JOB|ADD
MERGE|User|fill_PersonNumber|PER_EMPLOYEE_ABSTRACT_CUSTOM|ADD
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.