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. I would like to know if there i… -
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 …
-
I need a query to obtain Chart of accounts Values on ERPSummary: We are trying to create a report using BI Publisher and We require a SQL query to obtain the chart of account value set values (Value and Description shown on s…
-
Sql query for Canceled Payment Report.I wanted to fetch the Canceled Payment details from the person results through SQL query.
-
In Payment Approval Notification, Can we add one more pdf attachment?Summary: We want Output of Payables Selected Installments Selection Report along with Disbursement Payment Process Request Status Report in the Payment Approval Notifica…
-
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…
-
Depreciation Projection Report in Oracle Fusion CloudSummary Depreciation Projection Report in Oracle Fusion Cloud in Fixed AssetsContent Hi Friends, In Oracle Fusion, is there any report to project depreciation, similar t… -
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…
-
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…
-
Link between Bank Statement line and Transactions for Group of Manual Reconciliation.We are working on the BI report to Pull AP and External Transactions. I need to join the CE_STATEMENT_LINES and CE_RECON_HISTORY_ITEMS to AP_CHECKS_ALL. When I tried to … -
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 …
-
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 run US 1099 Electronic Media Report for a specific vendorHi All, We need to submit an electronic file for one vendor we missed. Is there an option to run the US 1099 Electronic Media Report for a specific vendor. There seems 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… -
ERP Report Sharing CentreSummary LocationContent Hi All, The HCM report sharing centre (https://cloudcustomerconnect.oracle.com/resources/5c46181001/summary) is a hive of activity, but the ERP o… -
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 use Projects related Condition in AP Invoice Approval RulesSummary: We need to use Project related conditions in the AP Invoice Approval Workflows. Please suggest. Content (please ensure you mask any confidential information): W…
-
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…
-
Output BIP Report into JSON formatIs it possible through OTBI BIP report to output into JSON format?
-
Can we submit ESS job using BIP Report ??Summary: Can we submit ESS job using BIP Report ?? Content (required): Can we submit ESS job using BIP Report by setting data set as Procedural call ? Version (include t… -
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…
-
African Countries - Statutory Reporting Requirement as per OHADADoes Oracle Fusion Cloud support the reporting requirement in African countries as per OHADA? OHADA stands for The Organization for the Harmonization of Business Law in …
-
Read only access to data modelSummary: We want to provide read only access to data model for some key BIP reports, to our Internal audit team as they want to review the code behind key sox reports. W…
-
Publisher report export to CSV with different columns order when running manually versus schedulingSummary: Publisher report export to CSV with different columns order when running manually versus scheduling. We have a report that runs in the last 4 months scheduled o…
-
Moved: BICC Union all - documentationThis discussion has been moved. -
How to get the status of ESS Jobs From UISummary: We need to get the details of ESS Job from UI ,we need Current state , count, time ...) Content (please ensure you mask any confidential information): Version (…
-
SQL Select Query to Oracle SaaS TablesSummary Aside from OTBI, BIP or BI Analysis - is there another way to query-select SaaS Tables? Like an Oracle-provided Tool or 3rd Party ApplicationContent Hello, Aside…