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
-
Vacant Position report with Last incumbentSummary Need a vacant position report with last incumbent detailsContent Hi Team I need a vacant position report with last incumbent details in OTBI, can you please let … -
Transaction Administration Real Time Subject Area - ReportContent Hi all, I am using this subject area to create report to pull the data about the pending transactions, however, we don't see that it has a dimension to show who … -
Printing the Entire Dashboard PageSummary Print the entire dashboard page on the My Team DashboardContent We have pushed out some dashboard reports for our end users. We have placed these reports on the … -
Editing Delivered DashboardSummary Trying to edit the delivered Line Manger Dashboard but received error on saveContent Hi, I am trying to edit the delivered Line Manager Dashboard, I want to upda… -
Is there a diagnostic report or other tool that will show Reports & Analyses that haven't been run iSummary Is there a diagnostic report or other tool that will show Reports & Analyses that haven't been run in 6 monthsContent Good afternoon. We are auditing our HCM BIP… -
Pivot Table helpSummary Trying to split two values in pivot tableContent Hi, I am trying to get my pivot table to show the sum of all National & International contracts by Business Unit… -
Data level security on OTBI reportSummary Can we apply data level security on OTBI reportContent Hello Everyone, Can we able to apply a data level security on OTBI report such as applying logic on data e…
-
Tax Year to Date / Statement of EarningsSummary How can I report on Tax YtD values from SoEContent We have a requirement to build a report in PeopleCloud which is currently an SQR in PeopleSoft. The existing r…
-
How to add employee picture on DashboardContent I can't seem to add the employee picture/image on Dashboard. Can someone assist.
-
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 342 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