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 & Analytics for Fusion Service
Discussion List
-
New! AI Agent Collaboration CenterWe are excited to introduce the AI Agent Collaboration Center – a dedicated space for our community members and Oracle, to showcase, exchange and explore real-world AI A… -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available … -
how the career statement is getting displayed and follow the same in your custom report.The Career Statement is displayed in the standard Oracle HCM application with proper formatting. However, the data stored in the backend contains HTML tags. In our custo…
-
Reporting on Primary Contacts in OTBISummary: How can we join the CRM/Help Desk - Case Management Real Time (or Help Desk - HR Service Requests Real Time) subject area to another person based/Workforce Mana… -
Oracle Schedule Agent discrepency compared to manual runHi, We have encountered an issue regarding an OTBI scheduled Agent report where the output results differ significantly depending on how the report is run: Manual Run (v…
-
How to create Employee as a SupplierWe have a requirement to create Supplier records for all active Employees. Please advise on the best approach to establish a link between the Employee and the correspond…
-
Is there a report to show employees with no supervisor listed on their current Assignment record?Is there a report to show employees with no supervisor listed on their current Assignment record? -
REST API to check onhand quantities at org and item level in oracle fusionCan experts help me to with REST API to check onhand quantities at org and item level.
-
HR Help Desk Infolets "My HRHD Request Work Time" and "Team HRHD Request Work Time" return no dataSummary: Hi, I have a question about HR Help Desk Infolets. "My HRHD Request Work Time" and "Team HRHD Request Work Time" return no data and I am trying to understand wh… -
Bold letters are not showing in PDF OutputHi , We are facing an issue while generating PDF outputs for BI Publisher (BIP) reports. When the PDF output is generated using the RTF template, the bold letters in the…
-
Which table are we going to use for Redwood Trading Partner Items?After migrating Trading Partner Items to Redwood, their data now resides in both EGP_TRADING_PARTNER_ITEMS table and EGP_SYSTEM_ITEMS_B table. Is this how it's going to … -
Custom OTBI Dashboard Appears Blank in Redwood ServiceSummary: Hi Team, I have created a custom OTBI dashboard for Service, which contains multiple custom analyses/reports with drill-down functionality to view the underlyin…
-
How to pass date to ESS Job for Oracle BI reportSummary: We have created a report that takes start and end date as mandatory parameters in the format (MM-dd-yyyy). When we run this report from Analytics Catalog page t… -
Audit report from OCISummary: We are currently building an audit report for Oracle Fusion applications that have been migrated to OCI. The report is intended to capture details such as: Logi…
-
FDI configurable account analysis does not have information on receipt accounting transfer ordersSummary: Content (please ensure you mask any confidential information): The FDI configurable account analysis (CAA) seems to exclude transaction details for receipt acco…
-
Application compser smart action- view quote error CX moduleSu Application compser smart action- view quote error CX module Content (please ensure you mask any confidential information): Version (include the version you are using…
-
Building OTBI security role by Subject Area for Oracle Fusion HCMSummary: We have requirement to build security roles by OTBI subject area. Content (please ensure you mask any confidential information): Looking for step by step instru…
-
Vacation ruleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Archive/Unarchive permission to My folders onlySummary: BI Administrator role generally gives archive/Unarchive access to entire catalog. Here the requirement is for few users, we would need archive/Unarchive permiss… -
what are the seeded Reports/Analytics and infolets in Oracle Help Desk?**This post was created as part of a How to Service Request (SR) Release: 11.13.22.07.0 Summary of the question: What are the seeded Reports/Analytics and infolets and d… -
Customization of US 1099 Electronic Media Report - need to add custom parameterWe are working on a customization of the seeded '1099 Electronic Media' BIP Data Model in Oracle Fusion Cloud (Financials - Payables). We copied the seeded data model to…
-
How to Create a Data Set Using a Web Service in Oracle FusionHi Experts, I tried to create a data set in BI Publisher using a web service that returns valid XML data. I referred to this document: Creating a Data Set Using a Web Se… -
Users can only see their own Expense Reports in Expense Transactions Real Time Subject Area?I am trying to use the Expenses - Expense Transactions Real Time Subject Area in OTBI to create an Expense Report item lookup tool. Users would like to be able to search… -
Oracle Fusion Service Redwood: Unable to create a Metric Card for Unassigned Service RequestsSummary: We are trying to add a Redwood metric card on the Service Home page for Unassigned Service Requests in Oracle Fusion Service. The desired behavior is similar to…
-
i am getting error when i used subject area "Dim - Debtor AR" in OAC analytics- we hetting this error when we run the report : Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P Error during query processing (SQLExecDirect…
-
how to create custom roles and what are the common privileges need to add to run and publish reportsHi Team, What are the common privileges and roles required or to created a custom role to open reports in BI Publisher and scheduled new process AP Multiperiod Accountin…
-
Is there any OTBI subject area that provides the distribution-level Purchase Order Number?Hi Everyone, We are using the Payables Invoices - Transactions Real Time subject area. We noticed that the Invoice Line Purchase Order column is returning the correct PO…
-
"CRM/Help Desk - Inbound Messages Real Time" does not contain HDR reference numberWe need to know which emails were not delivered back to the Helpdesk, as bounce back emails -undeliverable messages are not being received (HDR are not updated automatic…
-
BI Publisher Excel Template Pivot Table Not Refreshing Automatically in OutputHi Everyone, I have developed an Excel-based BI Publisher template (.xls) in Oracle Fusion. The workbook contains two sheets: Detailed GL Transactions: This sheet is pop…
-
How to address Oracle BIP report performance for Oracle finance dataset when data volume is growingWe have simple oracle account analysis report that pulls the data from from GL JE batches , GL JE headers and GL JE Lines. Our financial data is growing at unprecedented…
-
FDI project costing -- inventory item description duplicated with internal reference numberIn Oracle Fusion Data Intelligence (FDI) in the Project Costing subject area, inventory item descriptions are duplicated showing once with the correct description and on…
-
26B FRS REPORTS - EXCEL OUTPUT SPLITS IN MULTIPLE WORKSHEETS IN A SINGLE WORKBOOKThis is happening in our lower environment during 26B. We noticed an issue where FRS reports output from excel are splitting into multiple tabs. Before, the output was i…