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
-
Need Support for Missing Notifications in Fusion Expenses: Manager Reject and Audit Complete EmailSummary: Hi, We identified two missing email notifications in Fusion Expenses and need clarification on whether these events are supported as standard functionality: Man… -
Extract the customer credit limit detailsSummary: We have requiremnet to extract the customer credit limit details. Content (please ensure you mask any confidential information): We need a report or query to ex…
-
Grouping sections in a report created in Financial Reporting Web StudioPlease let us know if it's possible to collapse and expand the report information by section. For example, in this report, we need the accounts listed below the COST OF … -
Displaying Accounting Period parameter LOV in expandable hierarchical manner when running FRS ReportThe business' FRS report currently has their AccountingPeriod parameter set to only query years, which is causing issues when they're trying to query years with periods …
-
How to use another method of authentication for HTTP Connection in BI AdministrationSummary: We have currently setup an HTTP connection with Basic authentication. But Client is not convenient using Basic auth for REST API call to OIC. OAuth was not an o… -
Restrict sending attachment in email burstingSummary: We have a requirement that client does not want email attachment to go to the end user and should not be part of the mail body as well. We created a deeplink fo…
-
Suppress Outputs from showing under Output & Delivery after burstingSummary: We have a BI report that needs to be scheduled to run. The report will send multiple emails, and it also generates one output which contains summarized detail o…
-
when scheduling a BIP report by selecting multi select parameters at Trigger job is skippingSummary: when a scheduled a report by selecting multi select parameters in general Tab and at Trigger in schedule Tab job is getting is skipped even when data exists. Ex…
-
why the BIP Report does not consider the template while generating the output in CSV Format ?Req : Generate CSV output format with specific column names. Hi Team, I have designed an Etext template for the purpose of generating output in CSV format. Etext Templat…
-
Form Personalization Column HideWe have a form personalization requirement to hide the Distribution combination field if the Invoice type is 'Prepayment' from the AP invoice lines in create Invoice pag…
-
Accounts Payable OTBI AnalysisSummary: Adding a field to an "Analysis" Content (please ensure you mask any confidential information): I would like to add the Oracle assigned file number to the list o…
-
How to get email notification with company emailHi, We have a custom BI report with a job scheduled to run daily and send email notifications. Currently, the emails are being sent from the address from ****@oracleclou…
-
Unable to get OTBI column value for 'Request to Resubmit' Approval actionSummary: We are unable to fetch OTBI column value for 'Request to Resubmit' Approval action on Supplier Registration Request page which is impacting us to develop one ne…
-
GL Analytics dashboard in OTBIHas anyone created a GL analytics dashboard that they are wanting to share? I am trying to create a dashboard that gives our finance department/CFO all the information w…
-
customize a seeded dashboard with otbiSummary: I want to add three parameters in trial balance report which is a seeded dashboard I have customized it but not able to add the parameters that are cost center …
-
Encountering below error while adding Segment Description columns.Summary: Encountering below error while adding Segment Description columns. State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service ADFSer…
-
Feasibility check: OTBI report for supplier registration resubmissionsSummary: Hi Team, We received a customer requirement to understand which suppliers have the most difficulty during the supplier registration process, along with their vo…
-
Access restriction for userSummary: Access restriction for user Content (please ensure you mask any confidential information): Hi, Would like to restrict user that normal user - only can read and …
-
GL Transaction - OTBISummary: We are exploring an OTBI alternative, or reviewing the limitations within the subject areas, as a result of ongoing issues with the current report in BI publish…
-
Audit report for Assets: Asset Source LinesSummary: We want to know if we enable Asset Source Lines , will it impact system performance (based on audit report records). Looking for list of audit objects & descrip…
-
Prune Time for Hourly BICC ExtractsSummary: We have BICC Extracts running hourly and prune time set to 60. But the downstream applications have issues with the number of duplicates generated in every run.…
-
Issue With Notification Templates - Logo Breaks Approve, Reject, and Request Info ButtonsSummary: Editing the Logo in the Workflow Notification Subtemplate referenced in other notification reports e.g. Journal Approval Notification Report causes the approve/…
-
Procurement - Procure To Pay Real Time subject area: No data showing for Invoice MeasuresSummary: No data is coming for Invoice Measures for few users. Content (please ensure you mask any confidential information): Hi, OTBI report has been built using "Procu…
-
Person Number column is blank when creating an analysis using Project Costing Subject AreaSummary: Wehave created a report using the Project Costing Actual Costs Real Time subjectarea. In that report we have selected the Person Number and Person Name fields,b…
-
where can we find the PDF document OTBI_Cross_Subject_Area_Reporting_Guidelines ?Summary: this document is mentioned in few conversations but the link is broken ; Please provide a valid link to the PDF Content (please ensure you mask any confidential…
-
Can you please investigate why we cannot use the permissions against folders in OTBI ?Summary Why we cannot use the permissions against folders in OTBI ? what happens now is: when we got enough access, we can set up a specific permission at a certain leve…
-
Custom template is not reflected in ap invoice approval notificationSummary: Custom template is not reflected in ap invoice approval notification Content (please ensure you mask any confidential information): We've customized the AP invo…
-
How can we change the default template for the ESS Job Print Receivable TransactionSummary: I want to use another RTF for the standard ESS Job Print Receivable Transaction job Content (please ensure you mask any confidential information): Version (incl…
-
Which table store the ESS Scheduled Process frequency, actual schedule start date and end dateSummary: We have requirement to get the ESS Scheduled Process frequency, actual schedule start date and end date details. I have validate the fusion_ora_ess.request_prop…
-
SQL to retrieve Supplier, sites and Sites assignments BUSummary: Hi, Can any one share the script for retrieving list of active suppliers and their sites and site assignement BUs. Many thanks for your help Content (please ens…