Fusion Financial reporting
Discussion List
-
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 -
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 191 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 123 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 51 views 1 comment 1 point Most recent by Dinesh Krishna Mamilla Reporting and Analytics for ERP -
FRS reporting - multiple cubes and concatenated segmentsSummary: Hi Team, We are trying to prepare balance sheet in FRS but have below questions. Can we use multiple Essbase cubes in the same report (as an example, can we pul…Nikhil B. Mukhekar 43 views 1 comment 0 points Most recent by Nikhil B. Mukhekar Reporting and Analytics for ERP -
I have to create a actual vs budget amount report for revenue and expense accounts in OTBI.Summary: I have to create a actual vs budget amount report for revenue and expense accounts in OTBI. I have used GL balances real time subject area. The columns selected… -
To connect Oracle Fusion database table with Oracle APEX to create oracle APEX ReportSummary: How to connect Oracle Fusion database table with Oracle APEX to create oracle APEX Report -
OTBI reportOTBI reportVineet Srivastava Graviton 21 views 1 comment 0 points Most recent by Erick.B Reporting and Analytics for ERP -
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie… -
Using rest api in fusion BI publisher data modelSummary: Is there any way to use rest api fusion BI publisher data model, I need to consume external data source and create a report in oracle fusion Content (required):…ShivaShiva 1.5K views 6 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Asset cost and reserve detail ReportSummary: I am currently working on a custom report where I need to include asset cost, reserve details, and a summary report. However, I am unsure about how to obtain th…Regina_P-Oracle 112 views 2 comments 0 points Most recent by arpit_paliwal Reporting and Analytics for ERP -
BIP Joining GL with PJF_PROJECTS_ALL_BI'm trying to join PJF_PROJECTS_ALL_B with this query so that I can add segment1 from the table to this GL report. Does anyone have any insight for easiest way to achiev… -
Required a field name and Table name for Manage Payment MethodsSummary: Hi Team, We need backend tables and a column for the field "Automatically assign payment method to all payees" under Usage rule → Manage Payment Methods. I coul…Opkey PA 31 views 1 comment 0 points Most recent by Krishna Pulicherla-Oracle Payables, Payments & Cash Management -
Procurement OTBI DashboardsSummary ERP Procurement OTBI Reports and Dashboards uploaded for the CommunityContent Sharing a procurement to pay dashboard with multiple tabs containing example report…Alan-Oracle 949 views 14 comments 16 points Most recent by Mohamed Attia-Allah Reporting and Analytics for ERP -
Percentage formula doesn't work for expandable columns.In the "Financial Reporting Center" section by opening the "Workspace for Financial Reports" several reports have been configured. I have an issue... In column A (as an …Michele Ferro-Oracle 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
How to restrict User From Submitting Create Accounting for a Certain SubledgerSummary: How to restrict User From Submitting Create Accounting for a Certain Subledger Content (please ensure you mask any confidential information): Hi All, We have a … -
Table to get the field of Condiion under Manage Chart of Accounts MappingsSummary: We need a table and column where the Condition field information stored for the setup "Manage Chart of Accounts Mappings". Attached the screenshot with highlite… -
Table or Query for Condition column for Separate Remittance Advice in Manage Payment Process ProfileSummary: Hi Team, We need a table or query to get Condition fied under the Separate Remittance Advice in the setup Manage Payment Process Profile. We gone through these …Opkey PA 12 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
Is it possible to add Approve and Reject buttons in payment process request tabSummary: Is it possible to add Approve and Reject buttons in payment process request tab in payables dashboard Content (please ensure you mask any confidential informati…Venkatesan 1 view 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management -
How to send an ESS job output on email?Summary: Need to send an ESS job output (ex: .pdf) on email, to certain people Content (required): Needed functionality: send ESS job output on email. Tried from: Schedu…Elena Tudor 1.4K views 6 comments 0 points Most recent by Aravind_Kumar_A Reporting and Analytics for ERP -
How to add Hyperlink to BI Excel template fieldSummary: We have a requirement to show Oracle AR Invoice Page and when click on Invoice Number in BI Excel template. Excel template has list of Invoice Numbers and its d…SireeshaJaladi 335 views 5 comments 0 points Most recent by SatheeshSamy-Oracle Reporting and Analytics for ERP -
How to schedule FRS reports in Fusion FinancialsSummary: I need to run an FRS report in Fusion Financials using scheduling. In EPM the process would be to create a batch and then add the batch to the schedule. In Fusi… -
Tables to get Multiperiod Accounting Invoices With Amortization ScheduleSummary: Tables to get Multiperiod Accounting Invoices With Amortization Schedule Content (please ensure you mask any confidential information): Hi All, Is there any tab…Venkatesan 41 views 1 comment 0 points Most recent by Daniela Petria-Oracle Subledger Accounting & Accounting Hub