Solved

query users

  • 23 February 2021
  • 3 replies
  • 136 views
N
Rank
Userlevel 5
Badge +10

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

 

icon

Best answer by anmise 23 February 2021, 06:28

View original
This topic has been closed for comments

3 replies

A
Rank
Userlevel 7

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
Rank
Userlevel 6
Badge +11

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
Rank
Userlevel 5
Badge +10

Thanks a lot for your help :)

Terms & ConditionsCookie settings