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
-
Is anyone else having an issue accessing the 22D Readiness documents?Summary: Content (required): The links in the Cloud announcements are not working in either browsers, and same with trying to use the search in Support. Version (include… -
Report on OTBI Agents Scheduled / StatusesSummary: Report on OTBI Agents Scheduled / Statuses Content (required): Is there any way to Report on OTBI Agents Scheduled / Statuses, either via SQL in BI Publisher or… -
Combine BiP and OTBI audit data in custom reportSummary: Is it possible to combine BiP and OTBI audit data? Content (required): We have enabled the BiP audit feature and have compiled an OTBI audit report. Business is…
-
DFF not available in Subject area even after running the specified processSummary: We have created an OTBI report for Projects using Project Cost - Actual Real Time subject area and it includes a couple of DFFs. This report was migrated from o… -
how to define a xml in rtf if there are multiple datasets with the same column nameSummary: Hi everyone, Recently I faced an issue with a seeded report that was customized. The report had two datasets with the same column on both, where when I try to l… -
Error : Exceeded configured maximum number of allowed output sectionsSummary: Error : Exceeded configured maximum number of allowed output sections Content (required): Hi Experts, We are trying to run thr report " Payables Credit Memo Mat…
-
Prepayment invoice detailsSummary: Prepayment invoice details Content (required): Hi experts, I got new report requirement to display prepayment invoice details based on as on date. 1. prepayment…
-
ERP BI and OTBI Reporting - Creating Custom RoleSummary: Hi Guys, Anyone has any idea how to go about creating a Reporting Role for Applications Internal Team for adhoc BI & OTBI reporting . Is there a delivered role … -
Error whilst joining Subledger and GLHi, I am trying to create a report that joins the subject areas Subledger Accounting: Journals Real and General Ledger: Journals Real Time. It works fine up to the point…
-
OTBI Dashboards for AP and AR AgingSummary Graphical dashboards with summary aging of AP and AR debt, with drill-down to invoice detailsContent These dashboards provide a graphical summary of AP/AR debt w… -
BI Bursting - ZIP text files during deliveryHi All Is it possible to zip the text files from BI FTP bursting ? Thanks -
Pick Slips Not printing to printerSummary: Pick Slips Not printing to printer Content (required): We have scheduled Pick waves. Document set attached to the rule. Pick slip is submitted but failed to pri…
-
customizing Receivables Aging by General Ledger Account ReportSummary: I'm trying to customize the Receivables Aging by General Ledger Account Report, but I'm not able to get any sample data. Content (required): I have created a co… -
Payment infotile no longer be available from update 22CSummary: The Payment Infotile is no longer available from 22C, and Customers need to apply alternate Options for Supplier Outstanding Balance ( Doc ID 2871676.1 ) on My … -
What is the recommended way for an external system to extract data in bulk from Oracle Fusion?Summary: I'd like to understand the recommended way for an external system to extract data in bulk from Oracle Fusion? Content (required): I understand the various ways …
-
Tools > Audit Reports - What table can I look at to see this data?Summary: Tools >Audit Reports > run the report to view changes to supplier banks. There is a field Description. Need the table where this data is populated Content (requ…
-
What role is needed to run ESS job Vertex Payables Transaction Tax Action Report ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
What data store contains DFF fields for Enterprise Contracts header record?Summary: Content (required): We are trying to extract Enterprise Contract Header DFFs but cannot find a data store that contains these. Version (include the version you …
-
performance between xmlpserver/services/ExternalReportWSSService versus more api rest in integrationSummary: performance between xmlpserver/services/ExternalReportWSSService versus more api rest in integration on oic Content (required): hello I could to know that diffe… -
How do we set the default value to "On" for the prompts auto-complete field?Summary:In recent upgrade documentation https://docs.oracle.com/en/cloud/saas/otbi/otbi-notable/index.html#TBIWD-GUID-26F03E96-6982-42BC-A9CA-8BFEDBA1FFFC It mentions “S…
-
BICC - ability to product a single CSV output merging data from many data stores/VO'sSummary: Does BICC support selecting columns from different data stores/PVO's and apply query filter? Content (required): We have a business requirement to extract large…
-
Customize Receivables aging seeded ReportSummary Customize Receivables aging seeded Report - to include Project information and grouping totalsContent Hi, We want to customize Receivables aging by General Ledge… -
BI Publisher Excel TemplateSummary: How to display a column conditionally in BI Publisher Excel Template? Also I want to display a hard image in excel based on condition of data source in excel te…
-
Outbound Integration - Every one hourSummary: Outbound Integration - Every one hour Content (required): Hi All, We got the requirement for GL Journal outbound integration through BI report. The job should r…
-
Oracle Fusion BI Catalog Folder ControlSummary: Oracle Fusion BI Catalog Folder Control Content (required): We have encountered multiple times where users have accidently moved or made changes to BI Catalog F… -
Financial Reporting Webstudio Performance IssuesSummary: Oracle closed out the old discussions on this topic. We are still facing (on 22B) performance issues with Financial Reporting Webstudio. We are interested to he…
-
Send notifications of failed ESS jobsSummary: Is there a way to send notifications of all failed ESS jobs to system admins ? Content (required): Is there a way to send notifications of all failed ESS jobs t… -
How to send BI Publisher reports to FTP folder from ESS jobSummary: How to send BI Publisher reports to FTP folder from ESS job Content (required): Hello All, I will appreciate your support in the following: When I schedule the …
-
Report that shows project codes and cash receipts associated with that projectSummary: I am working on generating a report that shows both the project codes and the associated cash receipts/revenue detail with regard to that project - grant revenu…
-
Unable to locate Direct SQL option after upgrade 19ASummary Unable to locate Direct SQL option after upgrade 19AContent HI, I'm not able to location the Direct SQL option after upgrade the 19A. Can anybody suggest where w…