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
-
CDC capabilities of BICC extractsA few questions about the CDC capabilities of BICC extracts, particularly around how they handle deletions and intraday changes - such as multiple status updates occurri… -
CDC capabilities of BICC extractsa few questions about the CDC capabilities of BICC extracts, particularly around how they handle deletions and intraday changes - such as multiple status updates occurri… -
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 …
-
Create custom role to files in UCMI need the ability to view files in UCM, we have a report which runs via an ESS job but its erroring because users don't have the relevant privileges to access UCM. The … -
Table to get Task Details from Strategy assigned to customerSummary Table to get Task Details from Strategy assigned to customerContent Hello, We are unable to find the table to get Task Details from Strategy assigned to customer… -
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… -
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… -
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… -
ERP Period Close White Paper with Runbook Considerations (Doc ID 2506148.1)Summary Updated documentation availableContent Hi, Please note that we have posted an updated Period End document (21C) onto MOS 2506148.1 today. Also, based on customer… -
Date Incorrect in Report OutputSummary I can't get the date to be correct in the Excel outputContent I have a report that is pulling from the AP tables. The date fields are set to True for Ignore User… -
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… -
created_by or last_updated_by - how to find username on those fieldsSummary created_by or last_updated_by - how to find username on those fieldsContent in gl.created_by and gl.last_updated_by I get a number or email address. How do i get… -
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… -
Require logic to fetch month end exchange rate while generating revenue in Projects Billing ModuleSummary: Urgent!!!!!! Client requires the Revenue in Projects Billing to have month end exchange rate even if the Event Completion date is mid month. Example, event was … -
OTBI Drill Down for AR_Transaction does not work with VIEW actionSummary: OTBI Drill Down for AR_Transaction does not work with VIEW action. It works with the EDIT action. It shows in Deep Links (under Tools) that it's a valid action.… -
Need report that shows all approval assignees who have NOT approved invoiceSummary We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)Content We a… -
List of all seeded reports for SCM , Procurement and Procurement contractsI am going to the below navigation for getting the list of all the seeded reports. Below is the example for procurement but could not find the right link. could you plea… -
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… -
oracle.xdo.xdoexception: java.net.malformedurlexception: unknown protocol: xdoxslHi, We are facing an issue with a particular user for BI Publisher report where we have a sub template. However, When I run the report, I don't see any issues from my en… -
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… -
Is there a lag period before OTBI displays new invoices/data?Summary: Hi everyone, I am running the Payable Withholding Tax report from Reports and Analytics. Navigation: Shared Folders/Financials/Payables/Income Tax and Withholdi… -
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… -
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… -
How to capture Tax Classification Code at Supplier Address level in OTBI report.Hello Experts, we want to capture the Tax Classification Code at Supplier Address level using an OTBI report. We are checking on Supplier Real Time subject area. Is ther… -
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/… -
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… -
FinancialsCommonEntities failedSummary: I am using rapid implementation template to load FinancialsCommonEntities. after loading i am getting error message for address Legal locations import failed. o… -
Can we restrict jobs based upon roles?Summary: Hi Team, We are looking for a possible solution which might help us to satisfy the below requirement Step 1: A Custom roles to be created and assigned to a user…