OTBI
Discussion List
-
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 41 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 61 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 275 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 12 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 698 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 HistoryRohit Lohani 21 views 0 comments 0 points Most recent by Rohit Lohani Reporting and Analytics for ERP -
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… -
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 51 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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 43 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. 752 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 355 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Receivables Source Missing in OTBI Payables Transactions Real Time Despite Appearing in Manage InvoiSummary: In Oracle Fusion OTBI, I’m trying to build a report using the Payables - Transactions Real Time subject area to track refund-related invoices. The report needs …Sejal Mehta 11 views 0 comments 0 points Most recent by Sejal Mehta Payables, Payments & Cash Management -
How to adjust the alignment of output messages within the OTBI dashboard reports?Summary: Hi Team, Could you please advise on how to adjust the alignment of output messages within the dashboard reports? I’ve attached a screenshot below for your refer…Saras Mudliyar 12 views 0 comments 0 points Most recent by Saras Mudliyar Reporting and Analytics for HCM -
"Go Noto" Font Used in PDF OutputRegarding the default "Go Noto" font used in PDF reports generated by BI Publisher or OTBI, could you please let me know whether the font available for download from the… -
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed…Sushan Peiris 581 views 8 comments 0 points Most recent by User_K7YG4 Reporting and Analytics for ERP -
fnd_sessions has rows with last_connect that is after the employee last logged inSummary: We are trying to build a report to show who logged in that day. If a person logged in multiple times, we need to report the last time user logged in. Person 464… -
Looking for Questionnaire Question / Check-In Questionnaire manager and worker response textI’m currently working on building an OTBI report to extract “Questionnaire Question” responses from the Workforce Performance – Performance Rating Real Time subject area… -
Create sequential number for each row in OTBIneed help generate a sequential number for each row when we run or open Result in OTBI.Peter Obong 11 views 3 comments 0 points Most recent by Massimo D.-Oracle Reporting and Analytics for SCM -
Scheduled Work Order Traveler print process causing duplications on shop floorWe currently have an ESS job scheduled to run every hour to print all work orders in the "Released" status. The problem we are having is that it will print duplicates if…