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
-
Customize Printable Expense ReportSummary & Content: Need details for the other VOs and the attribute list similar to what was provided for PrintableReportVO and PrintableExpenseVO in the Oracle Ddocumen… -
Custom Folder is unavailable to all the UsersSummary: Our users are not able to see the Custom Folder under Shared Folders All our reports are in the Custom folder. Possibly -mistakenly the permission of the folder… -
OTBI function enablingHi Team When the user is working in OTBI (Subledger Accounting – Journals Real Time) and need to extract parts of the “Journal Line Description” field using pattern matc…
-
How can i get currency report to show currencies and the exchange rate against a currency in OTBIIgnore- Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Can the Workflow Transactions Listing report show workflows other than related to invoices?Summary: There is a Scheduled Process called 'Workflow Transactions Listing' which shows pending and rejected transactions related to invoices. Is there something simila… -
Need to show or hide details in po approval notification based on the approversSummary: Hi Team, We have modified the PO approval notification to add few details. We would like to display some contents in the notification report only to few approve…
-
GL-HUB-AP report takes too long to runWe have a report which pulls GL, Hub and AP data by journal line level, it takes a long time to run since it is going back into Hub, which has +1mn transactions per day …
-
How to Create a Report for Approval/Reject Notifications in Fusion?Hi Everyone, We have a requirement to generate a report for all email notifications sent from Oracle Fusion for Approval or Rejection actions. The report should include …
-
Issue on Transaction Class in Receivables TransactionCredit memos always have "Credit Memo" as the transaction class. But some of the Transactions were populated on the report as "ONACC" as Transaction Class instead of "CM…
-
ESS job and job sets migration from one instance to anotherSummary: We have around 200+ ESS jobs and each time after refresh, it is a tedious and time consuming task to migrate each of them individually. We have to document each… -
Is there a way to display the full content of a Text Attachment on a Purchase Order/PO PDF report?Summary: Full Text Attachment content is not being displayed on PO or PO PDF print report. Content (required): The table and column which stores the PO text attachments …
-
Is there anyway to extract Essbase cube data to connect with Powerbi beside smartview File?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to print prompted value as a header text in FRS report?In a custom FRS Balance Sheet report I have a requirement to print the prompted values as a selected parameter in the header section as a text value. Also I want to show… -
While creating FRS Report, I cannot find "Budget" choice when open Scenario DimensionHi All, Please we are creating a Financials Reporting Studio Report to compare between Actual Vs Budget. I have added "Scenario" as a column in the report, and when I ha…
-
Users with experience of using SQLConnect by BI SplashSummary: Users with experience of using SQLConnect by BI Splash Content (please ensure you mask any confidential information): We are reviewing the feasibility of granti…
-
BICC - Get Full Extract on every scheduled runSummary: BICC - Get Full Extract on every scheduled run Content (required): We have a requirement where we need to schedule a PVO on a daily basis. And the output of the…
-
BICC Downloading Files from UCMSummary: We are investigating using BICC to schedule extract from Oracle ERP rather than relying upon our existing process of using Custom BI Publisher Reports then burs…
-
Seeded report for ESS Job/BIP Reports running historyDoes Oracle has any seeded BIP reports or OTBI subject area to see below 1. ESS Jobs History 2. Scheduled BIP Report History
-
Delivery Filename in BIP Bursting definitionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
FDI create a custom subject area using the PVO'sWe have a requirement to print the AP invoice attachment URL and the attachment file name in the FDI report. Currently ap invoice subject area don't have these attribute… -
Will Oracle Fusion Cloud BIP report Bursting supports Dot Matrix PrinterSummary: one of the report needs to be printed in Dot Matrix Printer. So, We need below information 1. Will Fusion BIP bursting supports Dot Matrix Printer? 2. If so, in…
-
What are the considerations of enabling and disabling the global "SQL Pruning" setting in BIP?A customer enabled the global SQL pruning setting in production which caused various BI publisher report issues (primarily, missing columns from various CSV and RTF outp…
-
PVO BankAccountExtractPVO returns bank account data in OTBI - Issue SQL but no data via BICCNeed to identify missing privilege or profile. PVO FscmTopModelAM.FinExtractAM.CeBiccExtractAM.BankAccountExtractPVO not returning data via BICC. In Fusion > Tools > Rep…
-
How to perform drill-down directly within an Oracle PBCS report?Hi, I’m working on Oracle PBCS in the Reports section and I was wondering if it’s possible — and if so, how — to enable drill-down functionality directly within a report…
-
Is there a PVO (or combination of PVOs) that returns the accounting status of a Payables invoice?I need to return the accounting status (Accounted, Partially Accounted, Selected, Unaccounted) for a specific AP invoice but using PVOs. The column "ApInvoicesPostingSta…
-
How to count the number of pages per supplier in a report using RTF.Content (please ensure you mask any confidential information): I am creating reports using BIP (BI Publisher), and I use RTF templates for the layout. The report outputs…
-
Run a BIP report and get the output via REST APISummary: We are trying to run a BIP Report via REST API, but getting 404 not found error. /services/rest/v1/reports/{reportPath}/run Content (please ensure you mask any …
-
How to build an Custom AP trial Balance report without having to use ap_trial_balances tableSummary: 1. We are trying to build a custom AP trial balance table which we will be sending to ARCS returning the output in a csv format, but without using the ap_trial_…
-
PO PDF Report Showing Truncated “Text to Supplier” – Full Attachment Name/Text Not Printing CompleteHi all, We’re facing an issue with the PO PDF report where the Text to Supplier (or text from the URL attachment) is not printing completely. When we open the attachment…
-
BICC mapping documentation for a specific PVO missingSummary: Hi, we are doing BICC extracts on every day basis. One of the PVOs we are extracting and which is working fine is: FscmTopModelAM.PrcPoPublicViewAM.GlobalPurcha…