Reports
Discussion List
-
Manager Department HierarchyContent I have been able to create a top down hierarchy in my report using Person Manager and CASE/WHEN statements however, I am now being asked to bring in the departme… -
Gross Wage Report YTDSummary Detail Gross Wage Report YTDContent I am looking for a way or if there is already a predefined report for Gross Wages YTD broken down by each employee for exampl…Mike Householder 67 views 1 comment 1 point Most recent by Lisa Ridgely-Oracle Reporting and Analytics for HCM -
Date Parameter in BI Publisher ReportSummary Date Parameter in BI Publisher ReportContent Hi All Date Parameter in BI Publisher Report showing one day off in output, Tried setting of user time zone under My…
-
OTBI Training, Documentation, FAQs and moreContent We have published knowledge article 2023155.1 which contains training, documentation, answers to commonly questions and frequently asked questions. You can find …Julian Challenger-Oracle 226 views 7 comments 6 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Analysis rearranging Column Order different in CVS and EXCELSummary OTBI Analysis Column Order different in CVS and EXCELContent Hello, When I create a report, the column order that shows in the 'Results' tab and also in Excel - …User_2025-02-04-15-06-22-759 373 views 5 comments 0 points Most recent by Elisa Ortiz Rincon Reporting and Analytics for HCM -
Manager Flag - all employees returning no valuesSummary Manager Flag - all employees returning no valuesContent Workforce Manager - Worker Assignment Real Time > Worker Assignment Details > Manager Flag I was expectin… -
BI Publisher Report filter with multiple criteriaSummary Needing to add multiple criteria to an OTBI report filter e.g. multiple business unitsContent When adding a filter to a report created in OTBI I need to add mult…Chris Ross-Smith 118 views 6 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM -
Union Field in Employee screenSummary Union Field in Employee screenContent Hello All , Can you please let us know where we can find "UNION" in which Oracle table. NAvigation is :- My Client Groups >…Lucky Sharma 41 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Project Invoice DistributionSummary Project Invoice DistributionContent Hello All, I want to know from which table we can get below information:-Lucky Sharma 61 views 3 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP -
OTBI Report with Employee names in the 9 Box instead of countContent We are trying to build a OTBI report that can show employee names in the 9Box instead of counts/ performance tiles. Attaching picture for reference. Is this poss…User_2025-02-10-08-27-16-805 39 views 4 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
how to move Intercompany Matching Reports with MigrationContent Hello All, I would like to export and import the Intercompany Matching Reports created in prod to test but I'm not able to see in Migration the relative artifact…Gianluca Natili 20 views 3 comments 0 points Most recent by Unknown Financial Consolidation and Close -
How to Include an url in the BI Publisher Bursting Email BodySummary How to Include an url in the BI Publisher Bursting Email BodyContent I have a link which needs be sent to the recipients going through the busting email. Here is… -
Function FILTER requires at least one measure column in its first argument.Summary Function FILTER requires at least one measure column in its first argument.Content I would like to use the filter function on a non numeric column but I run into…User_2025-02-10-08-27-16-805 326 views 4 comments 1 point Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
Report using Contract DFFSummary How to build a report to include Contract DFFContent Hi, I have built a report joining the following subject areas Workforce Management - Employment Contract Rea…User_2025-02-08-08-11-51-624 32 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Subject area for Positions which has missing segments in Costing of PositionContent Hi Experts, I am new to OTBI analysis, I have a requirement to List all Positions which has missing segments in Costing of Position. Can anyone tell me which sub…Raghavendra M 52 views 6 comments 1 point Most recent by Raghavendra M Reporting and Analytics for HCM -
Download FR Report as PDF saves as HTMLContent We are no longer able to download FR Reports as PDF files even when the report output is set to PDF. Instead it wants to save the PDF report as an HTML file. Has… -
Monitoring License Metrics - Transactional Business Intelligence Cloud ServiceSummary What drives the license usage for Oracle Fusion Transactional Business Intelligence Cloud Service?Content Hi all, Many of the subscriptions are driven by a speci…Sian S 25 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Single output row for Course and Offering dataSummary Reduce duplicate rows in Learn Reporting of Course and Offering dataContent We have legacy course completion data that was loaded via HDL. Unfortunately we did n…Dean Soto 36 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Individual compensation plans subject areasContent Hello experts, I should create a payroll report in order to extract for each employee Individual Compensation Plans information. As a result, I need the followin…Valerio Curzi 39 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Head count by department for every month reportContent Hi, I'm looking for headcount report for each month by department. Can someone help me please. Thanks, VijayUser_2025-02-07-19-03-14-525 33 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Performance Rating With Compensation Data causing duplicate rowsContent Using Performance Rating from Compensation - Workforce Compensation Real Time subject area causes rows to duplicate for individual employee. I have tried to use …User_2025-02-10-08-27-16-805 36 views 5 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
Can we connect On Premise Application as Data Source in Narrative Reporting Data Sources?Content Can we connect Hyperion application like Hyperion Financial Management (on premise) or Hyperion Planning(on premise) as data source in Narrative Reporting Data S… -
4 new video tutorials for ReportsSummary New reporting solutionContent We are pleased to announce the availability of the following 4 new video tutorials for Reports: Reporting in the new Cloud EPM Plat… -
Display Parent Manager First Name and Last Name in 2 separate columnsContent Hello, I have an analysis I am creating that the end user has requested manager first name and last name to be in 2 separate columns. I have referenced this post…User_2025-02-07-16-42-37-187 166 views 3 comments 0 points Most recent by HROps17 Reporting and Analytics for HCM -
Report for Duplicate DependentsSummary Report for Duplicate DependentsContent Hi , Any one can help is their any report to find the duplicate dependents for each employee Regards, ReddykrishnaReddykrishna Chidella-Oracle 63 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
OTBI usage tracking in 21ASummary OTBI usage tracking in 21AContent In this new subject area below, will that only track usage within the CRM subject areas or will that track report usage in the …Andrew_Schmitz 84 views 0 comments 3 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP -
In need of an AAP Promotion report (FROM and TO details on job)Summary In need of an AAP Promotion report (FROM and TO details on job)Content We have AAP promotion report due in which they are asking FROM and TO of a job in a promot…Adil_R 70 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM