Reports
Discussion List
-
How to habilitate 'My reporting' for HR Specialist in HCM Cloud?Summary: The tab 'My Reporting', is unavailable in our environment menu. Content (required): Greetings community! I have seen that in demo.oracle I can use the tab 'My R… -
Need assistance enabling icon: "Reports and Analytics"Summary: Need assistance enabling icon: "Reports and Analytics" under Tools within Oracle Cloud Application (21D) HCM Dashboard. I could not find any specific roles to a…User_2025-03-07-05-24-33-733 54 views 3 comments 0 points Most recent by Patricia-S-Oracle Reporting and Analytics for HCM -
Assignment Event Headcount at Start of MonthSummary: Getting the Headcount at the Start of the Month Content (required): How can we configure the Formula for the Assignment Event Headcount at the Calendar Month St…Rebekah Gilday 31 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
User and Role Access Audit Report - be awareSummary: This is not a query but a heads up for users. Content (required): This delivered report does not return the values it's supposed to. Running the report with 'Al…K DeFabrizio 83 views 6 comments 0 points Most recent by K DeFabrizio Reporting and Analytics for HCM
-
oracle.xdo.template.online.dms.common.XDODmsException: IO Exception was thrown! nullSummary: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.template.online.dms.common.XDODm…
-
Organization Chart with Persons ImagesSummary Organization Chart with Persons Images with Google Chart ServicesUser_Z8Y6M 127 views 8 comments 2 points Most recent by Vasiliki Tripolitsioti-Oracle Reporting and Analytics for HCM
-
BIP Report - Performance & Potential RatingSummary: Hello, Does anyone know how can I create report out of this sample data by means of using BIP? Best Regards, Content (required): Hello, Does anyone know how can…Hazel De Castro 48 views 4 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
OTBI Subject Area Contents Listing (metadata)How do we provide our users with a user-friendly listing of the contents in each Subject Area? Or, at least, how or where do we get the data necessary to build one? This…Eric Geddes 32 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Termination Reasons & Salary in Workforce Trend to measure TurnoverSummary: When adding Termination Reasons (Action Reason), the terminations sum up correctly, but the Headcounts are inaccurate. Salary data doesn't populate. Content (re…
-
Error in SQL created by SQL AssemblerSummary: I get the following error Error generating view. Error getting cursor in GenerateHead in a SQL statement created by SQL Assembler Content (required): I get the …Donna Valentine 43 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Rtf template special character errorSummary: Content (required): Hello everybody, I was having a problem concerning the extraction of certain data to insert in an rtf template in word. In particular, extra…Gerardo Peluso 41 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Employee Commute DistanceSummary: We need a way to calculate and report on Employee Commute distance to support our Environmental, Social and Governance reporting. In our legacy data warehouse w…Chelsea Holden 31 views 3 comments 2 points Most recent by Chelsea Holden Reporting and Analytics for HCM -
RCOUNT("Worker"."Person ID" by "Learning Items"."Learning Item Number")Summary: I am trying to fetch the latest status of a particular learning item number per employee. I have used RCOUNT and Max to fetch the data. When I filter with perso…Anita 138 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to format the date field from time dimensionSummary: How to format the date field from time dimension Content (required): I have column Calendar Month from Time dimension it is showing the output as 2022101.0 for …Raghavendra M 21 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
12 Month Trailing Trend Chart of AttritionSummary: We're looking for this specific report. Content (required): Unsure of whether there are metrics accessible via OTBI that could be used to create this report Ver…Andrew Craig-Oracle 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can't see 'Administration' Tab in Catalog?Summary: Content (required): Can't see 'Administration' Tab in Catalog after the last update? any feedback? note: the user has all related (HR Analyst, Admin Roles, and …Walid Hamdy 55 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Error When open Dashboard by a certain user!Summary: Content (required): I received this error when opening a custom dashboard, noting that the user has access to the report and its Subject Areas The report can be…Walid Hamdy 21 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Locate Job Requisition Submissions Questionnaire ResponsesSummary: Hi all, I am attempting to write a BI report that will show an applicants response to a specific question asked during the job application submission. Can you p… -
BI Publisher Desktop for BIP 11.1.1.9.0 not working with MS Office-365 & WIN-10Summary: Hello Experts, Can you please guide me if you have faced the similar issue while installing BI Publisher Desktop for BIP 11.1.1.9.0 which not working with MS Of… -
How Time Dimension works?Summary Report with snapshots by end of monthsContent Hi Everyone, I am struggling to build an OTBI analysis that creates a monthly Head Count report. I am using "Workfo…Alvaro Couto 100 views 12 comments 1 point Most recent by Raghavendra M Reporting and Analytics for HCM -
Disability, Ethnicity, and VETS reporting - DEI ReportingContent Hello, We are looking to report on all active employees and show the count of ethnicity, disability (self disclosing), veteran, and gender. I am wondering if the…Dustin Puchalla 90 views 12 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Total on the Top of Stacked Vertical BarSummary: Total on the Top of Stacked Vertical Bar Content (required): How to add Totals on top of Stacked Vertical Bar in OTBI, Please see below image, If its possile pl… -
Grouping and sum the RUN values of balances using XSLTSummary: Grouping and sum the RUN values of balances using XSLT Content (required): I have a below requirement to group by and sum the RUN values for each balance under …Deekshith Kalluri 31 views 0 comments 0 points Started by Deekshith Kalluri Reporting and Analytics for HCM
-
BIP Report - Department HierarchySummary: Hello, can I create a SQL for department hierarchy out of this sample pattern? Does it work in Oracle BI Publisher? with Org ( id,idparent, name, level , Path) …Hazel De Castro 33 views 2 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
Administration ReportsContent Hi - I have a business requirement to change some of the columns/fields/filters int he Administration Reports in My Workforce > Compensation. For example, on the…Prudence K 81 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Sox User Report - Security Roles & Privileges SA - Errors when trying to add in Department CodeSummary Sox User Report - Errors when trying to add in Department CodeContent I was asked to create a simple user report for our IT department that could be used for sox…User_2025-02-07-16-42-37-187 51 views 2 comments 0 points Most recent by Shant Sarkissian_NES Reporting and Analytics for HCM -
Please, which subject areas can i use to build a report on personal information data.Summary: We want to build a report on personal information data. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any co…David Sakeye 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Create OTBI report with manager types other than Line ManagerSummary: We created a manager type for Time Keepers that we need to be able to report on for our time keeping system. We have only been able to find Manager Type = Line …Chelsea Holden 512 views 5 comments 0 points Most recent by Evan Rathod Reporting and Analytics for HCM
-
How to create Pivot table in RTF with Text values?Summary: Hello Experts, Is it possible to create a Pivot table in RTF with Text values? If yes, kindly share the details. Regards, Abhishek Premchandra Content (required…Abhishek Premchandra-Oracle 35 views 4 comments 0 points Most recent by Abhishek Premchandra-Oracle Reporting and Analytics for HCM
-
Waived Benefits fields in OTBISummary: I have a report that HR has requested to add if the have waived their benefits elections. Is their a field/ subject area that will store this information? I'm c…RJ Blankenship 21 views 3 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM