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
-
Users doesn't have BI Reports access based custom roles after R12Summary Users doesn't have BI Reports access based custom roles after R12Content Users doesn't have BI Reports access based custom roles after R12. Will be appreciated f… -
Compensation - which table contains the comments ?Content Hello, In the compensation sheet, you can add a column in which the manager can add a comment. I need to extract all the comments with BI Publisher or OTBI. Is a… -
Assignment Status History ReportSummary A report showing the details per assignment between datesContent Hi All Has anyone created a report in BI Publisher that displays the detail of the assignment be…User_2025-01-22-19-30-53-101 276 views 6 comments 1 point Most recent by User_2025-01-29-21-55-25-526
-
Reporting on Areas of ResponsibilitySummary Reporting on Areas of ResponsibilityContent Our IT department created a data model to report on Areas of Responsibility, but there is a problem with missing data…User_2025-01-22-19-28-28-240 281 views 3 comments 0 points Most recent by User_2025-01-28-03-49-50-466
-
Trigger Extracts from BI PublisherSummary Can BI Publisher trigger HCM Extracts?Content Hello, Can BI Publisher catalog trigger an Extract? We have a working extract already and we want to trigger it usi… -
Sickness Absence & Right to Work DashboardsContent Hello, I'm looking to provide two dashboards to the business based around 1) sickness absence and 2) the status of an employees right to work (nationality/passpo…User_2025-01-29-19-59-51-150 83 views 2 comments 0 points Most recent by User_2025-01-29-19-59-51-150
-
OTBI Error: The View Object "HcmTopModelAnalyticsGlobalAM.ManagerHierarchyAM.PersonNameDPVO" is usedSummary OTBI Error: The View Object "HcmTopModelAnalyticsGlobalAM.ManagerHierarchyAM.PersonNameDPVO" is used as the destination of more than one View LinkContent We are …User_2025-01-25-04-02-13-126 39 views 6 comments 0 points Most recent by User_2025-01-25-04-02-13-126
-
Important Information About Fusion OTBI R12 Patch Bundle 10Summary This note provides information about Fusion OTBI R12 PB10 (2017 October monthly patch bundle)Content This note provides information about Fusion OTBI R12 PB10 (2… -
Error 500 --Internal Server Error - BIP ReportsSummary Error 500 --Internal Server ErrorContent We have created a BIP reports but when we run it we get the following error message. Is there a way to fix it? thank you -
Talent Profile data of ex-employees?Summary To be able to analyze the quality of talent that have left our companyContent Hi CC Community, We are trying to get Talent Profile data from OTBI. More specifica…
-
R12 Pre-built OTBI ReportsSummary How to get a list of Pre-built OTBI ReportsContent Hello Everyone, Does anyone know where I can get the list of all Pre-built OTBI reports or Analysis with all t… -
Taleo Recruiting SA Mapped to Tables?Summary Is there a document that details the subject area tables and columns mapped to the physical table and columns in Taleo for the Recruiting subject area?Content Is…
-
Current Employee Report returning an additional row for some employeesSummary Some employees have additional row with only a few populated columnsContent Our current report reflects 14 employees with an extra row; however, only a few of th…User_2025-01-28-20-43-56-568 57 views 2 comments 0 points Most recent by User_2025-01-28-20-43-56-568
-
OTBI - How to get the records with MAX effectivedateContent How do I query all the records with MAX effectivedate from the below table. After running the query on the below table I should have only the last 2 rows which i…
-
Tables vs Subject AreaSummary How to quickly find the right Subject Area from a particular tableContent Hello everyone, I have a Disco report based on the following tables. So, we may say the…
-
Number of hires by contract type in OTBI reportSummary I want to use 2 subject areas (contract type) and assi event real time to display number of hires by contractContent Hello, I m not able to join the number of hi… -
Termination report with subquerySummary Looking for a subquery that would eliminate currently active employees form termination reportContent Hello, I am trying to build a termination report for our or…
-
BI report - Worker Assignment StatusContent I am creating a BI report and I need to show Assignment Status just like how it is showing in OTBI as follows: Active - Payroll Eligible Leave - No Payroll Leave…
-
HCM- Approval Notification Archive Real Time not returning dataSummary No results returned when using the new Approval Notification Archive Real Time subject areaContent I'm attempting to create a new analysis using the HCM-Approval… -
BI & OTBI - Latest pay periodContent How do I get the latest pay period in BI and OTBI ? We are giving 2 date parameters for users - Start date and end date If they enter it, then we calculate balan…
-
How to report on Work Schedules in R12Summary Trying to report on Work SchedulesContent Hi, I am trying to build an OTBI report on work schedules in R12, it is my understanding with R12 this functionality wa…
-
Subordinate Salary ReportContent I want to create a report wherein I can capture the salaries of an supervisor's direct reports. The client wants to ensure that the difference in salaries betwee… -
Report to capture complete reporting lineSummary Supervisor hierarchy ReportContent Hi everyone - Has anyone here had a requirement to pull out the complete reporting line of one manager? We are trying to creat…
-
How get approver comments?Content Hi All, I am just trying to find a subject area to get the approval comments at the point of approval of a performance document? Is it possible to get from subje… -
Rel12 PB8: OTBI HCM Prompts subject areaSummary A new subject area has been added to the list of HCM OTBI subject areas. The purpose of this subject area is to setup dashboard prompts and use them in the dashb… -
OTBI HCM Prompts Subject AreaSummary How do I use the Subject Area: OTBI HCM Promps?Content Hi all - I noticed a subject area I had not seen before: OTBI HCM Prompts. I am unsure how to use this, bu… -
OTBI vs OBIA (Data Warehouse)Summary When do I use OTBI vs OBIA?Content Hi all - I am still learning our environments and would like to understand when to use OTBI/BIP and when to use OBIA (Oracle d…
-
Worker's Folder Take Forever To Load in OTBI Subject AreaSummary Worker's Folder Take Forever To Load in OTBI Subject AreaContent After the Release 12 upgrade, we have been facing issues creating Analysis, the Worker's Folder …
-
What subject area to use for user roles?Summary Need to create a report that show the roles each employee is assignedContent Hi. Can someone please share if there is a subject area folder available that would …
-
OTBI: Default date promptContent Hi, I want to display current_date as my default value in the Date prompt. How can I do it? Thanks Alex