Reports
Discussion List
-
Request for Custom SQL Query for SaaS Service Usage Metric Report (Oracle Fusion Expenses)Hello Team, We are in a need of a custom sql query which Oracle uses to populate a count for the below service in the SaaS Service Usage Metric Report, as we got to know… -
Show Account Owner Name in Narrative ReportHello, We would like to show the owner's name of an account combination on an Expense report in Narrative Reporting. For example - When we select these values on the POV…
-
Language translation in oracle standard notificationsHi, I want to edit the rtf template according to the language of the standard notifications that I want to edit in Oracle. For example, where can I edit the Turkish RTF …Cansel Karasoy 41 views 9 comments 0 points Most recent by Oriana L. Reporting and Analytics for HCM -
Oracle EPM SmartView pulling backend 16 digit numbers instead of members from Fusion ERPWhen we tried to login into Oracle Fusion ERP through SmartView and perform adhoc analysis, we encountered an issue having 16 digit numbers instead of member names/Alias…Suriaraj.Krishnamurthy 1 view 3 comments 0 points Most recent by Suriaraj.Krishnamurthy Reporting and Analytics for ERP -
Fetching employee using BIP query if employee have Job changes and TerminationSummary: Fetch the details of employee who have job changes and termination details of employee Content (required): Hi, I am working on BIP query to fetch the details of…Kamini Kaushik-Oracle 542 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Project Contract List Dashboard with Null Project NumberSummary: Hi In the analytics, there is project contract list dashboard. When we run this dashboard, there is contract with null project number. When we check in the UI, …
-
Is it possible to enable audit and tracking of all user activity?Summary: Business requires all user activity regardless of module and transaction within the Fusion SAAS ERP to be tracked. Is there a way to achieve this functionality?…
-
OTBI external identifier not appearing when Department is selectedHello I am trying to get a specific external id type through OTBI. I've managed to do this using MAX (there are multiple types), but when I add the Department, position … -
ESS JOB User defined list of value with multiple displayed fieldsSummary: Creating a parameter for a custom ESS Job with a custom list of value . Content (please ensure you mask any confidential information): In Oracle Fusion I've cre…
-
OTBI Training Tutorials on YouTubeSummary OTBI Training Tutorials posted on YouTubeContent 26 OTBI, BIP & SmartView tutorials are now available on YouTube, Oracle Learning Library and Oracle HCM Cloud R1…User720640-Oracle 448 views 8 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Custom role to access "Goods Received Not Invoiced" standard fusion reportHi Team, We are trying to provide access to user to "Goods Received Not Invoiced" standard report using a custom role. What are the privileges required to give access to…Ramneet Kaur 24 views 4 comments 0 points Most recent by Ramneet Kaur Profitability and Cost Management
-
possibility to display the currency name besides the Local currency in REPORTSummary: Content (please ensure you mask any confidential information): Hi all Our CFO would like to see in a REPORT, displayed the Local Currency with the name of the c… -
Using descendants in Reports zero suppression is not workingSummary: We have migrated reports from Fin Reports to Reports. We are using Descendants in many rows and have zero suppression turned on (i.e. zero suppression appears a…Laura Cohen 22 views 3 comments 0 points Most recent by Laura Cohen Financial Consolidation and Close
-
BIP Report: Position title change data irrespective of their current employment status.Summary: Hi experts, I am looking for a report which can return previous and current employment fields if position gets changed. Mainly looking out for these fields: Pre…
-
Is it possible to create a pivot table "view" in Excel BI Publisher?Summary: Is it possible to create a pivot table "view" and one with a report in a regular table? Content (please ensure you mask any confidential information): I'm tryin… -
SQL script for job roles inherited by data rolesSummary: Trying to build a query to fetch users with their data roles and inherited job roles. I am able to fetch the data roles and job role assigned assigned directly …Vaishnavi Agrawal 103 views 3 comments 0 points Most recent by Ranveer.Tiwari-Oracle Reporting and Analytics for ERP
-
How to Join ZX_LINES and XLA_AE_LINES to Get Tax Details (Rate, Amounts etc.)Good Day Experts, How can I join ZX_LINES and XLA_AE_LINES? I have a custom tax report where subledger debit/credit amount (Item Expense or Revenue) is displayed then th…
-
Can you leverage EPM Automate to download Report Books to a local folder location?Summary: I am looking to auto generate about 20 different report books that I want to store for our business partner in a CHR folder - currently they are just running th…
-
I am trying to add Division to an analysisSummary: I am trying to create a "Master Employee Data" report that includes payroll information so I'm using the Compensation Details - Salary Details Real Time subject…Jenna Savage - Hunter Douglas 71 views 12 comments 0 points Most recent by Jenna Savage - Hunter Douglas Reporting and Analytics for HCM
-
How can we find out if there has been a recent change to Oracle ISP geolocation reporting?Summary: We're having new difficulties since about 1/25/2025 with the reported geolocation of an Oracle IP address used to deliver reports. Can we find out if there has … -
How to make US1099 report to be emailed to Vendor?Is there a way to email US 1099 to the email addresses on file? User has run this in excel and .pdf - just need to know how to distribute by email to the vendor to the a…
-
Query to fetch DFF's used across modules in a PODSummary Query to fetch DFF's used across modules in a PODContent Hi Team, Please help with this: Please share query which shares all DFF's used across modules in a POD l…C.R.Balaji 592 views 2 comments 1 point Most recent by Silpa Sathyan Poyyara Reporting and Analytics for HCM -
Need to report on Work schedule with attached work pattern and attached holidaySummary: Hi Every one, I need help to develop one absence report where we can see work schedule and attached exceptions and workday/non workday. Below is sample output:-…Krishna Manmohan 11 views 1 comment 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM -
Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsSummary Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsContent We have a BI Publisher report where we are showing Project profitability and showing all…User_2025-01-28-19-49-26-512 501 views 19 comments 2 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
Oracle OTBI Report View does not run for wider searchThe only table/view I have been able to identify, that provides OTBI report usage statistics is the BIPUBLISHER_V view as provided by Oracle. This view consistently eith…Marko Puskac 21 views 2 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
How to import PBCS report into NRCSHi, We want to export a report from PBCS environment to a NRCS environment. We've tried exporting the report in XML format through the Migration card. When we try to imp…Guntuka VenkataKrishna 11 views 2 comments 0 points Most recent by Guntuka VenkataKrishna Narrative Reporting
-
how to add missing Font "menlo" in report settings.Summary: how to add missing Font "menlo" in report settings. We are migrating FR Reports to reports. Our reports have validation error with Font missing(error message be…Divya_Masoodi 51 views 4 comments 0 points Most recent by Divya_Masoodi Financial Consolidation and Close