Fusion Financial reporting
Discussion List
-
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 94 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 1 view 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 536 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 2 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 34 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 32 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 35 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 2 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 32 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 11 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 15 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 36 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 2 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 11 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 2 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 56 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 35 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 66 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 631 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 -
Not able to rename or delete existing folder in BI catalogSummary: Content (please ensure you mask any confidential information): Hello All, Hope you are having a great day. We are facing an issue while renaming a folder in BI …Lucky Sharma 33 views 5 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
OTBI scheduled reports/analyses "From" email changedHas anyone else noticed a change in the "From" email address for scheduled reports/analyses from OTBI? I have rules in my Outlook to filter these to a specific folder an… -
Limit Scheduled Process access to only Custom ESS jobSummary: We have created a custom ess job that runs a BI report. The privilege created along with the custom job has already been added to the custom role and our user a…
-
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 233 views 7 comments 0 points Most recent by Sravan Komminedi Reporting and Analytics for ERP -
Requisition Approval Rule Report that includes all other tasksSummary: The requirement of This report should include: Requisition Approval Rule Report that includes rules for “requisition approvals” task and all other tasks related…