Fusion Financial reporting
Discussion List
-
Duplicate lines in Fixed Asset Depreciation reportI've created a simple analysis that pulls the depreciation details from the application and presents it in an overview. Here is the analysis XML: There's an issue where … -
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 451 views 8 comments 17 points Most recent by Frank Meoli Reporting and Analytics for ERP -
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 42 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 62 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 62 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 33 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
How to add the segments of the Chart of Accounts to the OTBI Subject AreaSummary: Unable to find the 4th and 5th segments of the Chart of Accounts in the General Ledger or Budgetary Control subject areas Content (required): Our COA has 5 segm… -
OTBI Payables Invoices to Subledger joinContent We have a requirement to display Payables Invoices data (Payables Invoices Transactions Real Time) and their corresponding Subledger entries & other Subledger sp…Rajagopalan Rangarajan 98 views 1 comment 3 points Most recent by Gillian Kilbride 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…SaurabhSinghal 42 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Invoices Paid on timeSummary: Hi Business is trying to generate the invoices paid on time report in Fusion Cloud Not able to trace the seeded / standard report for the same. Can you please g…SaurabhSinghal 63 views 5 comments 0 points Most recent by Amrita Gupta-Oracle 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 32 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 52 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 56 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 42 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…SaurabhSinghal 268 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
BPM Workflow Invoice Approval - Standard ReportHi, Scenario: During the workflow of invoice approval, when one of the approver has delegated the authority to someone else in organization Ask: Business would like to k…SaurabhSinghal 65 views 0 comments 0 points Started by SaurabhSinghal Payables, Payments & Cash Management
-
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…
-
Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Summary Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Content Is "EDI Location Code" available for Reporting in Customer Real Time Su…Andrew_Schmitz 54 views 3 comments 2 points Most recent by Bhanu Gundala Reporting and Analytics for ERP -
Sending Reports to a Google DriveSummary: One of our customers is looking to have certain reports from ERP delivered to a Google drive location. Has anyone tried this and if yes how was it done? Any inp…Govind Srinivasan-Oracle 42 views 0 comments 0 points Started by Govind Srinivasan-Oracle Reporting and Analytics for ERP
-
SQL automatically changes to uppercase on user defined LOV query under Manage List Of Values SourcesSummary: SQL automatically changes to uppercase on user defined LOV query under Manage List Of Values Sources Content (required): I have entered below SQL on the Query b…Ajay Hareesh 83 views 6 comments 0 points Most recent by Ajay Hareesh Reporting and Analytics for ERP -
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 53 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…
-
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 394 views 2 comments 3 points Most recent by USER_BI Reporting and Analytics for ERP