Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
OTBI AnalysisSummary Column not displaying correctlyContent In the OTBI analysis, I need the list of terminated employees, reason for termination and their salary. I am not getting t… -
OTBI Analysis - issue with LEFT OUTER JOINContent Hi, I tried this query and seemed to be not working. It is throwing error saying ' Invalid SQL statement. ( I am using this query just to test the JOIN. ) What w… -
How to report on goal plan assignment?Content Hi, We need to get a report of all the employees and whether they have a specific goal plan assigned to them. This is used to validate that we have assigned the … -
Performance Rating report of Overall Manager ScoreSummary Why do I need to say which section it is in to report it correctly?Content Below is my XML i had to specify the Overall Section otherwise I got completely differ… -
New to Fusion and Need help running a YTD with OTBISummary Can anyone tell me how to run a YTD with OTBI?Content Greetings Folks! I'm new to Fusion and need help running a YTD gross wages report. I found a YTD report in …User_2025-01-28-03-58-03-525 179 views 3 comments 0 points Most recent by User_2025-01-28-03-58-03-525 -
Development Goal ReportContent Hello All, I am attempting to create a report that will show me how many employees have how many development goals in process/not started. This report would be a… -
Position Management - Reporting QueryContent I am trying to create a report using OTBI in R11 which contains all of my Active Positions and some basic data including Manager Name, however within the Subject… -
Emergency Contact Graphs Filtered by Job GradeContent Hello, We are trying to filter our Emergency Contact Graphs to be inline with our Analysis List by reporting by Job Grades. We have used the "SA Table" Workforce…User_2025-01-28-07-12-45-467 61 views 2 comments 0 points Most recent by User_2025-01-28-07-12-45-467 -
Showing Percentages in a Bar PivotSummary Is there a trick to show percentages on a scroll over of a bar pivot with actual values?Content Hello all, I am using OTBI to develop some reports and the user p… -
OTBI Drill down to transactional recordSummary OTBI Drill down to transactional recordContent Is there any way we could drill down from an OTBI analysis to the transactional record to take some corrective act…User_2025-01-22-19-27-16-253 253 views 3 comments 0 points Most recent by User_2025-01-30-01-56-27-828 -
Calculation rounding when expecting decimalsSummary Calculation rounding when expecting decimalsContent I am have a calculation column that I am unable to get it to provide me with decimal results. I have tried ch… -
Flex fieldsSummary Does Flex fields are LDG Specific..?Content I have question on flex fields . are they LDG Specific..? If so how can we control them in LDG if we dont need..? Tha… -
Inserting an Automatic Report Ref Number in OBI AnswersSummary Inserting an Automatic Report Number in OBI AnswersContent Hello, has anyone found a way to insert text in an OBI Analysis that changes automatically? Trying to …User_2025-01-25-03-57-10-561 39 views 2 comments 0 points Most recent by User_2025-01-25-03-57-10-561 -
Location of Performance Document Manager for BIP in Release 11Summary I would like to know the location of Performance Document Manager for BIP reportContent I have a BIP report where the user, manager's name, and the last complete… -
OTBI Report Filters not working in our Production Environment ?Summary OTBI Report Filters not working in our Production Environment ?Content I have copied a report from Preprod using Archive / Unarchive to Prod. When I run the repo… -
Filter that will capture future date assignmentsSummary I created a report that is capturing Action Type: Terminate Work Relationship.I need to filter the report to only show scheduled terminations for a specific mont… -
Performance Score and Bonus AmountContent Hi does anyone have a report or know of the best way to pull a report that would pull an employee's performance score with their bonus eligibility?User_2025-01-25-05-13-06-904 54 views 2 comments 0 points Most recent by User_2025-01-25-05-13-06-904 -
Audit Information on Talent PoolsContent Hi All, We have a requirement to capture who are removed in Talent pools and we are Joined. We enabled the audit for this information. Please share inputs on whi… -
Need to create a BI report for our HR deptSummary Report that shows employees who are on FMLA leave, Military leave and jury dutyContent Hello, This community is a very powerful resource and it is a tad overwhel…User_2025-01-28-05-39-32-316 117 views 2 comments 0 points Most recent by User_2025-01-28-05-39-32-316 -
Need to display %(Percent) in the Horizontal BarsSummary We are unable to display '%"(Percent) value in the Horizontal Bar GraphContent Hi All, I developed Horizontal graph layout through RTF template but I am unable t… -
SIRET Number in OTBISummary Siret Number in subject areasContent Hello , Can someone tell me where can I find the Siret Number in OTBI please. Many thanks Jihene -
Compensation - Salary Details Real Time and Assignment Manager (Unsecured)Summary Compensation - Salary Details Real Time lose people with Assignment Manager (Unsecured)Content We are in R11 and have built a report using subject Area: Compensa… -
Time and Labor OTBI Report ErrorSummary Time and Labor OTBI Report ErrorContent Hi All, I am attempting to create my first Time and Labor report in OTBI. I am currently using the subject aread Human Re… -
OTBI - How to know which folders' fields can be joined to another folders' fieldsSummary OTBI - How to know which folders' fields can be joined to another folders' fieldsContent I am using the subject area Workforce Management - Worker Assignment Rea… -
Line Manager's Display name in reports?Summary Currently all our HCM reports fetch Manager's name field the whole name of line managerContent My need is (I quess other's as well?) to bring line manager's disp… -
Restrict Standard Reviews for manager and specific rolesSummary Restrict Standard Reviews for manager and specific rolesContent hi We want to give Manager and others BI reporting but we do NOT want them to see the standard re… -
National Identifier in fusion tablesSummary Finding the description of the national identifier for each employee in the tables fusionContent Hello, Someone know where can I find the descriptif column of th… -
Talent Pools InformationContent Hi All, In Succession Plans we have different talent pools like "Emerging Leaders", "High Potential" and "Program Manager". Please suggest on which Subject area/… -
attempting to link to custom dashboardSummary attempting to link to custom dashboardContent Hello all I am attempting to link to custom dashboard. I created a sandbox. Activated it. I then Navigated my way t… -
PL/SQLContent Is it possible to use PL/SQL script in BI publisher reports? I see procedure call and NON-standard SQL in the Type of SQL drop down in the DataModel. How do we u…