Reports
Discussion List
-
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …Robinson Antunez 194 views 10 comments 0 points Most recent by Rosita Santosuosso Reporting and Analytics for ERP -
Set different alias tables for different columns/rows.Suppose in my report i have selected alias table A, which is what I want for my Accounts which are present in rows. Now for the Entities present in columns, i want to us…
-
Concatenate Cell Text or Value within ReportsHello, I'm trying to build a report within the Reports section of Planning that will concatenate a Member Name with the Cell Text or Value from the output of the report.…
-
Can I use Copilot in narrative reportingSummary: I want to integrate Microsoft CoPilot into Narrative Reporting reports with Gen AI to utilized summary of the comments with Gen AI and Comments submitted by the…
-
Query for Projects, Subledger and General LedgerSummary: Query for Projects, Subledger and General Ledger Content (required): Hello I was wondering if you can share with me any Query for Projects, Subledger and Genera…
-
User is unable to enter the comments in Narrative ReportingSummary: The users have below access, but still they are unable to enter the comments in Narrative Reporting (Can view the comments entered by Admins, though) Power User…
-
Limiting restricted, Confidential and PII fields BI Authors in HCMSummary: Our goal is simple: Make OTBI authorship available to as many HR and potentially non-HR employees as possible while being conscious of security. Example: Make a…
-
Query to get Languages in ORCSummary: Based on the screenshot I provided, What table in HCM can I get the list of values for the Languages in ORC. Content (please ensure you mask any confidential in…
-
Is there a way to change the default export format to xlsx in ERP?Summary: We use Excel 2024. When exporting reports out of ERP, they default to Excel 2007. Is there a way to change the export format to xlsx? Content (please ensure you…
-
Extract the transaction console comment in OTBIHello, I have a requirement where I need to report (in OTBI) on the comments visible in the Transaction Console. Specifically for the termination quick action, in which …Sara Suleiman 21 views 3 comments 0 points Most recent by Sara Suleiman Reporting and Analytics for HCM
-
EPBCS Reports vs EPCRS Narrative Reporting reports: what tool to choose?Summary: I need to build simple tabular reports with the possibility of creating books from these reports. No complex formatting or commentaries are required. The report…
-
Dynamic Header generation in RTFSummary: Is there a way to create an RTF or Excel template that allows us to dynamically populate the header? Content: The requirement is to fetch pre‑screening question…
-
Privileges to view reports in BI Catalog without access to transactionsSummary: Requirement for custom role only to access reports in Business Intelligence Catalog for all Procurement Functional Area folders Content (please ensure you mask …Shirlene Chan 61 views 7 comments 0 points Most recent by Ravi Shinde Reporting and Analytics for ERP
-
Financial Reporting Studio Issue: 2026 Data Not Appearing (current Year)Dear Oracle Support, We are encountering an issue in Financial Reporting Studio (FRS) that is affecting the display of 2026 data in our reports. Pervious year data showi…
-
Can Reports in the Navigation Flow be configured to open in a new browser tab?Can cards in the Navigation Flow be configured to open a report in a new browser tab (similar to how drill to content links within reports will open new browser tabs)? I… -
Is it possible to preserve report prompts?Summary: Here is a screenshot from a PowerBI dashboard. I selected two members (highlighted in the green box). The report shows me details for the selected members and t…
-
We tried to use Reflect Changes from Edited Reports Sooner solution in fusion but it is not workingSummary: Hi team we have made the changes in the PR PO Approval Pages as per our requirement. We need to test the output. As a standard functionality system will take 24…
-
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am …Sowdha Murugan 369 views 6 comments 0 points Most recent by Neha Thakre 2023 Reporting and Analytics for HCM -
How to create a report that includes employee information and the date of the last system access.?I'm trying to create an analysis with the last access information of employees to Oracle Fusion Cloud and I'm having trouble. Could you help me retrieve this date in the…Fernando A Nascimento 12 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Required table for "Direct Apply" section under the task "Recruiting Category Enablement"Summary: Hi Team, We are unable to find the table for the field "Direct Apply" under the setup task Recruiting Category Enablement. The main table are IRC_TP_PARTNERS, I…Opkey PA 1 view 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace
-
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…Meenakshi K 1.2K views 8 comments 0 points Most recent by Chiranjeevi Boya Reporting and Analytics for HCM
-
Incorrect drill-down results (action link to BI content) when using UNION in OTBI AnalysisI've written an analysis against the Workforce Goals - Goal Status Overview Real Time subject area. I had to use a UNION to accommodate some complex criteria and breakou…Shawn Gertler 11 views 7 comments 0 points Most recent by Shawn Gertler Reporting and Analytics for HCM
-
SQL to get the list of all tax codes definedSummary: Hi, Can anyone please share the SQL to get the list of all tax codes defined. Or are you aware if there is any standard reports which is available that can prov…
-
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 67 views 14 comments 0 points Most recent by Milan_Chandra Reporting and Analytics for HCM -
Why do report rows expand down while form rows expand up?Summary: I have noticed that while using the row zoom feature in reports the child members appear below the parent. In forms 2.0, the child members appear above the pare…
-
Highest Education level not showing in OTBI person profile subject areaSummary: Hi Team, we have need to extract the report of each employee of highest education level but not coming in workforce profile - person profile real time . ANy one…AjayKumar Maddipati 171 views 6 comments 0 points Most recent by User_IHDYF Reporting and Analytics for HCM -
Multi-Grid Row AlignmentI have a report with two grids, one from FCCS and one from EPBCS. I have the row height set to exactly 0.2 on both grids. I have both grids set to Fixed horizontal and v…Patrick Northcraft 21 views 5 comments 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting -
CHAT_STORE External REST Tool Entering Loop in FusionDescription: I have created an External REST tool (CHAT_STORE) in Oracle Fusion to store USER chat history with AI Agent(OOTB/Custom Agent(RAG)) in an ATP database. Issu…