Get Started with Redwood: Oracle Cloud SCM and Purchasing
Fusion Financial reporting
Discussion List
-
Frequently Changing HierarchiesSummary How to perform GAAP reporting on Legal Entity Rollups in ERP CloudContent All we have a use case, which I don't think is that unique, yet I am struggling with ho… -
Updating KFF tree versions causes OTBI Analyses to fail when created in “General Ledger – Balances RSummary We are testing changes to the KFF segment values and hierarchies (aka trees). All seems fine with all changes, and GL OTBI reporting until ‘something’ happens an… -
What are the Correct Parameters for OTBI Fusion GL for ESS "Import Oracle Fusion Data Extensions forSummary This ESS request is the very last process in updating KFF OTBI Trees (so we can use OTBI "GL - Balances Real Time"). "All" or (just) "ERP" doesn't work, but "ERP…
-
How to Add the OTBI Dashboard to the Financial Reporting Center?Summary How to Add the OTBI Dashboard to the Financial Reporting Center?Content How to Add the OTBI Dashboard to the Financial Reporting Center? OR If i can make it more…User_2025-02-11-09-27-02-564 199 views 6 comments 2 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
How do we distinguish between custom reports and standard reports?Summary We want to know how many custom reports are created in reporting center. How do we distinguish between custom reports and standard reports?Version Oracle Fusion …Patrick Chrabieh 225 views 2 comments 7 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
How To Handle "&" (ampersand) symbol extracted from data using Etext templateContent We have "&" symbol used in Supplier names. Ex: ABC & Co. Oracle seeded report would generate xml data with as below: ABC & Co We are using eText template to disp…User_8AN9P 320 views 4 comments 1 point Most recent by Divya Sidhaiyan Reporting and Analytics for ERP -
Query to fetch sum of debit memos and credit memos for an original invoiceSummary Am looking for a query to get sum of credit memos linked to original invoice ie Original invoice -HCS1 Credit memo-HCS2 as shown in below screenshots.Content I w…Sankeerthana Anumasula-Oracle 913 views 2 comments 1 point Most recent by Sankeerthana Anumasula-Oracle Reporting and Analytics for ERP
-
Access to Fusion Accounting Hub Reporting Cloud Service ( FAHRCS).Content Hi all, Please clarify whether the "General Accountant" role has access to Fusion Accounting Hub Reporting Cloud Service ( FAHRCS). Best Regards, VipushaVipusha Chandrakumaran 75 views 1 comment 1 point Most recent by Anca A-Oracle Reporting and Analytics for ERP
-
Account Segment Group ObjectsContent Our team is looking to group together certain accounting segments for use in some of their reporting and imports. They currently have specific payroll object gro… -
Configuring Key Flexfield Segments in Oracle Financials Cloud to leverage OTBI for ad-hoc analysesSummary Configuration Steps to enable OTBI reporting of Key Flexfields (KFF's) in GL, Budgetary Control and Fixed Assets (Rel 11)Content To report on Key Flexfield Segme…Anand DN-Oracle 1.7K views 8 comments 12 points Most recent by Chris Lynch - AST Reporting and Analytics for ERP
-
Budget balances not available in General Ledger subject areasSummary Can we query budget balances in General Ledger subject areas?Content Budget balances not available in General Ledger subject areas like 'General Ledger - Balance… -
Fixed Asset Report- OTBISummary Fixed Asset Report- OTBIContent I created a Fixed Asset OTBI report. The report is working well only recently it starts dropping data. its only reflecting 25000 …
-
Missing account coding data for Invoices in Workflow tables in PRODContent Hello, We have a custom BI report that tracks the Account coding details for AP Invoices. We are using the workflow tables to get these details. Per my understan…Shruthi Ramesh 61 views 3 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP -
OTBI Analysis: Using TIMESTAMPADD to derive last day of the month based on Period Name in Subject ArContent Hello There, I have an OTBI analysis for Subject Area: "General Ledger - Balances Real Time". The analysis has a column "Time"."Accounting Period Name" OR "Time"…
-
Generate Financial Reports and Account GroupsContent I found the Scheduled Process Generate Financial Reports and Account Groups that is supposed to generate the following reports: * Consolidated Income Statement *…User_2025-02-08-10-09-37-068 149 views 6 comments 2 points Most recent by Anca A-Oracle Reporting and Analytics for ERP
-
OCI – ERP Analytics: What's New And What's Next On The ERP Analytics Roadmap, 27 April 2021, 9 a.m.Content Submit your questions for the OCI – ERP Analytics: What's New And What's Next On The ERP Analytics Roadmap session to have them answered during the live event. P…mauricio -Oracle 31 views 0 comments 2 points Most recent by mauricio -Oracle Reporting and Analytics for ERP -
Unsuccessful Login Audit Report & Sign-on Responsibilities Audit ReportSummary Oracle Fusion does have a seeded report/ Bi-report for audit purposes.Content Hi All, We would like to know if there is a fusion seeded report that can give belo…User_2025-02-07-22-21-23-100 79 views 2 comments 2 points Most recent by SimonTomey Reporting and Analytics for ERP
-
OTBI custom folder security in production VS test environmentsSummary How are you managing your OTBI custom folder security from Production to Test when different?Content I our current environment we have several self service users… -
Inventory Reconciliation ReportSummary Inventory Reconciliation to GL ReportContent Hello All - I have a requirement to create a sub-ledger report that shows inventory subledger detail and its reconci…Hari Thyagaraj 58 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
find field name behind oracle formSummary find the 'activity class' field in the the AR tablesContent Hello all, Can you please help me with something? I am trying to find out the table behind the Transa…User_2025-02-04-08-34-10-102 52 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
Accessing External DataSource via Fusion BIP reportsSummary We have a requirement to build a report the data of which will be in oracle cloud as well as in external database.Content Hi Guru's We have a requirement to buil…_IshanAgarwal 277 views 5 comments 0 points Most recent by Pradeep Rananaware-216731 Reporting and Analytics for ERP
-
Safest/default Path to Publishing changes to GL (Essbase) Trees: Publish Chart of Account DimensionSummary We have been experiencing issues in making changes to GL tree structures in OTBI, so I wanted to be clear on what the options are for each step, to eliminate the…
-
Subject Area for Supplier CountrySummary I want to be able to bring the suppliers country into a report but can't find the right subject areaContent Hello, I have created an analysis in OTBI and I want …User_2025-02-04-19-45-49-438 21 views 2 comments 1 point Most recent by User_2025-02-04-19-45-49-438 Reporting and Analytics for ERP
-
OTBI data modelSummary Is there a place where we can understand the data model (tables) for OTBI reports?Content Is there a place where we can understand the data model (Tables) for OT…Jeff Hare CPA CISA CIA 99 views 5 comments 3 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
FRS Reports - Suppression of Formula RowSummary In FRS Report tool, if I insert a Formula Row (multiple), is there a way to suppress this row if it is 0.00?Content I recently created an FRS report using the FR…JohnR2 59 views 6 comments 3 points Most recent by Cezar - Fusion Oracle Support-Oracle Reporting and Analytics for ERP
-
Unable to preview BI Publisher output in RTF:Summary Unable to preview BI Publisher output in RTF:Content Hi Guru, I am facing one strange issue in BIP Desktop , i am able to load and design the RTF but when i am t…Rohit Soni-259808 665 views 6 comments 3 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Is there a way for the values in the page prompt to be displayed as the tab name on excel when its dSummary Need to have the tab label name in Excel output with the value on the prompt for FRS ReportContent Is there a way for the values in the page prompt to be display…
-
Projected Cash Balances with Selected Installment Report KitContent The Projected Cash Balances with Selected Installments sample report provides Public Sector Entities visibility into their Projected Cash Balances once a Payment…Anne Wong -Oracle 46 views 2 comments 5 points Most recent by Sahil Makhiza Reporting and Analytics for ERP -
Financial Reporting Studio Desktop - DecommissionSummary Transition from Desktop to Web toolContent Hi, We are using Financial Reporting Studio Desktop tool since 5 years ago for development of ERP Financial Reports, a…Patricia Gonzalez 51 views 9 comments 4 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Extract Cost Center from "Code Combination Description" field - (Procurement - Spend Real Time) subjSummary Extract Cost Center from "Code Combination Descpription" fieldContent I am using "Code Combination Description" field as one of my select columns from (Procureme…UjasB 233 views 5 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP