Fusion Financial reporting
Discussion List
-
Are there a Financial statements reclassified according to the 4th CEE Directive available in ERP?Summary: Are there a Financial statements reclassified according to the 4th CEE Directive available in ERP? Content (required): Dear All, I would need to know if a Finan… -
How to filter by Invoice ID that has had the invoice approval state 'Automatic Rejected'.I want to filter a dashboard to show all invoices that still require action to be taken, that were automatically rejected by the system. I want to see all rows of "Payab… -
Error in Financial reporting centerHello, I am trying to upload my balance sheets and income statements in financial reporting center, when I navigate, I can't find the different ledgers to select. In add…Victor Chrabieh 41 views 2 comments 3 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
What is FRS formula to populate Sep of last year dynamicallyQuestion We have Balance Sheet in FRWS where user selects specific period (Monthly GL calendar) thru prompt e.g. Jun-22. GL calendar is from Oct to Sep. User always want…CA Nirmal Choudhary 153 views 2 comments 0 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP -
Account Analysis report returns no data - 2nd year in a row this report has become broken in March.Summary: In march, this report starts returning no data. Runs fine in Jan & Feb. Last year, the SR reported back that the data model had been updated for performance rea…Miriam Rowan 61 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Is there a foreign exchange gains and losses report available?Summary: As a global company, with entities using +50 currencies, we'd like to see a report to understand what is generating the foreign exchange gains and losses at the…Felicidat 52 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Invoice Payment Report with Journal InformationSummary: Invoice Payment Report with Journal Information Content (required): We are looking for a report that contains invoice details (number, amount, date, etc.), the … -
OTBI Access and SQL Query ViewHi For OTBI Report Creation - the access is incomplete. Please observe the Create --> Published Reporting and Actionable Intelligence - only two options What all are the…SaurabhSinghal26 41 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
OAC Essbase Add-In for Google SheetSummary: Are we able to use smart view in Google sheet? We have heard about OAC Essbase Add-in, Will it replace Smart View for Google sheet? Also, while adding the plug-…Nikhil Bidwaikar 31 views 0 comments 0 points Started by Nikhil Bidwaikar Reporting and Analytics for ERP
-
How to get the GL Segments Flex value set IDs for seeded and custom segments from EBS R12 DBSummary: EBS R12 SQL or base tables to fetch GL Segments Flex value set IDs for seeded and custom segments. Content (required): There is a need to fetch GL Segments Flex…Manu R-Oracle 222 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
General Ledger - Balance Real Time measures are nullSummary when using General Ledger - Balance Real Time OTBI subject area all the measures come back nullContent I have users that are trying to create new OTBI reports fr…amy hardtke 85 views 3 comments 1 point Most recent by Adrian Townsend Reporting and Analytics for ERP -
Customise standard report - new layoutSummary: Standard report which only runs inside Fusion ERP. How to use sample data xml export in Fusion BI Publisher? Content (required): So I have a standard report whi…Robert of STAU 53 views 4 comments 0 points Most recent by Robert of STAU Reporting and Analytics for ERP
-
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 …
-
Invoice Approval Workflow - Pending with which approverHi, Business Scenario: In AP Invoice Approval Workflow - if an invoice shall be going through five approvers in all during BPM Workflow Business would like to generate t…SaurabhSinghal26 702 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Report definition not found:/Custom/Financials/Payables/Invoices/****.xdoSummary: I keep getting the Report definition not found:/Custom/Financials/Payables/Invoices/****.xdo error Content (required): I keep getting the Report definition not …
-
DFF are not visible in Payables Payments - Disbursements Real TimeSummary: Hi All, We have created global DFF on AP_CHECKS (table) and made it BI enabled, but it's not visible in "Payables Payments - Disbursements Real Time" subject ar…
-
Calculated measure questionSummary: Building multiple columns based on aging Content (required): I have defined a report that gives me the amount due on an invoice and it's related aging value. I …
-
Calculated Measures issueSummary: Calculated Measures when null value exists Content (required): I have two measure. The one being invoice amount and the other being invoice paid amount. For bot…
-
AR Transaction status in OTBII am creating a (crude) AR Aging report for a specific transaction type in OTBI, to include in in a dashboard. All columns I need are included in the subject area "Recei…MaartenDIF 191 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
OTBI QuestionsSummary: Content (required): In "Payables Invoices - Transactional Real Time" subject area, why do we have so many invoice currency fields and why some of them are givin…Vinay Gharge 51 views 1 comment 0 points Most recent by Daniel14337-Oracle Reporting and Analytics for ERP
-
Oracle Fusion Cloud - SQL script logic to calculate Period to Date (PTD), Quarter to Date (QTD) andSummary We are working on Custom Trial Balance Report development and need logic to calculate PTD, QTD and YTD Balances into Oracle Fusion Cloud.Content Hi Team, We are …Mahadev Salunkhe 815 views 2 comments 3 points Most recent by USER_BI Reporting and Analytics for ERP
-
How to add customer number field in Manage and create receipt screen?Summary: How to add a customer number field in Manage and create receipt screen? Content (required): How to add a customer number field in Manage and create receipt scre…Venkatesan 91 views 5 comments 0 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP
-
Unable to suppress columns in Smart View retrieveSummary: Apologies if this is the wrong forum on which to ask this - I have created a Smart View retrieve to extract data from ERP, however in Smart View -> Options -> D…Danny Emmerton 191 views 3 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Is it possible to group pages members to create a new structure in Financial Reporting StudioSummary: Within Financial Reporting studio , I would like to create a balance sheet for different cost centres , but have a collection of cost centre grouped for each pa…Estar45 21 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Grouping Columns into oneSummary: Is it possible to group different members into one column in financial reporting studio Content (required):Financial reporting studio Version (include the versi…Estar45 32 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Report on Report Usage in FRSSummary: I am trying to gather information on which users run which reports in FRS. I have created an OTBI Usage report but that report does not include reports in the F…Jarrett 41 views 1 comment 0 points Most recent by Daniel14337-Oracle Reporting and Analytics for ERP
-
Period name taken as a parameter tag display in a wrong format in excel outputSummary: Content (required): Hello Everyone, I recently created a BIP report using excel with the "xls" format and using the xml exported, I ,created the report in an ex…Sushan Peiris 141 views 3 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Calculate difference between previous and current amountSummary: How to add a column for calculating the difference between yesterdays closing amount and todays opening amount Content (required): We have built a simple OTBI r…Stefan pettersson 41 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
FRS 13 Month Rolling Reports Error Executing Query since 22C UpgradeSummary: Content (required): Hello: Is anyone having issues running FRS rolling reports since the 22C Upgrade? Our other reports are running fine, but we are getting an …
-
FRS Heading not Centering in Excel exportSummary: Content (required): I have an FRS report that has about 13 columns. The header is centered across the report with the ability to autosize. Looks great online bu…User_2025-10-31-01-06-05-525 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP