Reports
Discussion List
-
Organizational chart with performance ratingsContent Is it possible to create a chart in OTBI in org-chart form that shows position name, position incumbents, incumbents' performance ratings and demographic details?Michael Florescu-Oracle 44 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Oracle BI publisher - Which tool oracle is decommissioning ?Summary Hi Team, Can you please confirm which part of BI publisher is going to decommissioned ?We are planning to move fully in OTBI but need BI as wellContent Hi Team, …User_2025-02-04-10-02-23-351 48 views 6 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Report on Remuneration Managers of Employees using matrix manager from Workforce Management - WorkerContent Hi Experts, I am trying to create an OTBI report listing all employees and their Remuneration Managers using matrix manager from Workforce Management - Worker as… -
Scheduled Report FailedSummary Scheduled Report FailedContent Hi Experts, Greetings of the day. I have scheduled a custom BI report and it has been failed with the below error after running lo…Charan Kollipara 59 views 2 comments 0 points Most recent by Karina Ogata Reporting and Analytics for HCM
-
Determine Time in Current and Previous positionsSummary Progression report that shows how long an employee has been in the current position and how long in the previousContent Hi All, I am hoping someone has a solutio…User_2025-02-04-08-51-08-912 168 views 3 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Issue adding OTBI Report to a dashboard through "Link & Image" ObjectContent Hi all, I am adding all of our reports (OTBI & BIP) to a dashboard as links to be easy to find. However, for one OTBI report, I am getting an error: "Selected it…User_2025-02-05-05-51-12-049 58 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report Absence based on rolling 12 months from start of monthSummary How can I use the TIMESTAMP SQL to report from a rolling 12 months but from the beginning of the month I'm inContent Hi I would like to report absence on a rolli… -
Dates not coming properly in Excel filterSummary Dates not coming properly in Excel filterContent When we open a Report the report opens in excel. So, now in excel when we trying to filter the date columns, and…User_2025-01-29-18-45-19-617 66 views 4 comments 0 points Most recent by User_2025-01-29-18-45-19-617 Reporting and Analytics for HCM
-
OTBI date check End-of-timeSummary OTBI date check End-of-timeContent Hi, I am wondering if anyone has tried to check for end of time on a date column in OTBI. I wrote this. But it doesn't work. A…User_2025-02-05-23-02-10-916 37 views 3 comments 0 points Most recent by User_2025-02-05-23-02-10-916 Reporting and Analytics for HCM
-
How to capture personal payment method deletes through ESS?Summary How to capture personal payment method deletes through ESS?Content Hi Experts, When i am trying to delete the personal payment method through employee self servi…Harish Kumar Kovi 199 views 11 comments 0 points Most recent by Vanitha Kundaram Reporting and Analytics for HCM
-
Connection to external data sources is not supported in Fusion and will be deprecated in a future reSummary Connection to external data sources is not supported in Fusion and will be deprecated in a future release.Content Hi Team, I am exploring the option of creating …MandeepKGupta 52 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting and Analytics for HCM
-
OBIEE BIP Report LogSummary Where to find report log which shows SQL that's generated by report while report executionContent Hello Everyone, I'm trying to find log of a BIP report which I …
-
How to get count of child nodes in ETEXT templateSummary How to get count of child nodes in ETEXT templateContent Hi experts, how can i get the count of child nodes in etext template, ex : in attached xml i want to dis…Pradvin Prabhakar 125 views 6 comments 1 point Most recent by Pradvin Prabhakar Reporting and Analytics for HCM
-
Need a report for AOR with scope of responsibility ?Summary Need a report for AOR with scope of responsibility ?Content Hi Team, Need a report for AOR with scope of responsibility ? I need to create a report for AOR but n… -
Cannot view report with Person NumberContent Hi, I am using the subject area Workforce Management - Worker Assignment Real Time and when the report is created using Person Number from Worker folder could no…Mohammed Rafi 26 views 2 comments 3 points Most recent by Mohammed Rafi Reporting and Analytics for HCM -
Seeded Lookups with their values in HCMSummary Need a list of lookups with their valuesContent Hello, I need a seeded list of lookups types with their values, I was not able to find it in any subject area so …Akanksha Jain 58 views 3 comments 2 points Most recent by Akanksha Jain Reporting and Analytics for HCM
-
oracle.xdo.servlet.data.DataException: org.xml.sax.SAXParseException; lineNumber: 600; columnNumber:Summary oracle.xdo.servlet.data.DataException: org.xml.sax.SAXParseException; lineNumber: 600; columnNumber: 145; : XML-20250: (Fatal Error) Missing entity 'bull'.Conten…
-
Amendment need to an existing reportSummary Multiple NationalitiesContent Hi, How can I modify the attached report so that only the primary nationality is displayed? For context, there are many employees t…User_2025-02-05-22-44-35-842 32 views 1 comment 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Prior Salary not showing in reportSummary Prior salary not showingContent Hi, The report attached should show all prior salaries and current salaries - one of our users has said that the Prior salary is …User_2025-02-05-22-44-35-842 40 views 6 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Join Expenses – Employees Expense Overview Real time and Workforce Management – Worker Assignment ReContent Hello Everyone, I am trying to join below 2 subject areas to get the default expense concatenated segments along with other employment-related information. Expen…Prateek Yadav 37 views 7 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Add a Column with a Static Value in OTBISummary Trying to add the same value to all records, i.e. add a dummy column that holds a static fieldContent In OTBI, I need to add a column to a report that doesn't ne…Lisa G. 669 views 5 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
EL expression to restrict springboard group to a specific hierarchySummary EL expression to restrict springboard group to a specific hierarchyContent We are trying to let users have access to dashboards directly from the springboard. I …User_2025-02-10-08-27-16-805 40 views 5 comments 0 points Most recent by Vis Perera Reporting and Analytics for HCM
-
OBIEE - Pivot Table add calculated columnSummary OBIEE - Pivot Table add calculated columnContent Hi, I have built a Pivot table Analysis in OBIEE and would like to add a addition column beside the Grand Total …Nizar Kassam 47 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Adding days to the Date prompt in OTBISummary Adding days to the Date prompt in OTBIContent Hi Team, I have one requirement to add 6 days to the prompt date and fetch the value based on the new value. +6 or …SM-Oracle 129 views 1 comment 0 points Most recent by Mallikarjuna Maganti Reporting and Analytics for HCM
-
How to enable export functionality in ReportsSummary How to enable export functionality in ReportsContent Hello, We created reports using OTBI and have put them under 'My Dashboards' but we are wondering why we can…Tony Puentes 44 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Performance tile to show a 0 instead of no resultsContent Is it possible for a performance tile to show as a '0' if there are null counts instead of it showing a message saying 'no results'User_2025-02-06-11-18-47-896 48 views 7 comments 1 point Most recent by Rob F Reporting and Analytics for HCM
-
Report no longer workingSummary This report last worked before the April upgrade to 20BContent Hi, This report (see attached XML) no longer works - can anyone check why? There are no filters or…User_2025-02-05-22-44-35-842 23 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Performance - "My Organization" replacement report ideasContent With the transition from Classic UI to Responsive UX the "My Organization" tab in Performance is set to be deprecated at some point. We have not seen this as bei…Kayla Malecki 33 views 2 comments 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
CASE statement with IFSummary Need help with a CASE statement where it displays element input value if they have the element, else shows nullContent Hello, We have element set up like below t…User_2025-02-04-15-06-22-759 57 views 6 comments 0 points Most recent by User_2025-02-04-15-06-22-759 Reporting and Analytics for HCM
-
Reporting on Rejected DORSummary Requirement to report on rejected DORContent Some of the DORs in our system pass through the Approval cycle. I have checked "Workforce Management - Documents of …User_2025-02-05-23-02-10-916 37 views 6 comments 1 point Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM