Skip to main content

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

 

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

 

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

Thanks a lot for your help :)

Terms & ConditionsCookie settings