Adding Roles Using User HDL - Cannot Supply Multiple Data Lines For The Same Record

(Doc ID 2333425.1)

Last updated on APRIL 24, 2018

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|12345|BI_Adminstrator_JOB|ADD
MERGE|User|12345|PER_EMPLOYEE_ABSTRACT_CUSTOM|ADD
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms