Fusion Financial reporting
Discussion List
-
Connecting Workiva Cloud Service with ERP Cloud for SEC ReportingSummary Would like to know if anybody has done this connection and how worksContent Hello, I'm trying to learn from somebody that already experienced how to connect Work…Patricia Gonzalez 56 views 5 comments 0 points Most recent by Sean Rogers Reporting and Analytics for ERP -
Which FUSION tables OTHER than per_email_addresses per_ldap_users hz_parties store user emailSummary: I need to find the table(s) where user email addresses exist in Fusion. I've checked per_email_addresses,per_ldap_users and hz_parties tables but none of them c… -
Assets - The following segment labels have misspelled BI Object Name setSummary: Hi What are correct spelled BI Object Name set for Assets. I have hit the following error: Regards, Bo Content (please ensure you mask any confidential informat…Bo Tøpgaard 91 views 4 comments 0 points Most recent by Santhosh_Krishnan123 Reporting and Analytics for ERP
-
Error While Customizing “Global Subledger Detail Journal Report” – Invalid Table Name IssueSummary We are trying to customize the Oracle seeded report “Global Subledger Detail Journal Report” located in: /shared/Financials/Fusion Accounting Hub. We created a c…
-
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… -
How to find number of days for a month in FRSHow to find number of days for a month in FRSLakshmiVanarasi 22 views 2 comments 0 points Most recent by LakshmiVanarasi General Ledger & Intercompany
-
Issues in Prepayment Handling in Custom AP Aging Report (As-of-Date Logic – Oracle Fusion)Summary: Incorrect remaining amount calculation in custom AP Aging Report due to improper handling of multiple prepayment applications (Invoice-Level and Line-Level), in…Pranat Damani 2 views 0 comments 0 points Most recent by Pranat Damani Reporting and Analytics for ERP
-
Merging 12 Business Units into 6 new Business Units. What is the correct setups and proceduresSummary: We have 12 business units that need to be merged into 6 new business units. We are currently utilising AR,AP, GL, CM, EPM and need to understand what is the pro…Chris Pandaram 2 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Is it possible to edit and add column in Manage Invoice report on Fusion screen?Summary: Is it possible to edit and add column in Manage Invoice report on Fusion screen? User want to add one column in the output report from Manage Invoice. Content (…
-
bi query to extract journal approval rules, Invoice Apprvoal Rules and Project Approval RulesSummary: Hi All, I am looking for the tables or query to extract the journal approval rules, Invoice Approval Rules and Project Approval Rules from Oracle ERP Cloud thro…Chandra MAdasi 33 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
FRS Reports erroring out intermittentlySummary: FRS Reports erroring out intermittently Content (please ensure you mask any confidential information):These are the errors received trying to run the Fin report…Mohammed Boucanna 61 views 2 comments 0 points Most recent by Jennifer Landman Reporting and Analytics for ERP -
Income Statement and Balance Sheet reportsSummary Are there a Balance Sheet and/or Income Statement reports available in ERP Cloud?Content I'm surprised there isn't an out of the box version for an Income Statem…User_2025-01-25-00-55-11-011 359 views 8 comments 2 points Most recent by User_RCQ6I 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…
-
Hide column/s of an FRS ReportSummary: When FRS Report parameters are entered and report is run, I need column/s which give all blank values to be hidden. How can this be done? Content (please ensure…
-
Any Roadmap for Oracle Cloud Financial Redwood?Summary: Hi All, Is there any road map for redwood implementation for Oracle Cloud Financial, what all new features will be added and what will be time line. If any one …Tauseef_Akram909 41 views 1 comment 4 points Most recent by Dawn Cawston - CPS Reporting and Analytics for ERP
-
ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabledSummary: Hi Team, I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the whe…Shashidhar Goud 499 views 3 comments 0 points Most recent by User_B5NVV Reporting and Analytics for ERP
-
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 62.6K views 147 comments 33 points Most recent by YevgenyM Reporting and Analytics for ERP
-
Query for Transaction Console transactionsSummary: Query for Transaction Console transactions Content (required): I am looking to write a query that contains the below information from the Transaction Console, r…
-
Need help with Cost Accounting Distributions CodeSummary: Hy Experts. I am developing a Purchase Register Report where I have to fetch a column named Inventory Charge Account in which this value of Inventory Valuation …
-
Financial reporting studio books doesn't have an option to download in excelSummary: Any work around to this? Currently it allows only pdf and html. Users would like to download the whole book as an excel Content (please ensure you mask any conf…SuniChacko 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
SmartView Duplicate name Error from sharded driveSummary: Smartview Spreadsheets are kept in a shared drive (OneDrive). After a hierarchy change (A single value added or moved)we continually see errors like : Essbase E…Service Desk Claremont 32 views 2 comments 0 points Most recent by User_TKC45 Reporting and Analytics for ERP
-
FRC synch timeSummary FR Studio Reports don't appear in FRC immediatelyContent When we create new Financial Reports using FRS, they do not appear in FRC right away. It seems there is …
-
Tables that store the errors in FAH when the import Accounting transaction process failsSummary: What are the tables that store the errors in Accounting Hub when the import Accounting transaction process fails ? Version (include the version you are using, i…
-
How to get the last period of previous fiscal Period in FRSSummary: We create " Income Statement" . The report having Two Columns , Column A represent "Accounting Period Selected in prompt" i.e Sep-2025 Column B for Previous yea…Rama Mohan ReddyB 21 views 1 comment 0 points Most recent by Rama Mohan ReddyB General Ledger & Intercompany
-
Is there a way to identfy open subledger transactions in the general ledger?Summary: We have a custom report requirement to extract account balances for specific accounts for open transactions only. These are either receivables or payables that …len.baetiong-Oracle 2 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
While creating FRS Report, I cannot find "Budget" choice when open Scenario DimensionHi All, Please we are creating a Financials Reporting Studio Report to compare between Actual Vs Budget. I have added "Scenario" as a column in the report, and when I ha…Ali Husseini 32 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Financial Reporting Studio Report displaying Error when no data is foundSummary: Financial Reporting Studio Reports fetching #Error when no data is found. We don't want want to suppress the column or row, rather want to display the value as …
-
Why the printing from the fusion is different from a laptop to another ?!Summary: I've tried to print a report from the fusion (its layout is made by the word in a RTF format) and it's been printed correctly on my laptop but the other laptops…
-
Unable to find PVOs in BICCContent Hello, We need PVOs of following tables in BICC but we couldn't find these in Lineage Sheet. If anyone has any idea on how to get those or any workaround would r…Vinay Gharge 158 views 8 comments 2 points Most recent by User_0GZ7K Reporting and Analytics for ERP -
Apply customer hierarchy to receivables subject areasSummary We are trying to build reports from the Receivables subject areas that can rollup values based on the CDM Customer HierarchyContent We have established hierarchi…User_2025-01-28-18-21-52-276 52 views 2 comments 0 points Most recent by Anjula Mittal Reporting and Analytics for ERP