Fusion Financial reporting
Discussion List
-
Is there any table available where we can get status of email sent via burstingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Aditi Agrawal2650 38 views 5 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Custom BIP report for Accounts payable trial balanceSummary: I am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to p…
-
Smartview:How to enforce data access control in Smartview based on rolesSummary: In Smartview, how do we restrict data access by Ledgers configured in Data Access set? Ex: If a user has access to only Ledger A controlled via Data Access Set,…Rakesh Viswambharan 3 views 2 comments 0 points Most recent by Rakesh Viswambharan General Ledger & Intercompany
-
Storing Oracle Fusion report outputs in document management systemSummary: We have a requirement for storing the output of various kinds of daily/weekly/monthly reports (BIP/OTBI/FRS) generated from Fusion ERP Cloud for audit purposes …
-
Mapping Tables Not giving us accurate dataSummary: Mapping Tables Not giving us accurate data Content (please ensure you mask any confidential information): We are replacing our old system of EBS with ADW. When …
-
Ledger not visiable in FRSSummary Ledger not visiable in FRSContent Hi, We have 15 ledgers,out 15 only 3 ledgers are available in Financial reporting studio.We are web reporting studio. We have C…
-
HSBC Pain.001.001.03Summary: We are implementing payments in Fusion cloud with HSBC as our bank. Bank has specific requirement to have the oracle payment file in 'pain.001.001.02' or 'pain.…
-
Custom report Layout/Template not showing for a user for Accrual Reconciliation ReportSummary: Custom report Layout/Template not showing for a user for Accrual Reconciliation Report Content (please ensure you mask any confidential information): We previou…
-
How to use job schedule as a parameter in an SQL report?Summary: I need a method to get recurrence rules from a job to use it in an SQL report. So if I change the job, related SQL should have the same effect. Content (please …
-
FRS- Need to display the output in excel in different tabs for different branch valuesSummary: There is a requirement for an FRS report (Income Statement with Budget). Currently, when a user selects a specific branch (e.g., Deloitte Delhi) in the paramete…
-
Adding Distribution Information to Payables Invoice InquiryYou can extend pages with custom OTBI reports, for example with budgetary control charge account and projects information is useful when viewing invoices. The Embedded I…Anne Wong -Oracle 1.5K views 37 comments 21 points Most recent by Srinivas Chilakamarri Reporting and Analytics for ERP -
We need some assistance to create a report from the budgeting systemSummary: There is a requirement to create a report from the budgeting system with the fields 1.Budget year 2.IT Budget allocated by Business Unit 3.IT Budget - Actual vs…
-
Standard Reports that include transaction number and Receipt NumberI would like to know If there are Standard Reports that meet the following requirements. 1)include transaction number and Receipt Number. 2)I need to confirm the clearin…
-
FRS branch wise bifurcation for calculated fields like gross profit and percentageSummary: I am taking branch in rows. I need to display the gross profit data branch wise and percentage should also be calculated branch wise. Content (please ensure you…Tanya Matani 21 views 3 comments 0 points Most recent by Tanya Matani Reporting and Analytics for ERP
-
Query/tables to find payment approved by final approver approved PPRSummary: Query/tables to find payment approved by final approver approved PPR Content (please ensure you mask any confidential information): Hi All, We got a requirement…Venkatesan 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Tax Audit Trail Report export to excel doesn't have transaction num but html and pdf does have it.Summary: Export to excel different than html and pdf export. Anyone else have that issue? Content (please ensure you mask any confidential information): Version (include…
-
how to show alternate account GL combination in BIP report?Summary: User requirement to show alternate account GL combination but cannot find correct field. Content (please ensure you mask any confidential information): When vie…CarolineH 13 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
OTBI - Join/Union Subject Area Payables Transactions Real Time to Payables Installments Real TimeSummary: Content (please ensure you mask any confidential information): We need to pull Due Date from Subject Area Installments Real Time against columns Invoice Number …Rory Mullin 110 views 5 comments 0 points Most recent by Alek Strader Payables, Payments & Cash Management
-
We need to display the Tax Rate value of the Purchase Order line in OTBI.Summary: We need to display the Tax Rate value of the Purchase Order line in OTBI. So, we need to find out the subject area that we can create OTBI and display the value…
-
SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMSSummary: Hi TTeam, Could you please help us on this below SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMS in Specify Cash Positioning and Forecasting …Opkey PA 11 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for ERP
-
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…Amarnath 2.3K views 9 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
VAT Functionality for Expense reportingSummary: VAT functionality in Oracle Expenses, focusing on international purchases. International staff should be able to split VAT from the total product/service purcha…
-
Procure-to-Pay RT subject area - approver nameSummary Procure-to-Pay RT subject area - approver nameContent I am attempting to update my existing P-to-P reports to leverage the P-to-P RT subject area; this subject a… -
SQL query to create list of values for past 24 monthsSummary: I've been searching and attempting to create a List of Values to be used in a Data Model for a report to make the parameter selection dynamic year over year ins… -
how to convert Amount to WordsSummary: in EBS we Used Pacjage AP_AMOUNT_UTILITIES_PKG to convert Amount numbers into Word We see the same package in fusion but We do not understand how to use it - SQ…
-
ReportService API appears to be deprecated or marked as obsolete in the April 25B update.Summary: As part of the April 25B Patch activity, we noticed that the ReportService API (/xmlpserver/services/v2/ReportService?wsdl) deprecated or obsolete?. Could you p…Chaitanya2324 81 views 2 comments 1 point Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
Will the transition of FRS reports to Oracle Reports in June '25 impact ERP reports too?Since Web Reporting Studio and FR reports are going to be deprecated, will it impact existing ERP reports in FRC. Users are currently running GL Financial Reports from t…
-
Could you please help with fusion table details or query to get Supplier Email Address.Summary: Looking for list of all Oracle Suppliers email addresses held in Oracle fusion. Thanks. Content (please ensure you mask any confidential information): Looking f…ManishaPatil 156 views 2 comments 0 points Most recent by Kinjal Patel-Oracle Reporting and Analytics for ERP
-
FRS scheduler how to pass current month or Date to PromptSummary FRS scheduler how to pass current month or Date to PromptContent We are scheduling FRS reports. When we create batch it requests to enter the prompt values. Thes…saravana maneeian subhramaniun 125 views 6 comments 1 point Most recent by GiuliaC-Oracle Reporting and Analytics for ERP
-
UCM Bursting not working for Fixed Assets Seeded ReportSummary: Issue in UCM Bursting for Seeded FA report Content (required): Hi, We are trying to create bursting for seeded FA What-If Depreciation Analysis Report to push o…Vaigu_27 54 views 1 comment 1 point Most recent by Dinesh Krishna Mamilla Reporting and Analytics for ERP