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
-
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 121 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… -
Invoice History Report for a given supplierHi All Is there any standard report which allows to drill down open closed invoices per supplier and also drilldown to the individual invoices via deeplinks ? Thanks Mur… -
Period name taken as a parameter tag display in a wrong format in excel outputSummary: Content (required): Hello Everyone, I recently created a BIP report using excel with the "xls" format and using the xml exported, I ,created the report in an ex…
-
How to customize Goal workflow notificationSummary: Content (required): Hi All, We have a requirement to customize the Goal workflow notification. we need to replace the word Goal with Objective. Is it possible ?…
-
Customizing Print Receivable Transactions: Invoices ReportSummary: We have this seeded report "Print Invoice Template" (Defaultinvoice.xdo) which has a corresponding ESS job "Print Receivable Transactions: Invoices" which is a … -
Extracting Other language description in OTBI ReportSummary: Extracting Other language description for Account Hierarchy in OTBI Report Content (required): Hi All, We are trying to build a OTBI report which displays Accou…
-
Report on Report Usage in FRSSummary: I am trying to gather information on which users run which reports in FRS. I have created an OTBI Usage report but that report does not include reports in the F…
-
Can we define custom report view in custom reportDear , We have one custom report (SQL query), now our requirement we have to show data as per user login For example if User ABC login report shows only custom Data whic… -
Fusion UI Customization TablesSummary: Fusion UI Customization Tables Content (required): Hi All, From which table we can get fusion page customization details like, who did the customization and the…
-
Can I combine two or more than two child values into one column of FR Studio Report?Summary: Two or more than two child values needs to be appeared into one column only. Content (required): I have one parent value (e.g.All LOB segment value) and inside …