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: how do we check if one column value is present inside another columnSummary OTBI: how do we check if one column value is present inside another columnContent Hi, Need a logic to compare if one column value is present inside another colum… -
Query related to OTBI subject area: Payroll : Personal Payments Detail Real TimeSummary Query related to OTBI subject area: Payroll : Personal Payments Detail Real TimeContent Hi, I have a query on OTBI subject area: Payroll : Personal Payments Deta…
-
Aggregate actions, and make it consistent across languagesSummary Aggregate actions, and make it consistent across languagesContent Hi, we need to aggregate action and make it consistent across languages in OTBI. I modify the f… -
Future-dated department showing up in report instead of current dataContent Department attribute in 'Workforce Performance - Performance Task Status Real Time' subject area is fetching future-dated assignment information for employee ins…User_2025-02-05-23-59-37-171 33 views 9 comments 0 points Most recent by User_2025-02-05-23-59-37-171 -
Is there a way to model different Department hierarchiesContent I am looking to essentially create a different Org/Dept reporting hierarchy and run an existing report using this hierarchy. The idea is to essentially do some c…
-
Looking for Quadrant view of dashboard for BSCContent Hi, I have a requirement to build Quadrant view of dashboard for BSC. Please let me know if anyone can help me on this. Thanks. Jyoti
-
Looking for Transfer Compensation Change ReportContent Hi, I am in need of Transfer Compensation and Location Change report. Please help. Thanks, Jyoti
-
Reporting on when someone became a line managerContent Has anyone developed a report that allows us to see when someone first has a direct report assigned to them or knows of anyway to do this? Version 20BUser_2025-01-31-00-25-12-234 20 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
Manager_type = Timecard_Approver in OTBISummary Manager_type = Timecard_Approver in OTBIContent Hi ALL, In OTBI when I see "Manager Type" ( "Workforce Management - Worker Assignment Real Time"."Worker"."Manage…
-
Rename Column HeaderSummary BI Publisher Report Column HeaderContent Hi, The attached BI Publisher report has a typo in the column header where Annual is misspelt as Annaul. I have tried ed…User_2025-02-05-22-44-35-842 29 views 3 comments 2 points Most recent by User_2025-02-05-22-44-35-842
-
Descriptive FlexfieldsSummary Deploy Descriptive Flexfields to Unified Sandboxes [HCM 20B]Content Please provide information of new features in Deploy Descriptive Flexfields to Unified Sandbo…
-
Linking Work Relationship Real Time and Worker Assignment Event Subject AreasSummary Trying to link subject areas for a reportContent We have a request to add a rehire recommendation field to a termination report that is using the worker assignme…
-
Salary reportSummary Salary reportContent I need a report which pulls current salary and previous salary details. Can any one have SQL to pull the data. PERSON_NUMBER OLD_SALARY_STAR… -
CASE Statement - Multiple rows in OTBIContent Hi, We have local legislative requirement for a report do deliver it in certain type of format. As the information is stored differently in HCM Cloud e.g. Elemen… -
Remove Pending Workers from BI Publisher ReportSummary Pending WorkersContent Hi, I have a BI Publisher report that is incorrectly including System Person Type: Pending Worker in the Headcount figures. Can someone te…
-
Adding labels on X axis in OTBI report under graph ViewSummary I am trying to add labels on X axis in graph view of OTBI report.Content I am trying to add labels on X axis in graph view of OTBI report.I am creating on OTBI a…
-
Looking for Position ReportSummary Would like number of unfilled positions, organization chartsContent Hi everyone - we are underway with preparing to implement Position Management. We currently u…
-
OTBI Workforce Trends - Time Column Values Are not Accurate or are BlankSummary Calendar Quarter and Calendar Month do not render correctly in the reportContent We have a requirement to show period active start and end headcount by different… -
Calendar PromptSummary I would like to add a calendar promptContent Hi, I have added AsOf date prompts to various reports and here I would like to include a between date prompt using t…User_2025-02-05-22-44-35-842 72 views 5 comments 1 point Most recent by User_2025-02-05-22-44-35-842
-
OTBI Matrix Manager ReportSummary OTBI Matrix Manager ReportContent Hi Team, We are working on a OTBI report where client want to add all matrix managers and should extract all manager in single …User_2025-02-01-03-43-13-079 116 views 2 comments 2 points Most recent by User_2025-02-01-03-43-13-079
-
Looking for solution to "https://cloudcustomerconnect.oracle.com/posts/a3fe9e182c?commentId=407101#4Content Hi, I have a requirement exactly like "https://cloudcustomerconnect.oracle.com/posts/a3fe9e182c?commentId=407101#407101". I am not able to resolve it using MAX()…User_2025-02-06-14-37-05-233 33 views 2 comments 1 point Most recent by User_2025-02-06-14-37-05-233
-
How Extract flexfield attributes of departmentContent Hello Guys, I need to extract the flex-field attributes of department, but by using this query I don't find any things. Moreover, I have a lot of duplicate rows … -
Parent manager blank for terminated employees.Summary Parent manager blank for terminated employees, how to retrieve manager hierarchyContent Hi all, we are facing some issues with OTBI report, we are using Parent M…
-
Recommend to RehireSummary Termination - Recommend to RehireContent Hi, Where can I find the 'Recommend to Rehire' flag value to report on? For context, when someone terminates a dropdown …User_2025-02-05-22-44-35-842 72 views 6 comments 2 points Most recent by User_2025-02-05-22-44-35-842
-
Role related issue while running a BIP report via HR Dashboard in HCM CloudSummary Role related issue while running a BIP report via HR Dashboard in HCM CloudContent Hi, I have a BIP report developed which is working fine as is when checking da…
-
Audit report for individual compensation dataSummary Audit report for individual compensation dataContent Hello, we are trying to run the Audit report (https://docs.oracle.com/en/cloud/saas/global-human-resources/1…
-
Graphs in OTBISummary Can graph with data count be created in OTBIContent Can we create a graph close to how it is shown in the image in OTBI? -
Unable To Export To CSVSummary Enable CSV is enabled in the data model, but am not able to export to CSV.Content We have an existing report that the business would like to be able to export to…
-
Payroll - Element Entries Unable to View Element NameSummary Unable to view the element nameContent I'm using the Payroll - Element Entries Real Time Subject Area for my report I've chosen various dimensions for the report…
-
how to restrict an analysis to 1 assignmentContent In our HCM setup we can have people with multiple assignments which are active. What I want to do is get the most current/latest assignment. The primary flag doe…