Fusion Financial reporting
Discussion List
-
Rows repeating with different values though it's not available in the Front end under Customer SiteSummary: Hi, We have developed an OTBI report using Receivables - Customer Real Time and Receivables - Customer Account Site Tax Profile Real Time and it is repeating a …Rahul Kumar Gupta.-Oracle 25 views 2 comments 1 point Most recent by Daniel S.-Oracle Receivables & Collections -
General Ledger Balances Real Time OTBI not fetching Cost center values from COASummary: I am using General Ledger Balances Real Time Subject Area to extract all COA value set values and i am able to derive all COA values except for Cost center, Onc…TCG 14 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
how to enable incremental value schedule standard report in oracle fusionSummary: how to enable incremental value option while scheduling standard report Report : Payable trial Balance reportMohammed Masoodhu Hashir 25 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Period Name parameterSummary: Hi , I am currently working on report which is filters using period_name. when i select single month(period_name), the data looks promising. when multiple perio…Praveen_Chouhan 125 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Deeplink for AR_TRANSACTION in REVIEW modeSummary: Need to view a transaction detail in Review mode Content (please ensure you mask any confidential information): Hi everyone, I noticed that when I open a comple…
-
Dunning Letter Format in Peppel 3.0 FormatHi, We have new requirement for our client need to send Dunning Letters in Peppel 3.0 Format. Can you please let us know do we have Oracle standard functionality dunning…Koteshwar Tippani 101 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections -
Is there any report to fetch either approved or approved invoices but not bothSummary: I need to know whether report or from front end to fetch the details of invoice status whether approved or not without giving AP inquiry role to all the clients…Sri Pallavi 5 views 1 comment 1 point Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
How can I find AP invoices Approvals by user and approval group details in Fusion cloud?Summary: To identify the Invoice is approved user or approval group and which Rules hitting by the BPM Content (please ensure you mask any confidential information): To …Harish Pati 553 views 2 comments 0 points Most recent by Harshali Shirgannavar-Support-Oracle Payables, Payments & Cash Management
-
BIP Local Solutions reports do not print Natural Account descriptions in selected local languageSummary: Predefined Latin America Local Cloud Solution (LALCS) BIP reports do not print Natural Account Descriptions in translated language - Spanish. Content (please en…NancyR_Bravo 7 views 2 comments 0 points Most recent by NancyR_Bravo Reporting and Analytics for ERP -
Migration of FRS reports from one server to anotherSummary: Hello, I want to migrate my FRS reports from test to production server. After archieve and unarchieve, I changed my database connection as well but it didn't wo…Ayub 53 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
AR_STATEMENT_HEADERS and AR_STATEMENT_LINE_CLUSTERS are interiam tablesSummary: AR_STATEMENT_HEADERS and AR_STATEMENT_LINE_CLUSTERS are interiam tables. Content (please ensure you mask any confidential information): We are looking actual ba…
-
Issue Number formating causing reporting issuesDear All, The format of numbers in the purchase order standard report are not displayed correctly, because the NLS_NUMERIC_CHARACTERS setting is not configured at the da…George Mattar 36 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Audit Report for Oracle backup Log in Oracle fusionSummary: Hello, We are looking for report where the Oracle system backs up all data, libraries, applications, and user profiles daily/on a regular basis. Is there any re…
-
How to delete chart of accountsSummary: How to delete chart of accounts Content (please ensure you mask any confidential information): Hi All, How to delete chart of accounts which is defined wrongly?…Venkatesan 37 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Printing multiple report prompts in FRS report out of ERPSummary: We have an FRS report where the report prompts for company and the user can choose multiple companies. The report output is the total of all of the chosen compa…K McMillan 6 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Additional levels listed in OTBI for GL segments in GL Subject AreasSummary: We have levels listed for all of our GL segments in OTBI. We would like to know where these come from and if there is a way to remove them from OTBI if possible…Kristina P - National Heritage Academies 36 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Member Selection on FRS ReportWe have business requirement to rename tree version via Manage Account Hierarchies. We able to make the changes but we encountered some unexpected changes in our FRS Rep…Aaron Leus 15 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Export a FRS report book to excel where each report exports to separate tabSummary: I have seen the question posted but am not able to find an update after 2019. Is there yet a way to export a book with 15-20 reports in it to excel with each bo…K McMillan 14 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How can we see who/if someone has created a database connection in FRS?Summary: We have noticed an extraneous database connection in FRS that is not one of the ones we have created ourselves in our production environment. Is there a way to …
-
Reconciliation Report using Supporting Reference segmentsWe have a reporting requirement to track a transaction (together with natural account) from GL to subledgers. A DFF is created at Journal header level to capture 'Transa…Kalyani-Oracle 34 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How to create a new KPISummary: How to create a new KPI Content (please ensure you mask any confidential information): Hi Team, How to create a new KPI reports for Finance? Could anyone guide …Venkatesan 6 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to add category parameter to account analysis reportSummary: We need to add category parameter to customized account analysis report and it runs into error "'P_CATEGORY' must be declared ORA-06550: line 2, column 1: PL/SQ…Akshitha Vyas 23 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Unsupported use of WITH clauseSummary: My custom report is producing the error of Unsupported use of WITH clause Content (please ensure you mask any confidential information): I have developed a repo…Chez 7 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
The search is not working in the drop down menu in Data set BU publisher reportI have this parameter that is related to a list of value that give all the contract number. the query i am using for the list of value is: select DISTINCT TV.CONTRACT_NU…Omran Zeaiter 65 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
can we fetch report for how many times a report runHi Everyone, we have a requirement to fetch the all custom reports in the fusion, along with their information of how many times that report run in 2024 and what is the … -
Parameter values to pass to save update Data model of Subledger Period Close Exception ReportSummary: Customer is looking for Customized Subledger Period Close Exception Report to add Supporting Reference columns. Thus looking for an input to know which valid va…
-
What is the impact of General Ledger Segment Security on OTBI reportsOracle document 2486655.1 refers to a document which state in Page 26 he operator "Is last descendant of" is not currently supported for Segment Security Conditions in O…ramesh.sivapalan 42 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How to export 500K rows from OTBI report into ExcelSummary: We have a report where total data is coming close to 500K and we are only able to export 25K in Excel, is there is any way to do this? If I develop this in BI P…Sam Samaddar 69 views 4 comments 0 points Most recent by Sam Samaddar Reporting and Analytics for ERP
-
Execute SQL Query against Cloud ERP/HCM without using DataModel/BI ReportSummary: Hello, Usually Oracle Fusion BI Report/Data model was used to create SQL(like "select * from poz_suppliers_int") against Fusion DB ( like ApplicationDB_FSCM,App…Vetrivel J 650 views 10 comments 0 points Most recent by Shyam Patel Reporting and Analytics for ERP
-
How to print a barcode in BIP report?Summary How to print a barcode in BIP report?Content How to print a barcode in BIP report? Version 19D