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
-
Need to remove one measure column's grand total value in OTBISummary Need to remove one measure column's grand total value in OTBIContent We have Grand total value for two measure columns in OTBI Report. We need grand total value … -
Prompted Bar Graphs for custom fields with case statementsSummary Prompted Bar Graphs for custom fields with case statementsContent We have a bar graph with a couple of custom fields derived using case statements. The fields on…
-
Report for Scheduled jobs and AgentsSummary Report for Scheduled Jobs and AgentsContent Hi All, I went through the topics but couldn't find an answer to the question about a report being created that shows…
-
Line Manager Dashboard - HeadcountSummary Female ManagersContent Hi All, Looking to Female Managers metric I can see the following logic: IFNULL(((FILTER(FILTER("Worker Assignment"."Head Count" USING (DE… -
Tuning SQL queriesSummary Does anyone have any hints or tips they can share on techniques to tune SQL queries in BI Data Models?Content I have a BI Report which contains a single data mod… -
Convert OTBI Analysis into BIP ReportSummary Convert OTBI to BIPContent Hi All, As our population in HCM is fast-growing, we are noticing some of the disadvantages of OTBI, performance, # of input records ,… -
Department HierarchyContent Hi all - I have a great report that we use for Department Hierarchy through OTBI, but we need this report through BIP. We have users that will pull this data the… -
Data Security when creating HCM OTBI reports for non-HR usersContent We want to create a few reports that need to be available to either Finance or Office Managers which get the data from the Oracle HCM module. Some examples, but … -
What Role or Privilege should a user get to be able to archive and OTBI reports?Content What Role or Privilege should a user get to be able to archive and OTBI reports? is archive button is not displayed for a user?
-
Roles Requirement to access all employees data using Subject Area "Workforce Management - Worker ****Summary What are the roles and permissions required to be given to a userID so that he can use "Workforce Management - Worker Assignment Real Time" subject area and extr… -
Most Recent Assignment RecordSummary Most Recent Assignment RecordContent When we need to report inactive and active employees in one analyses, it is not easy to get the latest record (for example, …
-
Link between Pending Worker and an Employee in OTBISummary Link between Pending Worker and an Employee in OTBIContent Hi All, I have a requirement where I need to build a performance tile which needs to report the count … -
OTBI Analysis - Pulling the latest effective dated recordSummary only want to see the record with the latest effective dateContent I am in need of assistance to create a filter to include only the latest date record in my anal… -
Reporting "Additional Address Attribute 1" on OTBISummary Fields don't appear on the relevant subject areaContent Hi. I have aligned my country's geography and i have several address elements that i save on the fields: … -
Identify retro changes on absence entriesSummary Identify retro changes on absence entriesContent How do we identify retro changes on absence entries? For example. employee A applies for leave from 10/1/2020 to… -
Subqueries in Logical SQLSummary I've probably failed at some simple syntax..Content Attempting to build some fairly complex queries using Logical SQL Analysis in OTBI. This query: SELECT "Worke…User_2025-01-28-21-32-42-630 51 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle
-
Adding Row # and Row Count to a report?Summary Looking for a way to include a row count in a reportContent We have recently moved to HCM Cloud after using Peoplesoft. Peoplesoft Query provided a row count in …User_2025-02-07-16-42-37-187 359 views 5 comments 1 point Most recent by User_2025-02-07-16-42-37-187
-
Where to save analysis to be able to use them in Learning AssignmentContent Hello, I created some analysis in OTBI and I should use them to assign Communities to Learners in OLC, but I am not able to find them while performing the add Le… -
OTBI Analysis error - ODBC driver returned errorSummary I developed an analysis and it works for one user and error for anotherContent Hi All, I created one analysis and it runs find for one user and error to other on…
-
Report on Absence approved dateSummary Report on Absence approved date in OTBIContent Please share the steps to capture Absence approved date when reporting on other absence details in OTBI. I have se…
-
HCM – Product Office Hour: OTBI November 2020Content Submit your questions for the HCM – Product Office Hour: OTBI November 2020 session to have them answered during the live event. Post your questions by posting a…Heather Hagedorn- Cloud HCM-Oracle 51 views 10 comments 1 point Most recent by Raghavendra Raghunath-Oracle -
Add Date to Report OutputContent Hi all - I am really hoping you can help me solve this oddity with our BIP report export to Excel. A user reached out to me asking to turn back on the option of …
-
Report display incorrect in dashboardSummary Report output on dashboard shows fewer rows of data than expectedContent I'm having some irregularities when trying to run an OTBI Analysis embedded in a dashboa…
-
Latest Hire Date in OTBI without using Seniority DatesContent Hi All, We have a requirement at our project where we need to get the “Latest Hire Date” for any Person in OTBI. The challenge is Seniority dates are not exposed…
-
Report Job HistorySummary Report job history only goes back 9 months from current dateContent Hi, After a query from an end user in HR we've noticed that the report job history only seems…
-
Learning Hours ReportContent Hi, Has anyone created or come across a report showing the actual or attempted start and stop time of a learning class/course? Thank you!
-
Agents for scheduling reportsSummary Can I move a live agent to a different folder?Content Hi, I want to tidy up some folders and would like to move several agents that are currently active (in use)…User_2025-02-05-22-44-35-842 22 views 2 comments 1 point Most recent by User_2025-02-05-22-44-35-842
-
Query help needed to determine duration in job code, title, pay gradeSummary Query generates a list of the job code, title and paygrade combinations for an employee with start and end datesContent Hi All, I have seen several queries regar…User_2025-02-04-08-51-08-912 24 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle
-
Starters as at Start DateSummary Data must be returned as at the Start DateContent Hi all I have a starters report that provides me with all the starters between two points in time however the d… -
BIP Error MessageContent Hi all - have you seen this error message before? System encountered unexpected error during data processing. Please contact system administrator to enable debug…