Skip to main content
Solved

query users

  • February 23, 2021
  • 3 replies
  • 196 views
N
Hero (Customer)
Forum|alt.badge.img+10
  • NMALKI
  • Hero (Customer)
  • 98 replies

Hi all,

I need a query that list all users that still doesn't have an employee number.  In order to create their employee file.

 

Much appreciate

Thanks

 

Best answer by anmise

Hi all,

I need a query that list all users that still doesn't have an employee number.  In order to create their employee file.

 

Much appreciate

Thanks

 

Which version are you on? For Apps10 I think you should be able to run something like below.

 

select * from PERSON_INFO_ALL where not exists (select 1 from COMPANY_PERSON_ALL where PERSON_INFO_ALL.person_id = COMPANY_PERSON_ALL.person_id) and user_id is not null

 

This topic has been closed for replies.

3 replies

A
Superhero (Employee)
  • anmise
  • Superhero (Employee)
  • 1495 replies
  • Answer
  • February 23, 2021

Hi all,

I need a query that list all users that still doesn't have an employee number.  In order to create their employee file.

 

Much appreciate

Thanks

 

Which version are you on? For Apps10 I think you should be able to run something like below.

 

select * from PERSON_INFO_ALL where not exists (select 1 from COMPANY_PERSON_ALL where PERSON_INFO_ALL.person_id = COMPANY_PERSON_ALL.person_id) and user_id is not null

 

AkilaR
Hero (Partner)
Forum|alt.badge.img+11
  • AkilaR
  • Hero (Partner)
  • 154 replies
  • February 23, 2021

Hi @NMALKI ,

Try below,

SELECT *
  FROM IFSAPP.FND_USER A
 WHERE A.ACTIVE = 'TRUE'
   and a.identity NOT IN
       (Select nvl(PERSON_INFO_API.Get_User_Id(PERSON_ID), PERSON_ID)
          from COMPANY_PERSON_ALL)

Regards,

Akila

N
Hero (Customer)
Forum|alt.badge.img+10
  • NMALKI
  • Author
  • Hero (Customer)
  • 98 replies
  • February 23, 2021

Thanks a lot for your help :)

Terms & ConditionsCookie settingsAccessibility statement