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

Building a custom report for pay rates

edited Sep 18, 2018 4:27PM in Reporting and Analytics for HCM 2 comments

Summary

Client is using the newly released salary basis based on rates of pay. There are no OTBI subject areas and need to create a new data model.

Content

The tables holding pay rates are: 

PAY_RATE_CONTRIBUTORS_F
PAY_RATE_DEFINITIONS_F
PAY_RATE_VALUE

Client requires report with a breakdown of the individual pay rates as well as employee data.  They are unable to perform the join.  Does anyone have a prebuilt SQL or can assist?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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