Reports
Discussion List
-
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 51 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 141 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 -
Unable to Use Multiple UDAs in FR ReportsHi All, I have created 2 UDA's for one of member in the View dimension in FCCS. I am trying to use this in my FR Report Header by referencing it through the following co…User_ATFGI 41 views 6 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
Field Change in 22A - Subject Area: Project Costing-Actual Costs Real Time. Column Name ChangeSummary: Our Reporting group is noting the below OTBI column change in 22A in Projects: Content (required): Our Reporting group is noting the below OTBI column change in…
-
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 21 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 61 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
PRC: SQL to get the Cost Center Owner approver's email address on RequisitionsSummary: We are currently investigating the process of being able to extract the Cost Center Approver email address. The cost center owner approval is setup in the secon…
-
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… -
BI Publisher Desktop for BIP 11.1.1.9.0 not working with MS Office-365 & WIN-10Hello 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 Office-365 …
-
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
-
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 531 views 5 comments 0 points Most recent by Evan Rathod Reporting and Analytics for HCM