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 Ethnicity ReportingSummary: Event headcount is incorrect. Showing 2 when employee has more than one ethnicity selected. Content (required): I'd love a second set of eyes on this. On recomm… -
How to create an advanced OTBI reportSummary: Short video describing how to create an advanced OTBI report using a calculated column and binning. Content (required): https://www.youtube.com/watch?v=YNcSgOvw… -
Not able to hide the delete button from a reportSummary: Content (required): Hi Expert, We have a requirement to hide the delete button from a report. But we are not able to delete the button. We are using a custom ro… -
SQL to calculate overall tenureSummary: Content (required): I am working on a BIP report and I would really appreciate if I get some help with the SQL to calculate the overall tenure of the employee w… -
BIP Report - Department HierarchySummary: Does anyone tried creating report in BIP with department levels such as Department Level 1-8. Kindly share the sample query. Thanks Content (required): Version …
-
In BIP, when clicking on the download button in PDF output, an HTML file is downloadedSummary: The issue is when clicking on the download button in PDF output, an HTML file is downloaded instead of a PDF. Would there be any setting to set in the BIP repor… -
Report on scheduled Extracts and BI reportsHow to get a report on all the extract and BIP reports scheduled in system with frequency of schedule? Regards, Nivya -
Goals Report showing Draft StatusSummary All Drafts Status Goals before a certain dateContent Hi, I've been asked to build a report that shows anyone who had a 'Draft' status to their 2020 Goals prior t… -
Dashboard take minutes to show resultsSummary: We have a dashboard that presents the result of review documents on one tab and goals on a second tab. When opening the dashboard, it takes quit some time befor…
-
Pull data for a specific person number when there are multiple Person numbers in the dataSummary: I am trying to pull management level for the manager's job vs the employee using OTBI report Content (required): I am using workforce assignment real time - how…
-
Issue-Line Manager getting employee's all assignments performance documents details in OTBI reportSummary: I am working on one OTBI report to fetch the details of performance document for line manager. Employee who are having two Active assignments and both assignmen…
-
How to get the employees' latest assignment data and the effective start date of the TOS position thSummary How to get the employees' latest assignment data and the effective start date of the TOS position through OTBIContent Hello, I'm trying to create a report using …
-
PERIODROLLING for Annual TurnoverPERIODROLLING for Annual Turnover I have been successful in plotting a Rolling month turnover rate using PERIODROLLING("Workforce Trend"."Period End Headcount",-11,0) . …
-
Security profile to restrict line manager to view only one assignment of employees in OTBI reportSummary: Hi All, My line manager is able to see the records for performance document for all Active assignments of employees. How to restrict my OBTI output so only the …
-
Why would OTBI reporting show a row with no absence plan name against an employee?Summary: Multiple rows showing with a blank Absence plan name Content (required): I have created a simple analysis with Person number, Name, Absence plan name and termin… -
How to fetch details of bypassed task for performance document in OTBI reportSummary: I have requirement to fetch the details of bypassed task in performance document in column Content (required): In our instance for performance document the work…
-
BIP Report- Need to Create Report based on User Access or Security Access.Summary: Need to Create BIP Report for performance , Which shows data based on User Access. Content (required): I need to create report for performance Module which show…
-
How to restrict OTBI report output based on employee assignments details for Line Managers loginSummary: Hi, I have created one OTBI report to view the details of PD but line managers are getting two rows for both the active assignments of employees .Ideally the li…
-
How to restrict OTBI report output based on employee assignments details for Line Managers loginSummary: Hi, I have created one OTBI report to view the details of PD but line managers are getting two rows for both the active assignments of employees .Ideally the li…
-
How to Remove Person number From Human Capital Management - Approval Notification Archive Real TimeSummary: In Subject area Human Capital Management - Approval Notification Archive Real Time, column Subject "Approval Notification Details"."Task Title" can we remove Pe…
-
Which table stores absence eligibility details?Summary: Which table stores absence eligibility details? Content (required): Hi Team, I want to know the table which store absence eligibility profile details. Thanks. V… -
DoR DDF correlation table HDOR.DEI_INFORMATION_NUMBER2Summary: Hello experts I'm trying to query some Document of records for brazil taht have fixed DDFs SELECT HDOR.DEI_INFORMATION_NUMBER2 as "STATE" HDOR.DEI_INFORMATION_N… -
Person number of employee/contingent worker of a successful referred candidateSummary: Customer is looking for a report with the person number of the employee/contingent worker who has been successfully hired after being referred by an internal em…
-
How to display overview of employees wherefore no rating proposal was submitted using OTBI report?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
What is the best way to show all employees for a specific element even if they do not have it?Summary: I need to build a report showing all employees, but needs to show a specific element if the employee has it, and leave a blank if they don't Content (required):…
-
How to generate a report for HCM users who are not using SSO loginSummary: HI Team, We would need to generate a BI report which will contain all the users who are not using SSO login instead they are using their username and credential… -
How to use MAX Date in OTBIContent Hi I'm getting multiple work relationship records, I would like to return only the latest work relationship record. How can use MAX function to select the latest…User_2025-02-07-19-03-14-525 2.6K views 8 comments 0 points Most recent by User_2025-02-11-05-19-35-410
-
Pie Chart Percent Display OverlapContent Hi - I need to display the percentage for each pie chart slice in an OTBI report for export to powerpoint, but some percentages overlap when displayed. Is there …
-
BIP report: Users with HR and line manager role should only see their direct/indirect reportsSummary: BIP report: How can we make sure that when an HR User, who is also a Line manager, is only seeing their own reports (direct and indirect) when pulling the repor…
-
Workforce Learning - Learning Management Real TimeSummary: Can anyone please help me with the table names that is being used in this subject.we have requirement to convert the OTBi to BIP Report