Fusion Financial reporting
Discussion List
-
Redwood roadmap for Oracle FinancialsSummary: We would like to know Redwood implementation roadmap for Oracle Financials. It involves lots of planning and effort sooner we know the roadmap it will help cust… -
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …Mohak Kirtane 140 views 3 comments 1 point Most recent by Matthew - Town of Aurora Reporting and Analytics for ERP
-
How to replace invalid XML character (fffe)Summary: Due to invalid characters in Purchase Requisition header description (mostly likely due to requestor copied and pasted content containing this invalid control c…
-
How to populate JG_ZZ_VAT_REP_STATUS tableSummary: We are working on a Bulgaria rollout. VAT reports are customized and uses JG_ZZ_VAT_REP_STATUS table.We could not find how to populate this table Content (pleas…
-
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle 3.3K views 84 comments 9 points Most recent by Sean Rogers Reporting and Analytics for ERP -
MISC code in OTBISummary: Is it possible to get the MISC code in OTBI? We need to build a report for 1099 since Oracle's 1099 capability is severely limited. Content (please ensure you m… -
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …Robinson Antunez 194 views 10 comments 0 points Most recent by Rosita Santosuosso Reporting and Analytics for ERP
-
Adding Distribution Information to Payables Invoice InquiryYou can extend pages with custom OTBI reports, for example with budgetary control charge account and projects information is useful when viewing invoices. The Embedded I…Anne Wong -Oracle 1.8K views 40 comments 22 points Most recent by Derrell S Reporting and Analytics for ERP -
Can we populate currency based on the ledger currency in FRS Report in Oracle FusionHi, We are currently building a financial report using Financial Reporting Studio (FRS) in Oracle Fusion/ERPCS, and we are exploring options to dynamically populate the …Varalakshmi Guduru 21 views 4 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Financial Reporting Studio Issue: 2026 Data Not Appearing (current Year)Dear Oracle Support, We are encountering an issue in Financial Reporting Studio (FRS) that is affecting the display of 2026 data in our reports. Pervious year data showi…
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI report for ERP Cloud providing a list of AP Invoices on HoldContent Sample OTBI Report for ERP Cloud: AP Invoices on Hold This report provides a list…Andy Gough 2.1K views 19 comments 22 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP -
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo…Andy Gough 4.4K views 30 comments 31 points Most recent by Farooq Syed, CPA, PMP, CISA, TOGAF Reporting and Analytics for ERP
-
Balance Sheet SQL query requirement in BIPHi everyone, I need to build a custom balance sheet report in Oracle Fusion Cloud Financials using BI Publisher**,** and I’m completely stuck at the starting point. I ha…Pravesh Koonjal 4 views 1 comment 0 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP
-
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…User_2025-02-04-10-47-46-258 42 views 3 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
REST API to run FRS reports in FusionSummary: Need to know REST API details if any to run FRS reports in Fusion Content (required): REST API to run FRS reports in Fusion Version (include the version you are…Sudha KOVURU 411 views 6 comments 0 points Most recent by Raunak Kumar Singh Reporting and Analytics for ERP -
Displaying Accounting Period parameter LOV in expandable hierarchical manner when running FRS ReportThe business' FRS report currently has their AccountingPeriod parameter set to only query years, which is causing issues when they're trying to query years with periods …
-
AR Transaction Approval QuerySummary: Hi Team, Please help to get table that stores AR transaction approval History.User_S5U61 15 views 1 comment 0 points Most recent by Vighnesh Khade Reporting and Analytics for ERP
-
Asset Rollforward Report ExamplesSummary: Looking for any fixed asset rollforward report examples or suggestions. Content (please ensure you mask any confidential information): We were hoping to create … -
sql query to fetch item number detailsSummary: We need a SQL query to fetch the item number, business unit, inventory item id, unit cost, total cost, sub inventory code, organization name. Kindly let us know…Dilip.Murugan-Oracle 3.5K views 13 comments 0 points Most recent by JimCC Reporting and Analytics for ERP
-
Drill down on balances in SA General Ledger - Transactional Balances Real Timehttps://us.v-cdn.net/6034893/uploads/YZLQDXKKCO5W/sawreport-xmlnssaw-3dcom-siebel-analy.txt Summary: We have created a an OTBI analysis using SA General Ledger - Transac…ERP & EPM Cloud 1 view 0 comments 0 points Started by ERP & EPM Cloud Reporting and Analytics for ERP
-
Need Support for Missing Notifications in Fusion Expenses: Manager Reject and Audit Complete EmailSummary: Hi, We identified two missing email notifications in Fusion Expenses and need clarification on whether these events are supported as standard functionality: Man…
-
Extract the customer credit limit detailsSummary: We have requiremnet to extract the customer credit limit details. Content (please ensure you mask any confidential information): We need a report or query to ex…Mamdouh Ahmed 22 views 1 comment 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for ERP
-
Grouping sections in a report created in Financial Reporting Web StudioPlease let us know if it's possible to collapse and expand the report information by section. For example, in this report, we need the accounts listed below the COST OF …David Hilario Padilla 1 view 0 comments 0 points Started by David Hilario Padilla Reporting and Analytics for ERP -
Table to get Task Details from Strategy assigned to customerSummary Table to get Task Details from Strategy assigned to customerContent Hello, We are unable to find the table to get Task Details from Strategy assigned to customer…Vinay Gharge 247 views 3 comments 0 points Most recent by Yahya Khan Reporting and Analytics for ERP -
Form Personalization Column HideWe have a form personalization requirement to hide the Distribution combination field if the Invoice type is 'Prepayment' from the AP invoice lines in create Invoice pag…Arkaprabha Pal 1 view 0 comments 0 points Most recent by Arkaprabha Pal Reporting and Analytics for ERP
-
Deeplink for AR_TRANSACTION in REVIEW modeSummary: Need to view a transaction detail in Review mode Content (please ensure you mask any confidential information): Hi everyone, I noticed that when I open a comple…MCAUK 513 views 2 comments 1 point Most recent by Abhilash K - Deloitte USI Receivables & Collections
-
Need report that shows all approval assignees who have NOT approved invoiceSummary We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)Content We a…User_2025-01-28-19-14-07-225 587 views 19 comments 2 points Most recent by cylim Reporting and Analytics for ERP
-
Is there a lag period before OTBI displays new invoices/data?Summary: Hi everyone, I am running the Payable Withholding Tax report from Reports and Analytics. Navigation: Shared Folders/Financials/Payables/Income Tax and Withholdi…
-
GL Analytics dashboard in OTBIHas anyone created a GL analytics dashboard that they are wanting to share? I am trying to create a dashboard that gives our finance department/CFO all the information w…
-
Roles that can create and update, or only view Financial Reporting reports connected to GL EssbaseThis concerns roles that can create and update, or only view Financial Reporting reports connected to GL Essbase. We need to understand two types of roles: one that only…