Reports
Discussion List
-
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 21 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 21 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 101 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 589 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 12 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 494 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
-
Cannot access name on errored out EssBIPJobSummary: 24C version The errored out process name is not displayed, when i check from Report job history page, not able to check the details of this ess bipjob, can anyo…Shahid Qureshi 31 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Need table names or SQL for Approved OTL timecard details in BIPSummary: Hi Team, I Need table names or SQL for Approved OTL timecard details in BIP. We need particular person entries and along with approver comments. Navigator->my c…Janardhan ACS-Oracle 301 views 5 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
XMLP Server - Security & User AccessSummary Testing security and user access of XMLP ServerContent Hi All, We are looking to restructure our Reporting Catalogue for our HR users where they will use a dashb…User_2025-02-05-05-51-12-049 30 views 10 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Is it possible to include Null values in BIP Report Parameter?I'd like to pull null values within my report. Is it possible to run the report with 'null value' parameter?
-
Report on User Actions in Oracle HCMSummary: Good evening, I need to extract a report with all the actions performed in the system by users (e.g., hiring an employee, entering Performance Goals, etc.). Is …Guido Masciello 21 views 2 comments 0 points Most recent by Guido Masciello Reporting and Analytics for HCM -
GenAI in Cloud EPM Narrative Reporting – Your Feedback is Requested!We released our first phase of GenAI capabilities in Cloud EPM Narrative Reporting (Enterprise) in our 24.10 (Oct, 2024) release. While we are busy working on the next p… -
Length of service calculationSummary: How to calculate Length of service from latest hire date of employee? Content (required): I am using Workforce Trend Real Time Subject Area, I need to show the …Raghavendra M 785 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM