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 there an advanced official source about the map view feature in OTBI?I would like to try using the map view in OTBI and followed the guide below for configuration, but only the background map is displaying. https://docs.oracle.com/en/clou… -
Get Recipients from the Analysis as Task Owners from Project Subject AreaSummary: Cannot set dynamic recipients of an email with analysis. The standard functionality should be available using an Agent. The agent was setup for an analysis done…
-
Enterprise Contracts OTBI Fields - Couldn't find the notes on a contract field in the subject areaHi All, Is it possible to include the notes on a contract as a reportable field when creating an analysis? It is currently not an option. Can anyone please guide me on w…
-
Roles and Privilege required for ExternalReportWSSService creation using SOAP WebservicesWe created a call for a report using Soap Webservice, but we need to add the role or privilegies to our User. Someone knows them? Thank you so much
-
Big performance difference between the query in BIP data model and the pure querySummary: The issue below has been observed Performance of a custom BIP started to be extremly degraded post to the upgrade. The BIP used to run in a second, but it start…
-
sql query to fetch item number detailsSummary: We need a SQL query to fetch the item number, business unit, inventory item id, unit cost, total cost, sub inventory code, organization name. Kindly let us know…
-
bi publisher to oci object storageSummary: How can bi publisher report burst the out to an Oracle Cloud Insfrastructure Object Storage Content (please ensure you mask any confidential information): BI pu…
-
Scheduled BI Publisher reportSummary: Does a scheduled report need re-scheduling if its underlying BI Publisher template or data model is changed after the scheduling starts? Content (please ensure …
-
Table details for ESS_REQUEST_HISTORY and ESS_REQUEST_PROPERTYHi, Are ESS_REQUEST_HISTORY and ESS_REQUEST_PROPERTY database views? If yes then what are the tables using which these views are created or where can we find query of th… -
Query to get all possible list of ess job statusesHi, Is there a standard or common lookup which holds all possible values of ESS Job statuses like Succeded, Error, Warning etc. ? There's one common lookup 'ORA_WLF_ESS_…
-
Missing Data in Custom Report for Scheduled ProcessesSummary: We have created a custom report to meet the requirement of viewing all scheduled processes created by all users. In this report, we aim to display columns such …
-
display column based on promptSummary: I want to add a prompt (Yes/No) to display a column. I'd settle for a prompt that forks to two different results tables as well. Content (please ensure you mask… -
Can BI Publisher Data Models query the table SYS.DBA_COL_COMMENTS in Oracle Fusion Cloud?Can BI Publisher Data Models query the table SYS.DBA_COL_COMMENTS in Oracle Fusion Cloud? I need to query this table to see the purpose of various fields in various tabl…
-
How to populate tax rate name under Receivables-Transactions Real time subject area in an OTBIWe built an OTBI report with the subject area - Receivables-Transactions Real time. We do not see an option to select the tax rate name/code such as GST, HST etc. Only t…
-
Unarchiving Custom folder after refresh fails without any error messageWe have been backing up the Custom folders (under shared folders) before the refresh on all non-prod pods. After the refresh is complete, we import back the custom folde…
-
Adding manually uploaded attachment in Email BurstingSummary: Is there a feasibility to attach manually upload files in Email Bursting along with Bursting output Content (please ensure you mask any confidential information…
-
How to get Risk Code value in BIP Custom ReportSummary: We are developing a customer report and we need a column called Risk Score. The value we may need is similar to this 'Any value between 1 – 69 is high risk and …
-
Does an expense listing report exist?Users are wanting to run an expense listing report - does anything exist similar to what existed in EBS r12? Or alternatively is there a form where this can be extracted…
-
Data Model Default parameter to current periodOn a Data Model for a report I have a parameter for the period that I would like to default to the current period. The parameter is a Data Type of Date and a Parameter T…
-
How to create data control name while registering ESS jobHi, We have requirement to modify default parameters of the seeded ESS Job. Parameters controls by the "Data Control Name" . Is there any feasibility to create a new "da…
-
Output BIP Report into JSON formatIs it possible through OTBI BIP report to output into JSON format? -
How to output the BIP report in PDF formatting through APISummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is there a way to limit what tables a user can query in OTBI?We have a support team that's requesting access to write Data Model queries in OTBI. Our concern is restricting them to only the financial tables. Does anyone know if th… -
Moved: BICC Union all - documentationThis discussion has been moved. -
How to create ESS job to invoke multiple BIP Reports in oracle fusionHi All, We have a requirement to burst multiple-report output through the ESS job and this job will be invoked from OIC. Can you please help how we can achieve it. Thank…
-
How to check all the schedules defined in BICC -- by anyoneSummary: How to check all the schedules defined in BICC -- by anyone How to check which all jobs are currently running in BICC How to check which all jobs errored out in…
-
Moved: query has column present but not present in RTF after importing sample xmlThis discussion has been moved.
-
Moved: Quality Dashboard for HCMThis discussion has been moved. -
How to connect to GL Cubes as data source for MDX queriesSummary: Hello, I am trying to run a MDX query in Fusion ERP. But there are no data sources available. How can I create a data source to connect to the GL Cubes within E…
-
Performance issue with Custom ReportSummary: Dear All, We are facing performance issue with one of the report. This report provides the information about the Project Budgets along with Expenditures details…