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
-
FRS report not showing Budget ScenarioSummary: Content (required): Hi, The "Budget" scenario is not visible in Financial Reporting Studio report creation. We have uploaded all required control budgets and ha… -
How to disable the Open option on Reports & Analytics Catalog?Summary: How to disable the Open option on Reports & Analytics Catalog? Among the various reports offered out-of-the-box by the Oracle Fusion modules, some of them can b… -
Manage Project Sets - Table/Subject AreaSummary: Content (required): Hi I would like to know which tables stores the information in regards to Project Sets that is created in Fusion. I find the manage project …
-
OTBI Report filter for first and last date of current monthSummary: Hi Team, I am scheduling an OTBI report. We have accounting date between parameter in report. I am adding filter to OTBI report and want system to take first an…
-
How can I schedule a BI Publisher report with dynamic date parameters for the previous 3 months?Summary: We have a report used by many business areas. One particular business area would like to schedule this report to pick up the previous 3 months of data. How can …
-
Error in join subject area Purchasing Real Time and Requisition real TimeSummary: Hi Team, We are trying to join the subject area Purchasing Real-time and Requisition Real-time, but getting error as below- Error Codes: OPR4ONWY:U9IM8TAC:U9IM8…
-
Font mismatch between RTF template and PDF outputSummary: Font mismatch between RTF template and PDF output Content (required): Hi Experts, We developed a custom template for the PO PDF report. We found font mismatchin…
-
Calculated measure questionSummary: Building multiple columns based on aging Content (required): I have defined a report that gives me the amount due on an invoice and it's related aging value. I …
-
Is there a way to report monthly financials that are not just year-to-date (accumulated) reporting?Summary: Monthly Financials Reporting Question Content (required): Is there a way to report monthly financials that are not just year-to-date (accumulated) reporting? Ve… -
Calculated Measures issueSummary: Calculated Measures when null value exists Content (required): I have two measure. The one being invoice amount and the other being invoice paid amount. For bot…
-
Report definition not found:/Custom/Financials/Payables/Invoices/****.xdoSummary: I keep getting the Report definition not found:/Custom/Financials/Payables/Invoices/****.xdo error Content (required): I keep getting the Report definition not …
-
Borders are not displaying in Word(.docx) outputSummary: Borders are not displaying in Word(.docx) output Content (required): Hi Experts, We develop RTF with borders, but when we run the output as .docx borders not di…
-
Sending Reports to a Google DriveSummary: One of our customers is looking to have certain reports from ERP delivered to a Google drive location. Has anyone tried this and if yes how was it done? Any inp…
-
Oracle ERP Cloud - Data Extraction via BICCHi - We are building a cloud data warehouse using data from Oracle SCM Fusion Cloud 22d using Oracle Business Intelligence Cloud Connector (BICC) for data extraction usi…
-
Role required for viewing otbi subject area "Project Costing - Actual Costs Real Time"Summary: Role required for viewing otbi subject area "Project Costing - Actual Costs Real Time" without allowing them to run Import Costs and Import Commitments schedule…
-
Error in accessing BICC URL ending fusion pod /biacmSummary: Hi Team, We are getting error while trying to access BICC using url - fusion POD /biacm. Anyone faced similar issue, so need help in resolution of same. ADF_FAC…
-
AR Transaction status in OTBII am creating a (crude) AR Aging report for a specific transaction type in OTBI, to include in in a dashboard. All columns I need are included in the subject area "Recei… -
DFF are not visible in Payables Payments - Disbursements Real TimeSummary: Hi All, We have created global DFF on AP_CHECKS (table) and made it BI enabled, but it's not visible in "Payables Payments - Disbursements Real Time" subject ar…
-
SQL automatically changes to uppercase on user defined LOV query under Manage List Of Values SourcesSummary: SQL automatically changes to uppercase on user defined LOV query under Manage List Of Values Sources Content (required): I have entered below SQL on the Query b… -
What are the tables that store the Manage Associated Business Entities data?Summary: What are the tables that store the Manage Associated Business Entities data? Content (required): Version (include the version you are using, if applicable): 22.…User_2025-02-11-06-12-35-024 116 views 2 comments 0 points Most recent by User_2025-02-11-06-12-35-024
-
API to manage BIP Catalog ObjectsSummary: Content (required): We have a CatalogService WSDL to download and upload catalog objects, however, that API asks for passing the username and password in the Bo…
-
REST API to schedule and run report in Oracle Fusion BIP reportsSummary: REST API to schedule and run report in Oracle Fusion BIP reports Content (required): Version (include the version you are using, if applicable): 22D Code Snippe…
-
Digitally Sign BIP report sent to SFTP server using BurstingSummary: Hi Team, Once we set up the SFTP server in fusion as a delivery option, there is a checkbox to sign output. So does it digitally sign the file and it will use w…
-
Need help in understanding the BIP SQL query (new to SQL and BIP)Summary: Hi Experts I'm new to SQL and BIP reporting. I'm working on one BIP report and I have added parameter to an existing BIP query to filter based on item number, a…
-
Has anyone use SplashBi or Orbit Analytics before?Summary: We are reviewing some external vendor tools to work with Oracle EBS and want to know if anyone has used this before and can make some recommendations. Content (…
-
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):…
-
Getting warning while creating Content Data setSummary: Getting warning while creating Content Data set Content (required): Hi All, Got a requirement to show attachments in the PO PDF report. So we try to customize t…
-
Unable to suppress columns in Smart View retrieveSummary: Apologies if this is the wrong forum on which to ask this - I have created a Smart View retrieve to extract data from ERP, however in Smart View -> Options -> D…
-
Calculate difference between previous and current amountSummary: How to add a column for calculating the difference between yesterdays closing amount and todays opening amount Content (required): We have built a simple OTBI r…
-
Need a query to get negotiation approver list in oracle fusionSummary: Content (required): Hello everyone, I need a query to get negotiation approver list in oracle fusion.Please advise! BR, Sushan Peiris Version (include the versi…