Fusion Financial reporting
Discussion List
-
Retired Assets in previous years should be part of Asset Register ReportSummary: Hello, one of our user raised concern regarding Asset Register Report that "all the assets that were retired last year still appear on the report. They do have … -
Missing Columns in BICC PVO but columns available in the underlying Oracle database tablesSummary: While analyzing the BICC Object Views for sending the data to Traget System—similar to the BIP extracts—for the following three Oracle tables, I noticed that so…Anshul Bansal 33 views 1 comment 0 points Most recent by Sai Revanth Reporting and Analytics for ERP
-
Regarding COA future1 segment name change impact on custom reportsSummary:Is there a specific option to find out what all custom reports are touching the chart of accounts Accounting Flexfield to analyze the impact of chart of account …Savita_1 1 view 1 comment 0 points Most recent by Anca A-Oracle Subledger Accounting & Accounting Hub
-
Trying to add new custom font in BIP getting errorSummary: I am Trying to add new custom font in BIP getting below error. Path : Admisnstartion→Runtime Configuration→Font Mapping When i click on Font mapping then gettin…Basavaraj Navalagi 71 views 6 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS…Sanender SP 41 views 7 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
segregation of dutiesIs there a report for segregation of duties for Finance?
-
Data Security not being applied to OTBIWe have a report created using the Subject Area- Expenses - Expense Transactions Real Time. As per Oracle documentation, this subject area access requires, Expense Trans…
-
difference balances xla_ae_lines and xla_ac_balancesSummary: difference balances xla_ae_lines and xla_ac_balances Content (please ensure you mask any confidential information): We created an OTBI report in the "Subledger …Francesca1 12 views 1 comment 0 points Most recent by Daniel Martin Subledger Accounting & Accounting Hub
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…Rashmi M-Oracle 55.3K views 137 comments 30 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Replace SQL Server Reporting DB with Paas DBWe currently have a daily extract (GL to subledger drill down) that gets loaded into a SQL Server DB and the business interrogate via an Excel SQL Server add in. We are …
-
Does Oracle Fusion Cloud have any standard report/Localization for FTA VAT Audit File, (FAF)Hi Experts, The United Arab Emirates tax authority, Federal Tax Authority (FTA), audits businesses at its discretion to ensure accurate and timely tax declarations. As p…
-
Range Function in Accounting Period is not working when adding another columnHello, I'm creating Trial Balance in FRS, and i need to use the range function in accounting period dimension, However, when I only have one column its working fine but …Mohammad Hussein 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Issue with exporting xls data from several reports for some usersSeveral of our users are facing the issue(see a screenshot below) when they try to extract XLS from several Financial reports (all of them for reports from the EPM works…Ann Djiyanova 11 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform -
ESS job and job sets migration from one instance to anotherSummary: We have around 200+ ESS jobs and each time after refresh, it is a tedious and time consuming task to migrate each of them individually. We have to document each…Pawan Lakhotia 1.9K views 10 comments 3 points Most recent by PadmanabhamP Reporting and Analytics for ERP -
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 229 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 11 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 32 views 2 comments 0 points Most recent by SRIKANTH DEVARASHETTY Reporting and Analytics for ERP