We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Need Sql or BI Report to get Element Entry loaded for each Assignment Number ?

Received Response

Summary: I am loading Element Entries in Fusion Cloud on different Assignments as part of Conversion, I need a SQL or BI Report which would pull the loaded data (atleast the Assignment Number and Element Entry data)

Content (required):

Hello Experts,

We tried to join person_id of PAY_ELEMENT_ENTRIES_F table with person_id of PER_ALL_ASSIGNMENTS_M table (PAY_ELEMENT_ENTRIES_F.PERSON_ID = PER_ALL_ASSIGNMENTS_M .PERSON_ID), but since person id is same for all the assignments it is cross joining with all the assignment and we are getting cartesian product as output.

Howdy, Stranger!

Log In

To view full details, sign in.


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