Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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.

Regarding Supervisor Field along with Line Manager in OTBI analysis

edited Mar 4, 2019 4:46PM in Reporting and Analytics for HCM 4 comments

Summary

Fetching Supervisor Field from Matrix Manager Folder and Line Manager from Worker Folder in OTBI analysis

Content

In the current Oracle release of 19A , we observed that the Supervisor field which we tried to fetch from Matrix Manager is not returning any value even though we have Supervisor details for a person at front end. Due to which the entire result of the report having other columns as well like ( Person Number, assignment Number, Name, Location,....) is getting 'No result ' in the result tab. 

Therefore , we tried to build the report through logical query having Supervisor column Left Outer join with the Person Number and other column required. Though the report fetched the rows of the person with other information but the supervisor column is NULL. Another challenge of using this logical SQL query approach is that any further modification leads to create the entire query again having those changes.Another major issue using this is that , we came to know that in coming future the Logical SQL query approach will no longer be supported by the Oracle which will create problem during

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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