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
-
Query to fetch List of OTBI usersHi Team, We do have a requirement to Create a report for List of users having OTBI access. Regards, Ramu -
Custom sort OTBI ColumnI have a column in my otbi analysis. They return me the values Exceeds Performance Expectations, Inadequate, Meets Performance Expectations ,Nearly there, No PMS Rating.…
-
Add Segment Description to OTBI ReportSummary: We have a report that uses the subject area General Ledger - Journals Real Time subject area, and we want to add the segment description for our 5 segment. We k… -
Getting an error while trying to open Supplier Master OTBI reportSummary: Unable to open Supplier Master report created in OTBI Content (required): Hi, I have created a supplier master report in OTBI with the fields such as Supplier N… -
Report for License ConsumptionSummary: Simply do not know how to pull a report that tallies license consumption by user. Content (required): Can someone provide the report or directions for reporting…
-
Some Prepayment Invoice amount showing doubleSummary: Content (required): Dear All We have an query which will fetch the Prepayment Invoice details , the query is working fine , but it is noticed that some of the i…
-
Moved: What is the subject area of Project Definition DFF on OTBI on Projects module?This discussion has been moved. -
How to add Hyperlink to BI Excel template fieldSummary: We have a requirement to show Oracle AR Invoice Page and when click on Invoice Number in BI Excel template. Excel template has list of Invoice Numbers and its d…
-
Month end closure jobs in Oracle ERPSummary: I have a requirement to run the below jobs on demand in serial (one after another with single job set) Translate General Ledger Account Balances (Multiple Ledge…
-
How to use the "is based on the results of another analysis" filter operatorSummary: We created two analysis in OTBI and put them in a dashboard. The one report drills to the second report via action links. The second report is using the filter …
-
ERP Adaptor service to get Parameter Values of ESS JobHi, Is there an out of the box service (in ERP adaptr or REST API) to get the parameter details of the ESS Job if we provide the ProcessID ErpIntegrationService --> getE…
-
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: We were given a SQL query to pull journal entries for our auditors and it worked successfully for FY22. We tried to run the report again for 2023 and received t…
-
Email Both PDF and XML Format with Bursting QueryI have a custom packing slip report that is triggered off a customized scheduled process and the bursting query in the data model of my report handles the email output. …
-
-
Cost Center wise access to different users to view Financial ReportsSummary: We have a requirement where the client is expecting access to Financial reporting on the basis of Cost Centers authorized for the user. Content (required): For …
-
What are the roles that are part of "Oracle Fusion ERP for Self Service Cloud Service"?Summary: What are the roles that are part of "Oracle Fusion ERP for Self Service Cloud Service"? Exist Fixed Assets role for Self Service Cloud Service? Exist Payables r…
-
What are the roles that are part of "Oracle Fusion ERP for Self Service Cloud Service"?Summary: What are the roles that are part of "Oracle Fusion ERP for Self Service Cloud Service"? Version (include the version you are using, if applicable): Oracle Fusio…
-
How invoke an Web service using an Analysis in OTBI?Summary: Use an Invoke web service get and push the information in another system Content (required): We have a proposal to active an web service when a field in Transac…
-
Can we select a range of member values in the prompts while running a FRS reportHi Team, We have a requirement to provide prompts for running an FRS report, wherein we can select a range of values, like 'From' and 'To' option while selecting account… -
Is Oracle Fusion ERP Cloud is an approved software in Israel?Summary: Content (required): Is there any document or certificate that can prove Oracle Fusion ERP Cloud is an approved accounting software by Israel tax authority? Vers…
-
Transfer of Business units from one ledger to another ledger and from one legal entity to anotherTransfer of Business units from one ledger to another ledger and from one legal entity to another legal entity. I need the details and Action Plan and What is impact of …
-
Table name that holds the Supplier Site Purchasing Tab dataSummary: Table name that holds the Supplier Site Purchasing Tab data Content (required): I'm trying to create a BI Report to monitor when PO's are not communicated out t… -
Query to retrieve entries using accounting period from and accounting period to parameterSummary: Query to retrieve entries using accounting period from and accounting period to parameter when both are optional Content (required): Version (include the versio… -
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…
-
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… -
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… -
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…
-
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…