Reports
Discussion List
-
Any Oracle plan to separate or hidden Data & Reports under Library in the future?Summary: FCCS Data & Reports both are under same Library after migrating FR to MR Will they be totally separated or totally hidden each other in the future? Content (ple… -
SQL query or Table for Actions under Transaction Design studio in oracle fusion HCM my client groupSummary: Hi Team, We need a table name or SQL query where the information of Actions under Transaction Design studio in oracle fusion HCM my client group. Content (pleas…
-
Facing issue to fetch proposed value of Pending TransactionsWe are trying to fetch proposed valued of pending transactions. Transaction is on Assignment change, I have written the following code but getting ORA19011: "Character s…SWAGATA1991 32 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Oracle ARCS Custom Report-Date parameterSummary: Client has a requirement wherein they want to generate report on month to date basis. Meaning when I generate report today (22/10/2024), it should fetch transac…
-
While editing the report the message showing session has timed out and is no longer activeSummary: While editing the report system logging off automatically. Content (please ensure you mask any confidential information): Version (include the version you are u…
-
Need to know DB table for BIP report history 'Output and Delivery' sectionHi team, We need table name to build report to extract 'Output and Delivery' (highlighted in orange box)from BIP report history, any help is highly appreciated. Regards,…Kalpesh Salunke-Oracle 3 views 0 comments 0 points Started by Kalpesh Salunke-Oracle BI Publisher Learning Center
-
How to get users last login dateContent Hi, We have requirement to fetch all users last login date and time. May i know which table can help to get the info. I tried FND_SESSIONS and ASE_USER_LOGIN_INF… -
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 271 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 84 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…
-
Browser is getting automatically refreshing when scheduling ESS job set in Oracle cloud ERPSummary: Hi All, I hope everyone is going well!. I need some help in resolving the ESS job set related problem. I have created the ESS job set with 10 Ess jobs inside of…VasanthaFusion90 26 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
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 492 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 21 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 15 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 22 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Query to find fusion user details with their rolesI need to create a BI report which retrieves user information like user_id,username , email of the users along with their role information like role_id,role_common_name,…Rithu123 2K views 7 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 139 views 8 comments 0 points Most recent by Bharadwaj Pisipati Reporting and Analytics for HCM