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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

We have Multipul records in UI for each employee but we need only latest one that is top one?

in Reporting and Analytics for HCM 8 comments

Summary:

HI Team,

We have Multipul records in UI for each employee but we need only latest one that is top one in below screen short?

Could you please help me on .

Thanks,

Ajay.

Content (required):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

and also we taking PERSON_EXTRA_INFO_ID to find the last record but this also showing wrong.

-----------------------------------------------

AND ppeif.PERSON_EXTRA_INFO_ID = (select max(ppeif2.PERSON_EXTRA_INFO_ID ) from PER_PEOPLE_EXTRA_INFO_F_V ppeif2

where ppeif.INFORMATION_TYPE = ppeif2.INFORMATION_TYPE 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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