OTBI
Discussion List
-
Traversing Department Tree in Reports with a ParameterSummary The ability to use one parameter in an otbi report for the department hierarchy as opposed to the multiple levels of departments being handled individuallyConten…User_2025-01-25-00-51-33-059 145 views 8 comments 1 point Most recent by fareed basha Reporting and Analytics for HCM -
OTBI Custom Prompt for Company Fiscal Period, Quarter, and YearSummary: We have a need to report out on our fiscal calendar dates vs. the standard out of box calendar month dates. I was hoping there was a way to set-up our own fisca…CGardner01 15 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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.…Chris Diltz-Oracle 21 views 2 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
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…b nightingale 12 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
OTBI subject area - Attribute to get the no. of Hours spent on each learning itemSummary: Hi Team, We need OTBI subject area and attribute details to fetch the no. of hours spent on each learning item. Content (required): Version (include the version… -
How to include fields in the bell/email notifications?Summary: In external learning requests, there is a field to include the course URL. I would like to include this field in the notifications that come to the bell/email: … -
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… -
Need Guidance on Mapping Employee Numbers in OTBI Expense-to-Payables ReportingSummary: We have developed an OTBI report using the Payables subject area to retrieve invoices imported from Expenses and to track the payment status of those expense-re…Sai Ambareesh D 2 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is there a way to trigger an atom feed event when using spreadsheet loader?Summary: When we do position updates via Spreadsheet loader, there doesn't seem to be an atom feed event triggered. Is there a way to achieve that? Content (please ensur…Stella Kaszab 12 views 4 comments 0 points Most recent by Stella Kaszab Reporting and Analytics for HCM -
Organization Hierarchy in OTBI missing peopleSummary: Hello, We have updated our org tree on 01/01/2026 and we noticed that when we are adding a field from the 'Organization Hierarchy' subject area catalog folder, … -
Expenditure Type Details for OTL Timecards not traceable in BIP Reports.We are trying to extract timecard details for employees in BIP Report with major components as timecard measures, project, task and expenditure type. We are able to abst… -
AR Invoice Email Delivery with AttachmentHi I am attempting to send an Accounts Receivable (AR) invoice with an attachment to a customer via email. I followed all the steps outlined in Document ID: KB92757, and… -
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… -
Learning Outcomes Skills in OTBII am trying to create an OTBI report that retrieves the skills associated with learning items. Within the Workforce Learning - Learning Management subject area, there is… -
CRM Interactions Message ContentSummary: Very excited to see the enhancement to the CRM - CRM Interactions Real Time subject area in the 26A update. I can now see the subject and message content in OTB…Amanda McAfee 11 views 7 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Case Management Reports / DashboardsSummary: Hello All, We would appreciate the community’s support in sharing or pointing us to any existing or delivered case management or HelpDesk reports or dashboards …Chandramouli Yangareddy 88 views 7 comments 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
On hand quantity with null is not appearing on the OTBI pageHi Community Need help on below - @Yann Consolin-Oracle @Lynn Warneka-Oracle @Adnan Siddiqui-Oracle@Shyam Patel @Victor Martin In OTBI (subject area: Inventory Balance R… -
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/…Matthew - Town of Aurora 11 views 2 comments 0 points Most recent by Matthew - Town of Aurora Reporting and Analytics for ERP -
What table to query for Individual Balance adjustments in PayrollSummary: Hi, I am looking for the table in OTBI that can be used to query any manually keyed Individual Balance Adjustments. If anyone has an SQL, it would also be great…Bonnie Lafferty 373 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Oracle Recruiting Cloud – Talent and Candidate Pool (Pool entry date)Summary: Hi Experts, We urgently need Global Talent Pool and Candidate Pools reporting in Oracle Recruiting Cloud (ORC) to meet business demands. I would appreciate clar… -
EBSR12 : Purchasing columns mapping issueSummary: Trying to map EBSR12 Purchase tables »Fusion Cloud (PO/POR) EBSR12 EBSR12-Column Name po_cwk_associations status po_headers_all closed_code org_id po_line_locat… -
R12Table/HCM/FND & AP Approvals mapping issueSummary: How it is mapped on oracle fusion Cloud R12Table/HCM/FND : wf_item_activity_statuses Columns: CTIVITY_STATUS ASSIGNED_USER BEGIN_DATE END_DATE & R12TABLE: AP_in… -
Can we report on when Learning and Evaluations are accessed?Summary: We are thinking about using the Oracle Mobile App, can we report on when Learning and Evaluations are accessed in OTBI? Content (please ensure you mask any conf… -
TRC Code in Time cardsSummary: Can you please suggest how to get the TRC codes associated with the time card and the identifier field.Pratyusha Koduri 21 views 0 comments 0 points Most recent by Pratyusha Koduri Reporting and Analytics for HCM