Reports
Discussion List
-
Generate blank BIP reportHi Team, We have a BIP report in Oracle fusion that has a bursting code. This works fine when there is data for report. However, if no data is returned by the underlying…Prabhjeet Kaur 361 views 5 comments 0 points Most recent by Cm Adil Ch Reporting and Analytics for ERP -
Output tab when scheduling a processHello On some standard reports, they don't have Output tab when scheduling the process but some do. Anyone know if we can set the Output tab to display or this is what i…Kamonwan Srasrisom 21 views 2 comments 1 point Most recent by Kamonwan Srasrisom Reporting and Analytics for ERP
-
Subject Area to capture Employee detailsSummary: Content (required): Hi, Can someone please let me know the subject area to be used if the requirement is to capture the username, employee first name, employee …Sheneli98 1K views 12 comments 1 point Most recent by Nareshbabu Mallela Reporting and Analytics for ERP
-
Cash to General Ledger Reconciliation ReportSummary Cash to General Ledger Reconciliation BI ReportContent Hi Friends, Did anybody Customized " Cash to General Ledger Reconciliation Report" or developed new report…OraFusionworld 112 views 4 comments 0 points Most recent by Vicky Adwani Reporting and Analytics for ERP
-
How to archive entire catalog (Shared and Users)?Summary: With an administrator role, I would like to archive the whole analytics catalog to backup all Analytic Objects (even the objects in users folders). During P2T o… -
Duplicate descriptions across summary vs postable valuesSummary GL_SEGMENT_HIER_INTERFACEContent Will it cause issues if there are duplicate descriptions on a Summary/Non Postable value vs a Non Summary/Postable value? I've m…
-
how to create pivot table in a BIP report ?I am creating a work in progress report using BIP. I have projects with costs and revenue distributed on months. how can i get an output like this image. does anyone hav…Omran Zeaiter 242 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
date masking reverting date back a daySummary: We have customized the AP invoice approval report to add fields needed. Content (please ensure you mask any confidential information): Issue is that the date in… -
A report that tracks user access activity historySummary A report for security that tracks user login history what data or module was touchedContent Does anyone know how/where I can get this information together? This …Kimberly Nguyen 290 views 18 comments 0 points Most recent by Mayur_P Reporting and Analytics for ERP
-
Statement of Directions on FRS in Cloud ERP?Hi, Does anyone know if/when FRS is going to be retired in Oracle Cloud ERP and moved to Management Reporting like is being done in EPM? Trying ot understand if we wait …Hyperion_Junkie 21 views 1 comment 1 point Most recent by Hyperion_Junkie Reporting and Analytics for ERP
-
Report output name incorrect when downloading scheduled job outputs after upgrade to 23DSummary: We scheduled reports and when downloading it is generating name with % instead of space , but when republished it gives correct name for output file after upgra…Abhilash K - Deloitte USI 21 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
ESS Job vs BIPSummary: ESS Job vs BIP Content (required): Assuming we don't have any dependent list of values, is there any strong/security reason we should use ESS Job on top of the …Vinay Gharge 554 views 2 comments 0 points Most recent by User_8FGMM Reporting and Analytics for ERP
-
How to get customer AddressType from background tableSummary: When I enter the url below in browser, I can get AddressType, I need to build a data model and get similar info for a customer. https:///crmRestApi/resources/11…
-
How can I join the hz_parties table to a project number or contract number table using sql.Hi everyone, I'm creating a work-in-progress report that tracks project costs and needs your help joining several Oracle tables efficiently. I'm working with: PJF_PROJEC…Omran Zeaiter 1.1K views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to get output character set in ANSI for etext templateSummary: In Oracle etext template is set to "iso-8859-1", what value we need to provide to change it to ASCI. Content (required): Version (include the version you are u…SireeshaJaladi 495 views 2 comments 1 point Most recent by Yves Chanel Reporting and Analytics for ERP
-
How To get Cancelled Invoice Amount in AP Invoice in Oracle FusionIs there any ways to retrieve Cancelled AP Invoice Amount in Oracle Fusion Using SQL Script.EPNSLsupport 443 views 4 comments 0 points Most recent by EPNSLsupport Reporting and Analytics for ERP
-
ZIP and PDF inquiries for Oracle BIPSummary: 1. We are trying to create bursting email which sends 1 zip with multiple pdf(separated by invoice). 2. In history we have a consolidated output which has 1 zip…
-
How to Display Date and Time as per User Local Settings in Excel TemplateSummary We need to display the Date and Time as per the User Regional Settings. We need to know how to use the XDODEFDATE and XDODEFTIME in Excel TemplateContent Our Req…Balachander G-Oracle 394 views 4 comments 1 point Most recent by Abhiengine Reporting and Analytics for ERP
-
Querying GMS_XCC_BUDGET_BALANCE_V results in timeout error in FusionWe are getting timeout error while Querying GMS_XCC_BUDGET_BALANCE_V results in timeout error in FusionAbhilash K - Deloitte USI 51 views 8 comments 0 points Most recent by Simon Hong Reporting and Analytics for ERP
-
The Picture can't be displayed error in multi sheet excel templateI created an excel template which has multi tabs created dynamically. Logo in first tab displays fine while in rest of the tabs it displays error The Picture can't be di…Aakancha 31 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
Unpaid ReasonSummary Unpaid ReasonContent Which subject area and/or database table and column would store the "Unpaid Reason"? I am looking to create a report with this field. Thanks…Andrew_Schmitz 144 views 6 comments 2 points Most recent by __KumR__ Reporting and Analytics for ERP -
Schedule BIP report only when it has DataSummary Schedule BIP report only when it has DataContent We have one requirement for BIP report where we have schedule BIP report daily. so we need that if report data i…User_2025-02-07-23-45-47-870 517 views 7 comments 1 point Most recent by User_A19YQ Reporting and Analytics for ERP -
Slowness of report after upgrade to 23DSummary: A report which ran in less than a minute in 23c is taking 12 mins to complete for the same data post upgrade to 23D. We had 23D upgrade in all non-prod PODs and…Abhilash K - Deloitte USI 41 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
FRS with records exclusion for given company/PBSSummary: is it possible with FRS to exclude certain CoA records for one PBS value but include for other PBS value? Content (please ensure you mask any confidential infor…Roman Havrylyak 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
OTBI - Withdrawn Sickness output not displaying in Absence Real TimeI have built an OTBI report in Workforce Management - Absence Real Time, that I intend to use to report on sickness absence with a 'withdrawn' status. However, nothing i…
-
Financials Cloud OTBI Release 12: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this…Anand DN-Oracle 394 views 6 comments 3 points Most recent by Ajay Hareesh Reporting and Analytics for ERP
-
How to merge customer names with transactions in a grouped SQL query?Hello, I have this customer ABC having multiple transaction i want to merge the cells that have the same customer name and make it appear one time, i am using select fro…Omran Zeaiter 31 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Receivables Sales VAT Register for Italy ended in error without outputSummary: Dear All, I ran Receivables Sales VAT Register for Italy and Purchase VAT Register for Italy but they ended in error Content (please ensure you mask any confide… -
Scheduled Jobs ErrorSummary: Hi Team, We have few scheduled jobs which will run on daily basis. Recently few system automated jobs and manual scheduled jobs ended in error without any log f…Sesha Sailini 21 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Trending FRS Report to exclude 13th Period?Summary: How to exclude 13th Period in Fusion FRS Report? Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snip…Prakash.Malmarugan 111 views 6 comments 0 points Most recent by Kenney Reporting and Analytics for ERP