Fusion Financial reporting
Discussion List
-
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 227 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 334 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 918 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 74 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 60 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 73 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 56 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 50 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 274 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 58 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 696 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 44 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 48 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 234 views 5 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
Best practice for Developing Custom BIP reports and securing them in ERPSummary Looking for best practices for custom BIP reports for ERP which can be secured by Role and Data Access Sets similar to UIContent Hi, Our client has complex enter…Subhash Valiveti 383 views 15 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for ERP -
Transaction Query exampleSummary example of a GL Transaction query flexible to a range of parametersContent Seeking an Oracle Cloud example of a GL transaction query that returns line item detai…User_2025-02-11-03-09-13-126 330 views 6 comments 2 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
OTBI Report that shows the element details field "Description"Summary OTBI Report that shows the element details field "Description"Content I am trying to build a report where I can pull in the field 'Description' on an element. Fo…
-
General Ledger - Balances Real Time Subject Area: not returning Beginning and Ending BalanceSummary General Ledger - Balances Real Time Subject Area: not returning Beginning and Ending BalanceContent I am trying to create an analysis based on General Ledger - B…Dharmendra Shukla 167 views 4 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for ERP