Reports
Discussion List
-
OTBI Report in DashboardContent I need to build a graph for the person headcount for different actions and then embed that graph in the dashboard. I understand that the person having the HR spe… -
Effective Dated Headcount Report with SalaryContent Attempting to create an effective dated Headcount report with salary details that reports data as of a prompted point in time. Able to create the report to inclu…User_2025-01-28-08-31-49-398 136 views 3 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Hierarchy Traversal in BI Data Model ReportContent Please refer to the images attached. Referring to IMAGE1. In column level we want to show business unit in level2(by default on opening the report) from the orga… -
Report showing Employee's Line Manager and Business Unit DirectorContent Hi All, I am struggling to create a report showing an Employee's direct Line Manager and Business Unit Director. When I create it, I get the hierarchy for that e…Aaron Leggett 107 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Job Competency ReportContent Morning all, I'm looking to build a basic report that shows the competencies we have built against each job profile, but I'm struggling to find what subject area…User_2025-01-28-05-39-23-766 57 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM -
Date subtraction in eText templateContent Hi All, I am facing issues in date manipulation in the eText Template. Seeded date functions are not working and traditional date subtraction are not returning v…User_2025-01-25-06-20-12-259 450 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Reading file from Content ServerSummary Reading file from Content ServerContent We have a requirement to read a document/attachment from content server and display it on a report as either a link or to…Srihari Murthy 115 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Pivot Table - adding a column to total values per sectionSummary adding a column to sum values in each sectionContent We have a goal plan which is sectioned by goal categories. I am creating a report for our goal admins for th…User_2025-01-22-19-28-29-985 71 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Amending Graph DesignsContent Morning all I've built a Performance Dashboard (attached), but had a few questions that I haven't yet found answers to: 1. I'd like to change the colours of the …User_2025-01-28-05-39-23-766 59 views 4 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM -
"All" value in Graph PromptContent I've built a basic Performance Document summary (see attached) It uses a Column Selector for Division / Department / Business Unit / Location, and I've also adde…User_2025-01-28-05-39-23-766 81 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM -
Reporting PathContent Dear Experts, There are many reports listed below, I found only few of them, for rest of reports path is mentioned in the sheet i downloaded from oracle docs is … -
Why it shows "DATA_DS"?Content I tried to build a data model using query builder option. But it did not show any results except "DATA_DS". I would like know the reason for it. Please find atta…User_2025-01-28-21-18-43-496 134 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Goal Listing Report not returning any values since R12 upgradeContent We have a Goal Listing Report which is no longer returning any results. All values are selected in the Filters. No changes have been made to the Goals rating mod…Rebecca Smith-27468 34 views 3 comments 0 points Most recent by User_2025-01-25-01-11-32-039 Reporting and Analytics for HCM -
Employee's Management Level in the OrganisationSummary Employee's Management Level in the OrganisationContent Hello, Can anyone please help me? I am trying to build a report in OTBI which gives the list of employees …SantoshKumarBhairi 66 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
performance rating overlaySummary Attempting to show comparison to a valueContent Hello All, I am working on a report that will show in real time a line graph of what % of users have what perform…Nicolas Trojack-24006 61 views 0 comments 0 points Most recent by Nicolas Trojack-24006 Performance Management -
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…User_AEMC1 55 views 1 comment 0 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM -
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 Reporting and Analytics for HCM -
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 Reporting and Analytics for HCM -
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 Reporting and Analytics for HCM -
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…User720640-Oracle 41 views 0 comments 0 points Most recent by User720640-Oracle Reporting and Analytics for HCM -
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…Callen Raveret-67982 31 views 0 comments 1 point Most recent by Callen Raveret-67982 Reporting and Analytics for HCM -
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 Reporting and Analytics for HCM -
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…User_I6AXL 34 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
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…User_2025-01-29-23-59-58-976 97 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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…Aparna Damle 26 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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…Roy Paolo Paunlagui 87 views 2 comments 1 point Most recent by Roy Paolo Paunlagui Reporting and Analytics for HCM -
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…Achala Munasinghe 58 views 5 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM -
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 …AbulKhair 58 views 16 comments 1 point Most recent by Vijay Thakur-25679 Reporting and Analytics for HCM -
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 …User_2025-01-28-20-43-56-568 111 views 6 comments 0 points Most recent by Vijay Thakur-25679 Reporting and Analytics for HCM -
Need help setting the Month-end Date on ReportsSummary Need help setting the Month-end Date on ReportsContent The Calendar month-end date reported from the Time dimension on historical subject areas is reporting one …User_2025-01-22-19-28-28-240 75 views 2 comments 0 points Most recent by Cindy Sutrisna-24907 Reporting and Analytics for HCM