Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
DUPLICATE USERS ARE ADDED IN PER_USERS — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DUPLICATE USERS ARE ADDED IN PER_USERS

Received Response
27
Views
4
Comments
edited Aug 8, 2019 9:15AM in Applications Security 4 comments

Summary

DUPLICATE USERS ARE ADDED IN PER_USERS due to which journal approval is going into error

Content

Journal approval is going into error.we can't use even a simple rule 1 is 1.

it was identified in OWC session that it is going into error due to duplicate record in user table  and it would require to deletes from per_users table and LDAP. 

select /*SR:3-*/distinct(USERNAME), count(USERNAME) from fusion.per_users group by USERNAME order by count(USERNAME)desc; 

FUSION_APPS_CRM_ESS_APPID 2 
FUSION_APPS_BI_APPID 2 
FUSION_APPS_HCM_ADF_APPID 2 
FUSION_APPS_PROV_PATCH_APPID 2 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!