Fusion Financial reporting
Discussion List
-
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…SireeshaJaladi 1K views 18 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for ERP -
which tables store information about data access set for user?I need to a query to read for each user which BU have access to
-
Is it possible to make import output with capitalize letter even original data stored as uppercaseIs it possible that original data is all uppercase but transfer to captalize letter in output report? for example， JIM CHUNG, but in expected output, need to be Jim Chu…
-
Can we data mask certain fields within BICCSummary: As Oracle provides BICC as a tool to extract data from Oracle Fusion Cloud through UCM for customers to further analyze or report this data. We have a legal req…Ravi Upadh 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How can i get currency report to show currencies and the exchange rate against a currency in OTBIIgnore- Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):ACDC 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
BIP Scheduler is not working for Monthly jobI have scheduled my BIP report for 1st weekday of every month but it is not triggered. I have attached Screenshot of my schedule. Please Advise. Thank You, Khushi
-
Tax Audit Trail Report export to excel not working properlySummary: Tax Audit Trail Report export to excel not working properly. This started happening in Feb25 after patch. HTML looks ok but when you export to excel it is messe…
-
fdi first valueIn FDI what is the formula to get the first value (or last) for a field that may have multiple values. Instead of displaying multiple rows that show each of the values I…
-
Receivables-Transactions Real time how to add Transaction Line DescriptionSummary: I am trying to create a Dashboard for AR Transaction Listing with Minimal number of fields. The dashboard looks ok until I add Line Description from the Subject…
-
Journal Entries And Subledger Details Query HelpSummary: We just implemented Fusion Cloud/Financials so I'm very new trying to figure out the database tables and relationships. I've been tasked with creating a custom …
-
Oracle Fusion BIP Report ESS Job Parameter Error & How to Enable XML and Diagnostic LogsHi Team, I’m facing an issue when scheduling the ESS job — as soon as I select the parameters, it immediately throws an error. The current log doesn't provide enough inf…Ashish1Soni 21 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Project Period Close Exceptions DashboardSummary Project Period Close Exceptions DashboardContent Project Period Close Exceptions Dashboard - Anybody created as shown in release document. Attached screenshot -
Add PDF Attachment to Email Bursting MethodSummary I want to attach a specific pdf file as an attachment to emails sent by a bursting methodContent I created a data model that looks at overdue invoices and produc…User_2025-02-06-06-16-56-136 228 views 4 comments 5 points Most recent by BillM Reporting and Analytics for ERP -
Print receivables transaction Ess job bursting queryHi all, I have a requirement to edit the email body of the invoice email that is being sent after the ESS job has completed. As standard it is sending the email and the …
-
Cash Flow Statement Generation - FRS or Other Reporting ToolsSummary: Cash Flow Statement Generation - FRS or Other Reporting Tools Content (please ensure you mask any confidential information): Hi Experts, Please advise as to whe…Nicole Deleon 13 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
How to get the last period of previous fiscal year in FRSThere is a requirement in balance sheet report where we need to get the details for Previous Year Ending(PYE) balances in one of the column in FRS report. For Ex: Curren…SRIKANTH DEVARASHETTY 31 views 2 comments 0 points Most recent by SRIKANTH DEVARASHETTY Reporting and Analytics for ERP
-
difference balances xla_ae_lines and xla_ac_balancesSummary: We created an OTBI report in the "Subledger Accounting - Supporting Reference Real Time" subject area, and it doesn't contain a value for a supporting reference…
-
ZATCA verified XML embedded inside PDF outputSummary: We have a requirement to embed ZATCA verified XML inside Invoice PDF output. When user runs the report this XML should be attached within the PDF. Content (plea…S Usman ali 11 views 0 comments 0 points Started by S Usman ali Payables, Payments & Cash Management
-
Creating a Batch in FRS (Oracle Cloud ERP)Summary Creating a Batch in FRS (Oracle Cloud ERP)Content Navigate to Work space for financial Reports I am trying to Schedule a Batch. I believe I need to create a batc… -
How do i know which field in the fusion frontend is related to which table column in backend?Hi Experts I am new to BIP report development. Customer sometimes just give screenshot from fusion and ask to create report with those field . Is there any way where i c…Mainur-Oracle 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Fusion BI Report Time zone issues in report output related queriesOur users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries b…Abhilash K - Deloitte USI 434 views 8 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to hide "set ownership of this item" from properties option in Report and Analytics ?We have a requirement where business is asking to hide "set ownership of this item" for users with specific roles. we tried to hide from "Manage Privileges" but some how…
-
BIP Report - Security - Role/Privilege required to access data in XLA tablesSummary BIP Report - Security - Role/Privilege required to access data in XLA tablesContent Hello, We developed a custom BI publisher report having XLA tables in the Dat… -
Customize Printable Expense ReportSummary & Content: Need details for the other VOs and the attribute list similar to what was provided for PrintableReportVO and PrintableExpenseVO in the Oracle Ddocumen…Upendra Nayak 94 views 3 comments 0 points Most recent by User_QPZXD Reporting and Analytics for ERP -
Item number field is not reflected in the Procurement Requisitions Real Time subject areaI used the Procurement Requisitions Real Time subject area in OTBI to build a report. There is just one field in the underlying source data that is not reflected in the …Walter L Gess 11 views 2 comments 0 points Most recent by Walter L Gess Reporting and Analytics for ERP
-
Need to report all journals and subledger activity (drilled data) on one reportSummary Currect reproting only allows reporting by one source at a time, need to see all for one account in single reprot.Version Fusion Cloud 20D -
When Scheduling a Bursting Report, the Parameters in trigger are Not Loading on the Schedule TabI have a BI Publisher data model that accepts a :from_date parameter and includes bursting logic. To handle the "no data found" scenario during bursting, I created a tri…Voladri Saikiran 32 views 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP
-
Is it possible to split a concatenated segment (accounting combination) in an OTBI reportSummary: I am trying to split the concatenated accounting combination into different columns, each column should be displaying a segment separately Content (please ensur…Eva Mirzoyan 101 views 5 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
U.S 1099 Payment ReportHi, We had requirement to add below columns to U.S 1099 Payment Report. Vendor Type of TIN ( E/S) Vendor Recipient Address 1 Vendor Recipient Address 2 Vendor Recipient …Ismail Sherief 1 view 0 comments 0 points Started by Ismail Sherief Payables, Payments & Cash Management
-
BI table for AR transaction approvalHi Team, Please help to get table that stores AR transaction approval History. I am not able to find any dedicated table like AP Invoices (AP_INV_APRVL_HIST_ALL). Also t…