Human Capital Management - EBS (MOSC)

MOSC Banner

Why does'nt the ADD HR button permit per_all_people_f records to be returned. The query behind this

edited Aug 19, 2021 6:13PM in Human Capital Management - EBS (MOSC) 2 commentsAnswered

Why does'nt the PDRTool ‘ADD HR’ button permit per_all_people_f
  records to be returned?  The query
  behind this screen seems to be

SELECT * FROM (select
  PERSON_ID,PERSON_TYPE,USER_PERSON_TYPE,FULL_NAME,ATD,FPD,HOLD_REASON,ERASURE_REQUEST,ON_HOLD,ORG,LOCATION,JOB,POSITION
  from per_drt_add_persons where person_id NOT IN ( SELECT distinct(person_id)
  FROM per_drt_person_data_removals)) QRSLT WHERE (1 = 1 AND UPPER(FULL_NAME)
  like :1) 

which indicates to me that the tool expects the person_id
  to already have been entered  into the
  per_drt REMOVALS table(s)

All I want to do is pull back an employee / HR record as a

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center