Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Sunday, 5 February 2017

Query to Check for Multiple/Duplicate Logins

The relevant query is as follows:

1. Get the person_id for the employee
    select person_id     from per_people_f
    where last_name like &LASTNAME

2. Now use the person_id in the following SQL
    select count(*) from wf_users
    where orig_system_id = &PERSON_ID
    and status = 'ACTIVE'
If count is greater than one, you got duplicates

Share this article :


  1. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.