You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

HCM shows addresses with no end date but the raw data does

edited Feb 25, 2019 9:34AM in Human Capital Management 5 comments

Content

Hi,

I have the following

select * from PER_ADDRESSES_F where ADDRESS_ID in (

     select MAILING_ADDRESS_ID from PER_ALL_PEOPLE_F where person_id = XXXXXXXXXX

)

  • It brings me back two rows
  • One object version number is 4 and the other is 5
  • Both had end dates in 2018
  • On HCM, the web front end, there is no end date for this person for the address

Any idea?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!