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

PAY_ELEMENT_ENTRIES_F - elements entries by assignment

edited Oct 16, 2017 5:16AM in Human Capital Management 3 comments

Summary

Element Entries by Assignment ID

Content

Hi All,   noticed that PAY_ELEMENT_ENTRIES_F tables( used to store the element entries value for employee) does not have an assignment id field but stores data based on person_id level.   this way we will not be able to join on assignment_id and get the element entries per assignments. wanted to check how others get the element entries based on assignment id ( In an SQL) .   should Oracle not store element entries by assignment id or is there any other table which i am missing. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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