Reports
Discussion List
-
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 104 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 41 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 73 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 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle 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 31 views 4 comments 0 points Most recent by Abhishek Premchandra-Oracle Reporting and Analytics for HCM -
Bursting Enabled or DisabledHi Team, We wanted to check if we have a table or sql query to check how many reports have bursting enabled so a report or list can be prepared for the same. Please let …Swapnil Kashid 61 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
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 -
OTBI-Report-Workforce Management - Person Real Time-Roles RequieredSummary: OTBI-Report-Workforce Management - Person Real Time-Roles Requiered to get employee information Content (required): Hello I need to get some employee and manage…Cesar Saveedra 1 view 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI-Report-Supplier Portal - Invoice Real Time-Roles RequieredSummary: OTBI-Report-Supplier Portal - Invoice Real Time-Roles Requiered Content (required): Hello The following document state the role required to run the Supplier Por…Cesar Saveedra 71 views 3 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for ERP -
Blank line at the end of etext template output fileSummary: I'm trying to fetch the data from cloud in .txt file format by using ETEXT template. A blank line is noticed towards the end of the file always which is not exp…Meenakshi K 201 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Calculating the number of days between 2 prompt datesSummary Calculating the number of days between 2 prompt datesContent I have set up a prompt to get the absences with start dates between 2 dates but I would like to be a…User_2025-02-05-19-30-09-308 47 views 2 comments 1 point Most recent by Mohamed Hasan Reporting and Analytics for HCM -
Talent Review Prior and Latest N-Box AnalysisSummary: I am trying to capture the 2021 n-box and 2022 n-box of employees on Talent Review to find out if anyone has a change in the n-box. I created analysis but when … -
Two Employee Rows Created only one shows Gender but not dual AssignmentSummary: Content (required): We are running an "All Employees" report and there appeared to be an anomaly on a single employee where it returned two rows of identical da…Clifford Trett 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
which field stores value for Primary for national_identifiersSummary: which field stores value for Primary for national_identifiers Content (required): For National Identifiers in Front end,we can enter more than 1 National Identi… -
Report to generate Performance Document Status ReportSummary Report to generate Performance Document Status ReportContent Unarchive this catalog to use this report.