To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Report to find requisition approval reassignmentsContent Hi, We need to create a BI Report showing which requisitions were reassigned to other users. The FND_BPM_TASK_VL/HISTORY tables don't seem to have this informati… -
Report and Dashboard prompts on multi tab DashboardSummary Prompts not clearing and show selections from other report promptsContent I have a multi tab Dashboard with two to three reports on each tab. Each report has it'… -
How to Add the OTBI Dashboard to the Financial Reporting Center?Summary How to Add the OTBI Dashboard to the Financial Reporting Center?Content How to Add the OTBI Dashboard to the Financial Reporting Center? OR If i can make it more…
-
ERP Data Deletion/Data RetentionSummary Guidance on capability/ best practice for data retention within Cloud ERPContent Would like more information on the capabilities within cloud to purge/remove dat… -
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 … -
Smart View Error - "XML Load Error: 'End tag 'head' does not match the start tag 'meta'Summary Smart View Error - "XML Load Error: 'End tag 'head' does not match the start tag 'meta'Content We just started receiving this error on Saturday after 20D was app…
-
If we need to run a report or a query on all the profile options currently set for our client in FusSummary If we need to run a report or a query on all the profile options currently set for our client in Fusion, is there any way?Version 21A
-
What's your go-to browser for Oracle Fusion Cloud Financials?Summary Firefox? Chrome? Edge? Which one do you prefer--and which do you avoid?Content Like many Oracle users at the City of San Luis Obispo, California, I use Chrome fo… -
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 941 views 2 comments 1 point Most recent by Sankeerthana Anumasula-Oracle
-
BI Publisher report should send email with Digital signatures in email body.Summary We have a business requirement to digitally sign the email while transmitting transaction prints to customers. Basically, the email body needs to have the digita…
-
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, Vipusha
-
No data in Account Analysis ReportContent Steps to reproduce: Run Account Analysis Report Process -> Select parameters and filter with some accounts -> Process ends "Success" -> Open the file -> There is…
-
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… -
BI REST APIsSummary BI REST APIsContent Hi All, Has anyone tried using the REST APIs to invoke a BI Report? I am having a hard time to get it working. If you have sample code and ca… -
How to access Custom ESS Job SetContent Business Users are not able to access the Custom ESS Job Set. We checked the below Oracle notes, but nothing works. How to Grant Execution Privileges to ESS Cust… -
FscmTopModelAM.FinExtractAM.GlBiccExtractAM.BalanceExtractPVO does not contain creation_date, why?Summary Why does FscmTopModelAM.FinExtractAM.GlBiccExtractAM.BalanceExtractPVO not include creation_date column?Content Why is creation_date missing from BICC Balance Ex…User_2025-03-07-18-57-57-349 840 views 0 comments 1 point Most recent by User_2025-03-07-18-57-57-349
-
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…
-
Pulling reports dataContent Hi, Is there ways to pull data from BI report say Payables Register Report using any API and push to staging tables from the external application. I have require… -
Readiness PDF linkContent Previous to 21A update, Readiness docs had both HTML and PDF links. But, now we have only the HTML link. The PDF was very useful for offline viewing. If feasible…
-
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… -
Can Saved Custom Groups be used in Calculations/Formulas?Summary Using Custom Groups in Calculated ItemsContent In OTBI, I've designed an analysis where I've created custom groups of the Natural Account Segment Code using GL -…
-
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 …
-
how i get discount rate in ar ar invoice ?Content in table ra_customer_trx_all i need to get discount rate . i tried but i can't get it , how i get it ?
-
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… -
Page wise totalContent Hi, I have report which runs for multiple pages assume 20 lines in each page there is requirement to sum page wise total of the amount (which means sum of the am…
-
Finance Cross Validation RulesContent Other than the help guide are there any Best Practices for Cross-Validation Rules? Version 21A -
Ability to export configuration in readable format (like OC Autoconfigurator)Summary Users want to export setup data to check the configuration, but currently only zip package export are supported, and the data is not the same as what we view on …
-
Help with OTBI Filter ErrorSummary Error when filtering for a date rangeContent Hello, I am having 2 issues. 1. I am trying to create a filter using Invoice Date where report would show all invoic…
-
OTBI Drill down to External Cash Transaction - Blank transaction pageContent I cant get the drill down to External Cash Transactions to work in my OTBI Analysis. Everything seems to be fine and I am redirected as expected. The problem is …
-
Bursting A Report With SubTemplatesSummary How to burst a report using a sub template.Content Hi Experts, We have a custom report which uses a sub-template. The report also uses bursting to email. But the…