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:

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

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