Reports
Discussion List
-
CTE does not work for all casesI’ve received a request to create a BI Publisher report that meets the following business requirement: Given a date parameter (e.g., 31/12/2024), the report must return … -
Using the new Reports, can you reference the members in another data row?Summary: Using the new reports, can you reference the level 0 members of another row where the data has been suppressed at a parent level, returning only the data wanted… -
How to split a single row into multiple rows in oracle fusionDear All, I got an requirement like need to split single row into multiple rows dynamically, but here that single row is having value like 99 so i need to split 99 rows …
-
Batch scheduler feature in Report moduleSummary: We are in process migrating all reports from FR to Reports. In financial reports, we are using a batch scheduler process to run scheduled multiple reports and m…
-
Is there a report that will show all data roles and their security policies?Summary: Hello - Our organization has 3 Document Type Security Profiles created that are spread across many roles. Instead of manually trying to find which data role has…
-
SQL Statement for AR invoice including attachment line informationSummary Receivables Transactions ExtractContent Hello I am wondering if you can share with me any SQL to extract AR information, including attachment information. I have…gabriel kinovisques-163562 2K views 7 comments 0 points Most recent by JimCC Reporting and Analytics for ERP
-
Narrative Reporting GenAII saw this demo video (link below) for Narrative Reporting, but I don't see any documentations on how this can be configured in EPM. Is this something we can achieve in …
-
Enable Generative AI Assist in Management ReportingWe are currently using Oracle Enterprise Performance Reporting Cloud Service and are exploring the use of Generative AI Assist within Management Reporting (Narrative Rep… -
Public IP Address?Summary: Hello, our data team is interested in using SFTP to have the ability to automate reports from Oracle to our dashboard and have real-time updates. However, our I…B_Meiling 51 views 1 comment 1 point Most recent by Andrada-Oracle Fusion Applications Administration -
Extract Expense Lease Schedules questionSummary: the option = Incremental: Purges and re-extracts schedules for leases that were booked or amended since the last extract run (this is the date when the process …
-
submission note not copiedWorking on 25A, when Import Costs is submitted, I enter a Submission Note 'aaaa' , then at completion, the Report is submitted with another Process id, is it posible to …maria.torres 11 views 1 comment 0 points Most recent by Clara Azoitei-Support-Oracle Project Management
-
Oracle Fusion BI Publisher - RTF - Generate Multisheet Report Excel OutputSummary: Hi Team, We have a requirement where we need to generate an excel output with 3 tabs in the output file. Sheet1 name: Static value as "Parameter" and it has to …
-
Payroll - Calculation Cards Real Time FieldsSummary Trying to find two specific fields withing Calculation Cards Subject Area: Issuing Authority and Order Amount Payee.Content I am working on building a report for…
-
query to get variable rate program for all employeesSummary: Content (please ensure you mask any confidential information): Hi all, I currently have a query where I am trying to get the variable profile name (under manage…Steph96 162 views 3 comments 0 points Most recent by Matheus Roberto Reporting and Analytics for HCM
-
I need help on my SQL for With and Without Goals ReportSummary: Hi, I hope someone can help me with my query. Only the employees "With Goals" are showing up. The employees "Without Goals" is not showing up in the report. I n…
-
Valid intersections do not work in EPM Reports?Summary: Valid intersections do not work in EPM Reports. Is this expected behavior? Content (please ensure you mask any confidential information): Valid intersections ar…
-
OTBI reporting errors after 25B release - Error generating view. Error getting cursor in GenerateSummary: After the 25B release on May 17th 2025, many of our reports are now failing to run, and presents error below. Reports which are run return a mixture of differen…Ray727 446 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Mapping Audit ReportIn FDM we used to have custom reports for audit mappings. How do we create custom reports in FCCS? The standard mapping audit report in data management is formatted in a…Brian Duncan 21 views 2 comments 0 points Most recent by Brian Duncan Financial Consolidation and Close
-
What values should be passed in lexical Reference sql-Q_Pick_slip_Number?Summary: Hi Experts, What values should be passed in lexical Reference sql-Q_Pick_slip_Number? Thanks Content (please ensure you mask any confidential information): Vers…
-
We have a requirement to modify Sales Order Acknowledgement Report Data ModelSummary: Hi Experts, We have a requirement to modify Sales Order Acknowledgement Report but and this report having xml file when we added new dataset to add new fields b…
-
How to assign project code creation role only ( Edit, delete) to users.I have requirement to provide project code creation role only to users. But users already have project related roles and General ledger related roles. it's not possible …
-
Report on Benefits Self-Service Enrollment actionsSummary: Looking for a way to report whether employees went through the Benefits Self-Service enrollment process thoroughly. For example, did an employee click on Enroll…
-
Competency proficiency reporting - employee and manager ratingSummary: Hi there, I need help where to find the Employee rating for Competencies. The Manager rating is located in this folder "Workforce Performance - Performance Rati…
-
How to find the customer information from Manage Financial Project SettingsI want to retrieve customer information from Manage Financial Project Settings page. Can anyone help on the query? -
Adding BIP report to OTBI dashboardSummary: I am adding BIP report to OTBI dashboard. The BIP report runs fine individually, but when I add it to a dashboard and preview the dashboard. Nothing shows up. P…
-
Third-Party Payment Register Report is blankSummary: After running and generating payment, when I run the Third-Party Payment Register Report it keeps coming blank with this message: This process is in Completed s…
-
Smartview Report HsgetValue to retain data when it is openedSummary: Smartview Report HsgetValue to retain data when it is opened by the user who does not have Oracle connection Content (please ensure you mask any confidential in…
-
Unable to run reports or view it's dataDears, we have a custom role called profile specialist to handle all the transactions of profile management and it's copied from human resources specialist seeded role t…Nariman.Moussa-Oracle 11 views 2 comments 0 points Most recent by Nariman.Moussa-Oracle Reporting and Analytics for ERP
-
How do I convert the field Time.Month from CCYY / MM to just show the month?Summary: The Time.Year fields just displays the year The Time.DayofMonth fields just displays the day The Time.Month field displays the year and month. I need the Time.M…Mark Stoker 61 views 11 comments 0 points Most recent by Mark Stoker Reporting and Analytics for HCM