Reports
Discussion List
-
Special Character in Narrative Reporting Bursting POVSummary: Users encounter Smart View error "Member [xyz] is an invalid selection for POV dimension [Department]" when opening a narrative report created by a bursting def… -
Suppress column in MR report for EPCMSummary: I am trying to suppress columns with missing or zero data in the MR report. I have enabled suppression for both zero values and "No data" at the column level as… -
Updating NR reporting using variablesSummary: I have about 6 NR reports that needs to updated to a different monthly scenario every month for reporting the MEC. I thought about creating a substitution varia…
-
List of Special character which cannot be loaded through FBDI file.Summary: We have around 50 Inbound integration from various sources for GL, AP, AR, PO, Receipts. We have observed that if special characters are present in the file lik…Rohan Rajmane-Oracle 318 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
How to call HCM extract parameter in BIP report.Summary: Hi all, I am working on a loopback integration where I have built a BI report which fetches the data according to the parameter which will come from HCM Extract… -
How to update a DFF field from a BI publisher report?We need to modify Generate Extensible Work Order Traveler Report and accommodate a print counter, last print date, last printed by at the top of the report. The purpose … -
What’s New in EPM Cloud Narrative Reporting and Reports Release 25.04What’s New in EPM Cloud Narrative Reporting and Reports Release 25.04 Please refer to the April 2025 What's New Guide to understand the new features included in EPM Clou…Dave Roberts_-Oracle 82 views 3 comments 1 point Most recent by Tom LeFebvre-Oracle Narrative Reporting -
Can you run a process and have the report/file generated from the process sent to a set folder?Hi Everyone, Is it possible to have a process run adhoc or scheduled and when the process finishes the report output is sent to a file/folder location? For example, if o…
-
error using data mode property: Optimize Query ExecutionSummary: Hello everyone, a few days ago I experienced a new situation. I have a report that extracts a large amount of data (over 100,000). I tried to optimize the execu…Ayala01 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Query to Find Privillages under Role and its Inherited RolesSummary: Need query to get privileges assigned under Role and its inherited Roles. Content (please ensure you mask any confidential information): Tried Below query but l…Nishanth B Jain 627 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
I want to restrict last line of any receipt line to be printed in EDI Etext template for the clientWe have 2 new BIP report enhancement requirement To restrict every receipt's last line to be restricted in the query, please see screenshot below for your reference the …Shahid Qureshi 11 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Can i restrict edit access to BI reports to those who creates itSummary: Hi Team, We have a requirement to restrict edit access to BI reports that a certain user has created it. i.e , The one who creates can only be allowed to edit i…
-
Output when using a procedure callHello, I created a procedure call within OTBI. It is a complex PL/SQL that retrieve data from several tables. Each data pushed into a local table of records. All is fine…AA 23 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Is it possible to freeze the OTBI report output header row and column in Oracle Coud PLM.Summary: We are able to freeze the OTBI report output header row in OTBI Reports dashboard (OCPLM). However, the report is shrinking to the corner of the screen with scr…deepashree.sundaramurthy 11 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to create balance calculation date for the reportSummary: Hi , I am working on one requirement , where i need to add balance calculation date parameter to one of the existing report . User is expecting if they give fut…Vishnupriya 24 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Burst Report FormatSummary: I've created a book that bursts to multiple pages. By default, the Report Format shows PDF. I know users can opt to change it to Excel when they run the report,…
-
Counting duplicate in ETEXTSummary I have two record coming from XML , I want to restrict it in ETEXTContent Example - In XML - Employee - 1 has record A1 and Record B1 Employee - 2 has record A2 …
-
💡How To "Attach Lease Detail Report" On Multiple Leases?Summary: How to "Attach Lease Detail Report" on multiple Leases to change the Version Status from "Booked" to "Finalized"? Content: There is a quartz program that runs t… -
Can we send notification to bell icon in Fusion HCM using the BI Publisher reports?Content Is there a way to send the notifications to the bell icon in the Fusion HCM by running the BI reports. Please provide your inputs on this. Thanks and Regards, Am…Amrit 141 views 8 comments 0 points Most recent by Bharadwaj Pisipati Reporting and Analytics for HCM -
Identify or link to affected embedded Grids/Charts in PPT docletSummary: Multiple embedded grids and charts in one single slide are broken and unidentifiable. Grids/charts come from multiple reference doclets. Content (please ensure … -
How to fetch email ID of an user in oracle fusionSummary: How to fetch email ID of an user in oracle fusion Content (required): How to fetch email ID of an user in oracle fusion. I have the value of username and need t…Neelesh Varma 6.1K views 15 comments 0 points Most recent by SukanyaGhosh2502 Reporting and Analytics for HCM
-
Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Summary Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Content Is "EDI Location Code" available for Reporting in Customer Real Time Su… -
Using new Reports, how can you create with a prompt and also POV?In the old Financial Reporting, you could create a way to select a member via a Prompt and have it show up in the POV returning the selected dimension member, and then c… -
Report for specified pay period that shows time card hours paid and costsSummary: I need a report that can be run by department to show hours reported and the associated pay costs thru payroll. I am attempting in OTBI with Payroll Run Real ti…Giselle Valdovinos 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Payroll DD/Taxes Report SQL HelpWe have a New Hire Direct Deposit/Tax report that captures employees who have not completed DD and/or Taxes. How would I update the query to pull all new hires/rehires (…
-
How to bring history data using PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE in HCM ExtractWe are using PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE in our HCM Extract to fetch "Full Time or Part Time" field along with other fields. The requirement is to fetch for fut…
-
Which table contains the cross charge business unit exceptions?When creating a project there is a section on Cross-charge options that lets you specify "Allow Charges from All Provider Business Unit". There is then an area to add a …
-
Project Costing - Actual Costs Real Time: want to summarize totals by GL expense accountSummary: Project Costing - Actual Costs Real Time: want to summarize totals by GL expense account. The subject area itself includes fields like Natural Account, Concaten…