Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Need Sql or BI Report to get Element Entry loaded for each Assignment Number ? — Cloud Customer Connect
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 ?

Accepted answer
43
Views
3
Comments

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.

Register

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