OTBI
Discussion List
-
Action link for learningSummary: Need guidance to create action link for course learning report. I have made a learning report where course related columns are present, e.g. learning item name,… -
Performance Calibration Module data in OTBI?What Subject Area is this data stored in? I'm specifically trying to extract the Calibrated rating. I've found all other data in our module setup with the exception of t…tim.glasheen_1073872 31 views 4 comments 0 points Most recent by tim.glasheen_1073872 Reporting and Analytics for HCM -
How to Create a Report for Approval/Reject Notifications in Fusion?Hi Everyone, We have a requirement to generate a report for all email notifications sent from Oracle Fusion for Approval or Rejection actions. The report should include … -
Dynamic Date Prompts and SQL Setup for OTBI Workforce ReportSummary: Assistance needed with creating a dynamic OTBI report that allows users to enter date ranges for Assignment Details Effective Start Date and Assignment Details …ReiV 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Reporting "Additional Address Attribute 1" on OTBISummary Fields don't appear on the relevant subject areaContent Hi. I have aligned my country's geography and i have several address elements that i save on the fields: … -
DFF UniqIDSummary: Hi Team, tESTInstance/hcmRestApi/resources/11.13.18.05/recruitingUICreateOrUpdateJobOffers/{OfferId}/child/additionalInformationDetails/{additionalInformationDe… -
In Fusion Projects DashboardHello All, In Fusion Projects, under Project Performance dashboard, is there a way i can show the PO dates (if they are late). For example under each of the Project, Tas…Vishnuvarth Subramanian-Oracle 1 view 1 comment 0 points Most recent by Andy May-Coates-Oracle Project Management -
Adding Learning Comments to Criteria is causing my analysis to fail to process ResultsSummary: I have a report using Workforce Learning - Learning Records Real Time that works until I add "Evaluation Questionnaire"."Answer Comments" to the Criteria. Then …Sherie Ross 42 views 3 comments 0 points Most recent by Narula Shray Reporting and Analytics for HCM -
How to get all the Queues & Resources assigned dates for a Service request in OTBI Analytics reportSummary: Hi Team, As per the requirement, we need to create reports with the list of resources assigned to the SR with the assigned dates and the same for Queues. Could …Nikhil_Samudrala 62 views 4 comments 0 points Most recent by Nikhil_Samudrala Reporting & Analytics for Fusion Service -
Information on scheduled processesSummary: How to get information what schedule process are scheduled through BI Report. With specific fields Content (please ensure you mask any confidential information)… -
OTBI Report: Missing Seniority, Entitlement, and Vacation BalanceI’m building the Employee Vacation and Sick Leave Balance Report in OTBI with the following filters: Assignment Status is in Active – No Payroll, Active – Payroll Eligib… -
How to Get XLE_LE_ADD_INFO in HCM OTBI Subject Area?Summary We have a DFF with module Legal Entities and the Legal entity GL code has been created on Attribite1 of XLE_LE_ADD_INFO FlexfieldContent Hello Friends, We have a…Mansur Khalil 274 views 10 comments 3 points Most recent by Javier Miranda Reporting and Analytics for HCM -
HCM Table for Transaction Audit Trail DataHello, how are you? I would like to know in which HCM table the audit trail from Diagnostic Log data of a transaction can be found. I tried the HRC_TXN_HEADER table, but…LeonardoNogueira 11 views 2 comments 0 points Most recent by LeonardoNogueira Reporting and Analytics for HCM -
Are Price List Approvers' details available for reporting in Fusion?Summary: Looking for table names to fetch approval history in a report for Price List Approvals Content (please ensure you mask any confidential information): Hi All, We… -
How to Query Work Order Picks Pick Confirmed with zero QuantityWe are using Oracle discrete work order Picks. There are situations where a pick is created but picker does not find the quantity in the bin due to inventory issues. Pic… -
Where are Social Security Wages in OTBI?I'm trying to report on information from W-2s, specifically the Social Security Wages from box 3 in the W-2. Where do we find that information in OTBI, specifically Soci… -
User Adoption Insights - Preconfigured Sample Reports in OTBISummary Sample reports for user adoption insights in OTBI are available with attached .catalog fileContent Oracle CX Sales has received requests to provide pre-configure…Greg Rice-Oracle 687 views 13 comments 9 points Most recent by Navin Jose-Oracle Reporting & Analytics for Sales -
Seeded report for ESS Job/BIP Reports running historyDoes Oracle has any seeded BIP reports or OTBI subject area to see below 1. ESS Jobs History 2. Scheduled BIP Report History -
Constructing Deep Link to the Accounts Receivables Invoices PageHi All Can someone please assist, I've written an Account Receivables OTBI report to look at invoices. I'm now trying to add a deep link so that I can drill down from th… -
How to give access to Learning reports onlyHello, Do you know if there are any privileges/ duties for Learning reports? We have couple of users (HRBPs) who need to see how many employees completed a specific cour… -
Is there a report to monitor Microsoft outlook notification send to learners and instructors?Summary: To monitor the MS outlook notifications for learners and instructors Content (please ensure you mask any confidential information): A report that can provide de… -
Payroll - Personal Payment Details Real Time gives an errorSummary: Hi Everyone, Currently, I'm working on the "Payroll - Personal Payment Details Real Time" Subject Area. when I'm trying to add employee bank details, it gives m…Saher 52 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Tracking User Role Assignments in Oracle Fusion: Standard Reports and Audit Log CapabilitiesSummary: In Oracle Fusion Applications (not limited to Sales Cloud), is there a standard way or report available to retrieve a list of all users along with their assigne…Abhijit N 139 views 3 comments 0 points Most recent by HD - Fusion ERP-Oracle Reporting & Analytics for Sales -
PVO BankAccountExtractPVO returns bank account data in OTBI - Issue SQL but no data via BICCNeed to identify missing privilege or profile. PVO FscmTopModelAM.FinExtractAM.CeBiccExtractAM.BankAccountExtractPVO not returning data via BICC. In Fusion > Tools > Rep…Stéphane Lamy-Bouchard 45 views 2 comments 0 points Most recent by fusionenthu Reporting and Analytics for ERP -
OTBI analysis about Learning CommunitiesSummary: OTBI analysis about Learning Communities Content (please ensure you mask any confidential information): Hello experts, we need to create reports about the learn… -
What report to be used to take unaccounted transactions in AR in oracle fusion?Hi, What report can be used to verify unaccounted transactions in oracle fusion Accounts Receivable Module. Regards, Selvi P -
Add a Column with a Static Value in OTBISummary Trying to add the same value to all records, i.e. add a dummy column that holds a static fieldContent In OTBI, I need to add a column to a report that doesn't ne…Lisa G. 740 views 6 comments 0 points Most recent by Alex Pagliarini - Ninecon Reporting and Analytics for HCM -
R23 HCM OTBI subject areas to database tables mapping spreadsheetsSummary: I am looking for the R23 HCM OTBI subject areas to database tables mapping spreadsheets. I am looking for the educational major and name fields in the Skills an…User_2025-10-31-00-42-31-597 269 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM