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
-
What reports are available for agent level productivity metrics?Summary: We are looking at agent level productivity metrics. What seeded reports are available in Oracle? Or are these custom created reports? This ask is across all the… -
How can i get currency report to show currencies and the exchange rate against a currency in OTBIIgnore- Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
How to print all lines returned in dashboard from analysis in a PDF print format or PDF export?Summary: I created an analysis, embeded in a Dashboard. I also created a Report under Print & export options in the section Custom Print & Export Layouts. I added date &… -
Oracle Fusion Cloud ERP passwordless authenticationHi Team, Has anyone able to implement passwordless authentication for Oracle Fusion Cloud ERP using PingOne Identity platform?
-
https://CloudUrl:443/xmlpserver/services/ExternalReportWSSService' failed:Timeout exceeded.Summary: We have custom BI Report data model and layout. we trigger BI report using https://iaxgqy-dev1.fa.ocs.oraclecloud.com:443/xmlpserver/services/ExternalReportWSSS…
-
Excessive delays generating XLS output files from Report books starting mid-March 2025Summary: Excessive delays generating XLS output files from Report books Content (please ensure you mask any confidential information): Starting on March 24, 2025, our re… -
BIP Scheduler is not working for Monthly jobI have scheduled my BIP report for 1st weekday of every month but it is not triggered. I have attached Screenshot of my schedule. Please Advise. Thank You, Khushi
-
Tax Audit Trail Report export to excel not working properlySummary: Tax Audit Trail Report export to excel not working properly. This started happening in Feb25 after patch. HTML looks ok but when you export to excel it is messe…
-
fdi first valueIn FDI what is the formula to get the first value (or last) for a field that may have multiple values. Instead of displaying multiple rows that show each of the values I…
-
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…
-
Journal Entries And Subledger Details Query HelpSummary: We just implemented Fusion Cloud/Financials so I'm very new trying to figure out the database tables and relationships. I've been tasked with creating a custom …
-
The data extracted from BICC extract is in UTC timezone. Can we change that?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Our customer needs to identify the report path in OTBI related to an Infolet.Our customer needs to identify the report path in OTBI related to an Infolet. Please see the attached document (Infolet-OTBI.docx and HELP-OTBI-PATH.docx) attached here.…
-
Oracle Fusion BIP Report ESS Job Parameter Error & How to Enable XML and Diagnostic LogsHi Team, I’m facing an issue when scheduling the ESS job — as soon as I select the parameters, it immediately throws an error. The current log doesn't provide enough inf…
-
Convert SYSDATE from UTC to the local timezoneSummary: Hi, I s there any way to convert the returned sysdate value from UTC Timezone to local TimeZone in Oracle Fusion BIP reports? We tried many recipes for that, bu…
-
Language Translation DictionariesSummary Searching for a .csv file that would have the Oracle UI elements translated from English to the languages available.Content Hi all, We currently are looking for … -
Project Period Close Exceptions DashboardSummary Project Period Close Exceptions DashboardContent Project Period Close Exceptions Dashboard - Anybody created as shown in release document. Attached screenshot -
Add PDF Attachment to Email Bursting MethodSummary I want to attach a specific pdf file as an attachment to emails sent by a bursting methodContent I created a data model that looks at overdue invoices and produc…
-
How can we see the Reports which are there in My folder of Other UsersSummary: We want to see the reports which are there in My Folder of all other Users. Is there any other way we can do this without logging into each individual user and …
-
MSC_HVGOP_WEEKLY_ALLOC_REPORTSummary: How can i join this table with Item related Tables Content (please ensure you mask any confidential information): Version (include the version you are using, if…
-
Difference between 11i and 12.2.9 or new featuresContent Hi, I need a document for difference between 11i and 12.2.9 or new features, we have a training after upgraded the application. Thanks -
Report combining Subject areas Project Costing - Actual Costs and Project Costing - CommitmentsHi, Has anyone created an OTBI report that lists all costs related to a specific project and the tasks designated to that project? I was able to get almost all the field… -
What is equivalent table to xla_trial_balances in Oracle Fusion?Summary: Hi All, I am working on migartion a RDF report from EBS to fusion. Existing EBS report is using table xla_trial_balances which or equivalent table i am not able…
-
Some of the fields in the OTBI subject area are not populating valuesWe are trying to select "check number" from the OTBI subject area "Payables Payments - Disbursements Real Time" but the field results no values in it due to which the da…
-
How to use 2 subject areas in same formulaSummary: Using Analysis Report type, is it possible to have data from both subject areas in the same formula? Content (please ensure you mask any confidential informatio…
-
about assigning roles for OTBI report accessHello, I have some questions about assigning roles for OTBI report access. For cross-module OTBI reports, we created a duty role requiring 'priv1', 'priv2', and 'priv3' …
-
Create custom notification with Agents in OTBISummary: We are looking to create custom notifications utilizing Agents in OTBI. We have specific use cases where we need users to receive notifications (i.e. project co…
-
Issue with RTF Template – Pivot Table MergingSummary: we are using a Pivot Table to display invoice data for suppliers across different legal entities over a six-month period (from the given reference period). Issu…
-
What is "ORA_FUN_DATA_MAINT_KEY" about and How it worksSummary: is there anyone who knows what is "ORA_FUN_DATA_MAINT_KEY" look-up about and how it works? I've found that that this "ORA_FUN_DATA_MAINT_KEY" look-up code has b…
-
How to apply segment value security to Procurement OTBI subject areasSummary: How do we restrict access to requisition OTBI subject areas based on the segment value security rules? Content (please ensure you mask any confidential informat…