Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating User Accounts Using HDL

3048622May 9 2016

Hi All,

I tried creating user accounts using HDL in the same file used for hiring new employees but since source key integration is not available for PersonUserInformation and PersonUserManualRoles, I tried creating a new file (Worker.dat) with the person number but the HDL process failed with the error "After a worker is created you, you cannot update the user information or roles through Worker service. Make updates through the User service."

I tried creating the User.dat file with the required parameters and it also failed with the error "LOGICAL_ACTION NOT PHYSICAL_CORRECTION".  Please find the file content below.

Worker.dat file content:

METADATA|Worker|EffectiveStartDate|EffectiveEndDate|PersonNumber|StartDate|DateOfBirth|ActionCode

MERGE|Worker|2016/05/02|4712/12/31|123456|2016/05/02|1980/06/24|HIRE

METADATA|PersonUserInformation|PersonNumber|StartDate|UserName

MERGE|PersonUserInformation|123456|2016/05/02|ABC123

METADATA|PersonUserManualRoles|PersonNumber|UserName|RoleName

MERGE|PersonUserManualRoles|123456|ABC123|SAMPLE_ROLE_001

User.dat file content:

METADATA|User|PersonNumber|Username|RoleCommonName|AddRemoveRole

MERGE|User|123456|ABC123|SAMPLE_ROLE_001|ADD

Have any of you created user account and added roles to a person using HDL? Please let me know where did I go wrong.

Regards,

Richard

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2016
Added on May 9 2016
0 comments
3,776 views