DUPLICATE USERS ARE ADDED IN PER_USERS
SummaryDUPLICATE USERS ARE ADDED IN PER_USERS due to which journal approval is going into error
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;