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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

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

SQL Join of HCM and UDT tables together

edited Oct 17, 2020 7:05PM in HCM Integrations 2 comments

Summary

SQL Join of HCM and UDT tables together

Content

Hello:

How can i create a SQL join of HCM and UDT tables together in a BIP report?

Can i and do i have to use this package statement?

select FF_USER_TABLES_PKG.GET_TABLE_VALUE_ENT(1, SYSDATE, 'XXHR_UDT', 'COLUMN1', ROW_VALUE) from dual

I need to join 'Person Number to retrieve 'Legal Employer/lCompany' where both Employee and Company are UDT column values.

For instance to join 

SELECT *

FROM UDT u,

           PER_ALL_PEOPLE_F papf

WHERE papf.person_id = UDT.Row_Value ?   - OR- WHERE papf.person_id = UDT.'Column Name'?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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