Reports
Discussion List
-
Request Read Receipt while scheduling BI ReportsContent I have scheduled a BI report and enabled Request Delivery Status Notification and Request Read Receipt Option. But I havent received any email or notification af…Sabarish Reddy Ganda 128 views 1 comment 1 point Most recent by Usman Ali2025 Reporting and Analytics for ERP -
Cannot open OTBI Report Workforce Compensation subject areaSummary: Content (please ensure you mask any confidential information): Hello experts, when opening the attached OTBI report the system doesn't return any value. However…Valerio Curzi 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Dynamic scaling in reportsSummary: We have customers who would like to be able to choose the scaling in reports at runtime (as there are different requirements for different purposes). Fiscally t…Tjeerd Huisman 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How can I get the usage details of the FR reports?Hi Team, We need information regarding the usage details of the FR reports i.e. which FR Reports are generally used by the Users on a frequent basis. Also, it would be h…KIRTI SETH 21 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Audit Trial for Workforce Compensation Approval taskSummary: Content (please ensure you mask any confidential information): Hello experts, when approving compensation plan (Approval task) the name of the last approver alw…
-
Unusable FCCS SmartView/Report Retrieval Performance with DSO configurationSummary: We are developing a new FCCS application using the DSO (i.e. Dense Period and Movement dimensions) configuration. The SmartView retrievals and reports take upwa…Ken Chen666 72 views 11 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close
-
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 31 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 1 view 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 282 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 15 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 537 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 14 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 23 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM