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
-
How to use Starts With or Contains function in BI Report SQL QuerySummary: Is it possible to use Starts With or Contains function in BI Report SQL Query? If so, how? Content (required): Is it possible to use Starts With or Contains fun… -
How can we secure/hide the Reports and Analytics Panel Tab on a given page?Summary: Requirement is to secure the Reports and Analytics Panel Tab on certain pages to certain roles or in one case hide it completely. How do we do so. Content (requ… -
Is there a plan to lengthen the BIP audit log data of 90-day retention period to, say, 180 daysSummary: We would like to ask if Oracle Product Team has planned to lengthen the 90-day retention period for BIP audit log data. Content (required): Audit Log Version (i…
-
Is it possible to connect a sharepoint to ERP in order to add attachments to transactions?Summary: Users have asked for a solution that doesn't require downloading and uploading of files to their local machines. Content (required): Is it possible for users to… -
How to apply font color conditionaly in BIP ExcelSummary: We are currently building an audit report in which changes should be highlighted. The report contains values before and after. If value after is different from …
-
Unable to call BIP report with REST APISummary: Hi Experts I'm trying to use the REST APIs for the BIP report developed in Fusion but I'm getting not found error, please help me if I'm creating a wrong URL Be…
-
Getting Errore in FRS Report - Internal Essbase JAPI errorSummary: Getting Errore in FRS Report - Internal Essbase JAPI error Content (required): Dear All, I tried to run a FRS Report and I am getting the below error. Error exe… -
I am not able to see few terminated PPRs in iby_pay_service_requests tableSummary: Some of the terminated PPRs in the iby_pay_service_requests table are not visible to me. Does this table lack any security or data access? Despite the fact that…
-
What is Public View Objects (PVO) and where can we use it?Summary: What is Public View Objects (PVO) and where can we use it? Can it be used in Data model for BI Publisher report? Also, can we see the SQL or logic behind this P…
-
How to add sequence number & date in BI excel templateHi, I have developed a Data model and attached an Excel template in BI. I am able to generate the data as expected. However; we have a requirement to add a sequence numb…
-
Access to Financial Report to the users on the basis of their respective Cost CentersSummary: Access to single Report developed in Financial Reporting on the basis of Cost Centers Content (required): I have created an Income and Expenditure Statement usi…
-
Exporting OTBI dashboards in PPT FormatSummary: Content (required): Hi Team, We have a requirement to explore alternative formats to export OTBI dashboards, other than Excel and PDF. One of the potential expo…
-
Need help on getting correct YTD_DEPRN (YTD Depreciation) and DEPRN_RESERVE (Depreciation Reserve)Summary: Can someone pls provide inputs on where can we find correct base table and column for YTD Depreciation and Depreciation Reserve for a specific Asset and Book wi…
-
How to find SQL query or logic behind the value set attached to the ESS job?Summary: Is there a way to figure out how the Asset book list of values are populated when running Create Mass Addition program? As per below screenshot, List of value s…
-
No access privilege for subject area errorSummary: User getting this error No access privilege for subject area when trying to access OTBI Reports using Order Management – Fulfillment Lines Real Time subject are…
-
Report for BPM Workflow RulesSummary: Is there a mechanism to pull out list of BPM rules as an extract or report. Also the workflow Rules Report covers some of the workflows but not all. Content (re…
-
How to use INSTRING function to retrieve string Position in OTBI Formulae column?Summary: How to use INSTRING function to retrieve string Position in OTBI Formulae column? Thanks, Immanuel
-
Can we add attachments using sandbox?Summary: We have a business requirement that the users wants to attach documents in the Supply Request Form. Can we add attachments '+' using sandbox? kindly guide us ho…
-
How to default System Date using Sandbox?Summary: We have one requirement that we need to default the system date in the Supply Request Form Content (required): We have one requirement that we need to default t…
-
How to Zip BIP output containing multiple output filesSummary: Content (required):We are trying to download zip file(containing all output files for particular schedule) using Compress output prior to delivery. Version (inc…
-
Output Name is incorrect in Report Job HistorySummary: Content (required): We used Bursting to set the file name of the report. It is displayed correctly on the Schedule Report Job History screen inside file name bu…
-
OTBI User sessions not shown in Manage sessionsSummary: Other user's OTBI sessions don't seem to be always passed through and visible in Admin>Manage sessions, even when using report with prefix set to: SET VARIABLE … -
-
Rehire can't run OTBI report, but net new user account with same access canSummary: We have a rehire who can't run an OTBI report we built, but the same net new user account with the exact same roles and data access can. Content (required): Has…
-
Filter function in case statement in otbi columnIn my otbi analysis, I tried to add this formula in my column CASE WHEN "Compensation - Workforce Compensation Budgets Real Time"."Workforce Budget"."Published Worksheet…
-
Audit Tables in Oracle CloudSummary: Audit Content (required): We are working on Audit Report. User is not happy with the output provided by the Audit Report functionality in Oracle and we want to …
-
Fusion to Datawarehouse mapping for reportingSummary: We are currently using Snowflake as out data warehouse product. We generate quite a few different reports from the data located there and this move to Oracle Fu…
-
How to create deep links with parameters for supplier qualification moduleSummary: As a business requirement, we should create custom Overview page in supplier qualification module. we built a analysis on the new page and when we click on resu…
-
Multiple Email domain to send seeded Out of the Box Reports in different ModulesSummary: We have a requirement for specific Oracle-generated emails to be associated with distinct domains that represent different divisions within our organization. Th…
-
How to configure the notification for Journal Request ProcessOracle OneERP --> General --> Journal. A notification e-mail is currently automatically sent to journal requestors' individual e-mail addresses. Can we change the config…