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 with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Can you report on Compensation Zones through an OTBI? If not, is the a SQL query I can use for BI?

in Compensation 3 comments

Summary:

I am able to download the Compensation Zones zip file (Compensation Zones_20240520_040955_180.zip) from going to Setup and Maintenance → Searching Compensation Zones in the search bar → Selecting Compensation Zones with a Functional Area of Base Pay.

Once the Zip File (Compensation Zones_20240520_040955_180.zip) opens and I select the ORA_HZ_GEO_RELATIONSHIP.csv to view the Differential and Postal Code relationships, you can see there are duplicate SubjGeographyNames and ObjGeographyNames. Is there any way to remove the old values from this csv download at the time of download instead of manually removing the duplicate values once the ORA_HZ_GEO_RELATIONSHIP is opened? Or is there a subject area that I can utilize to create an OTBI report to only download the most recent value? If not, can someone please provide a BI SQL query for me to use?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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