Fusion Financial reporting
Discussion List
-
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 28 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 233 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 14 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 34 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 18 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 13 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 429 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 12 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 33 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 104 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 3 views 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…
-
Are XPath functions fn:tokenize, fn:matches, and fn:replace are not supported by Oraclee?Summary: Hi, I am new to XSLT development, As part for customer requirement I have used tokenize function for looping. But PPR formatting is failing because of this. Err…Tejeswar J E 7 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Report or table details for Chart of account listing values for natural account in General LedgerSummary: Hi Team, I have to create BIP report for COA listing values for Natural Account in General Ledger as per attachment. I am looking for table details or query to …ManishaPatil 25 views 3 comments 0 points Most recent by ManishaPatil Reporting and Analytics for ERP
-
Values exported from Financial Reporting Studio to Excel with the wrong sign!We configured a report on FRS (Financial Reporting Studio), the customer asked us to set the opposite sign on the values present in the system (e.g. in the system the …Michele Ferro-Oracle 11 views 2 comments 0 points Most recent by Rich Merkel General Ledger & Intercompany
-
Sql query or Table name for Classify Organizations under Manage Project Organization ClassificationSummary: Hi Team, We need a table or query to get the flag columns for Classify Organizations under Manage Project Organization Classification Attached the screenshot fo…
-
What is the usage of ROW[#Ref] function in the Financial Reporting StudioSummary: There is a Function called ROW[#Ref] in the formula for FRS. What is the usage of it. Content (please ensure you mask any confidential information): Version (in…SuniChacko 3 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
What are the Best practices when implementing Fusion Cloud HCM Succession Management and TalentSummary: What are the Best practices when implementing Fusion Cloud HCM Succession Management and Talent Please share the What are the Best practices when implementing F…Priya Nathan-Oracle 8 views 0 comments 0 points Started by Priya Nathan-Oracle Performance Management
-
Can we customize Print Receivables Transactions report Bursting query from emai To FTP/SFTP ?Summary: Client requirement is to receive AR transaction PDF to FTP location rather sending it via email so want to customize Print Receivables Transactions Bursting que…RupaliGahalot 254 views 16 comments 0 points Most recent by Ranga Swamy Ediga Reporting and Analytics for ERP