Reports
Discussion List
-
Schedule Event Trigger in Data Model Errors immediately when ScheduledSummary: I have created an event trigger in a data model, which I have done before without issue, but for this one as soon as I schedule the report that uses this data m… -
Can BI Deep Link use variable to represent the servername in the URLSummary: Deep Links present an issue during P2T environment copy downs because after each refresh all Deep Links embedded in BI report definitions have to be modified, i… -
Invoice Not reflecting in OTBISummary: Invoice Not reflecting in OTBI Content (required): Invoices created are not reflecting in OTBI Payables Transaction Real Time. Is there a time limit that the in…CraigX 141 views 1 comment 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP -
Project Resources base tablesSummary: Need SQL query to retrieve project resources Content (required): I am not able to figure out which base table stores project resources in general - such as labo…
-
Query to get account numberSummary: Query to get account number present in below screenshot Content (required):Navigation - Payroll>Statement of earnings>Costing Results>Account number. Can anyone…Jaeyshree Kumaran 41 views 1 comment 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM
-
Queries behind ADF pagesSummary: Is there a way to inspect queries behind the ADF pages in Fusion ? Content (required): Is it possible to get access to the queries/view objects behind a Fusion … -
21B - DFFs not populating in OTBIContent We recently added some DFF's to our health and safety module and I'm able to find them in the correct subject area but when I look at the results there's no data… -
Newly migrated report from FR to MR won't allow new sortingContent I migrated a report from FR on prem to Management Reporting. After I clear the errors and warnings the report will not let me add new sort values; the option is …
-
What’s New in EPM Cloud Narrative Reporting and Reports Release 21.09Summary Learn about what’s new in the EPM Cloud Narrative Reporting and Reports 21.09 release. Content Please refer to the September 2021 What’s New guide to understand …Dave Roberts_-Oracle 25 views 4 comments 1 point Most recent by Dave Roberts_-Oracle Narrative Reporting -
BI Publisher RTF Template AR Invoice : Grouping rowsContent I am required to create an AR Invoice report, where services are needed to be grouped based on what kind of service they are within a report. To be more clear, f…
-
Unable to open parameters page for any of the BI reportsSummary: Unable to open the parameters page for any of the BI report. When I click on any of the BI reports, I get a blank page that is visible. Not able to access any o…Divya K S-Oracle 11 views 11 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Combining two analysisHi Team, Can we combine two or more analysis (columns are same for all analysis) results in a single report? Thanks.
-
Can we use 2 font colours in 1 text field in HFRSummary: Can we use 2 font colours in 1 text field in HFR Content (required): As per the screenshot, I want to use 2 colours in the 1 text field Version (include the ver…
-
PARAM_EFFECTIVE_DATE based on payroll balance effective dateHi Team, We are creating report using logical SQL. We are fetching balance details for the whole year. So, Assignment details should be based on the balance effective da…
-
Pictorial Representation of Organization TreeSummary: Pictorial Representation of Organization Hierarchy Content (required): HI Team, How we can create Pictorial Representation of Organization tree. Need to display…Reddykrishna Chidella-Oracle 71 views 21 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to add Project ID to OOB report?Summary: Add a column to OOB report "General Ledger and Subledger Accounting by Journal Lines" for Project ID Content (required): I really like the OOB report General Le… -
Unable to edit delivered RTF report templateSummary: Unable to edit delivered RTF report template Content (required): Hi, I'm attempting to edit the benefits summary delivered RTF template. The issue I'm running i…User_2025-02-11-21-40-21-159 51 views 7 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Report showing new managers with direct reportsContent Hello, We need a report that will show managers with direct reports and the effective date of when they had their first direct report assigned to them. This repo…Shanna Oppenheim 103 views 7 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Employee historical rowsSummary: Looking to get a report of all employees in the system and all of their historical records. If we run the Worker Assignment Real time subject, it can pull histo…Mike Borghoff 51 views 3 comments 1 point Most recent by Mike Borghoff Reporting and Analytics for HCM
-
Seniority Date values are not available in OTBISummary Seniority Date values are not available in OTBIContent Hi Team, Seniority Date values are not available in OTBI, Workforce Management Assignment Real Time and Ev…User_2025-02-06-10-22-06-460 257 views 6 comments 1 point Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
Print performance document from MobileSummary: When i try to print a performance document from mobile, it's blank. I created a custom button to print it Content (required): Talent Management Version (include…
-
Dynamic Pivot column in BI PublisherSummary Need the column of a pivot table to be dynamic in BI PublisherContent We have a requirement to display GL balances by BU hierachy and period. As the users can ru…saravana maneeian subhramaniun 65 views 1 comment 2 points Most recent by User_7836 Reporting and Analytics for ERP
-
Reporting on Transaction Incidents per User?Summary: We would need to be able to report on transactions done by certain users (aggregation of all incidents/controls where the selected user has done possibly fraudu…Ann Van Roosbroeck 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Dynamic file name and dynamic sheet name for excel templateSummary: Content (required): I need to run the report for every month and output generated via Excel template. I need the output file name with the month and year for wh…Jaeyshree Kumaran 281 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Dynamic Pivot in excel templateSummary: Content (required): I have 2 sheets on my excel template output. the second has all the output columns and their data. Based on second sheet I need to create a …Jaeyshree Kumaran 31 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Report on Employees on Leave during a certain time periodContent Hello - We are trying to find a way to report on employees who were/are on a leave of absence during any given time frame. The issue we are having is that there …Shanna Oppenheim 83 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM - Employee termination manager approval comments - how to reportSummary: Content (required): It has been noted that the comments made by managers in the approval of a termination are only part of workflow and can not be reported on. …Annette M 71 views 3 comments 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM