OTBI
Discussion List
-
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 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… -
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 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 42 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. 751 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 313 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 11 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 571 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…
-
OTBI reports for talent review doesn't work with custom objectsSummary: Content (please ensure you mask any confidential information): Hello experts, we created OTBI dashboards for talent review and we enabled filter by talent revie…Valerio Curzi 11 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
We are trying to obtain a Audit report which captures audit for customer bank account changes.Summary:We are trying to obtain a Audit report which captures audit for customer bank account changes. The business need is to capture the following details for audit: I…
-
How to Get Response Text for Performance Document QuestionnaireSummary: Have a report I pulled from Shared Reports as it gets me closer to what I am trying to pull, but it still leaves a blank in the Response Text section. I am tryi…Aaron Reynolds 31 views 2 comments 0 points Most recent by Maciej Kozakiewicz Reporting and Analytics for HCM -
Counting Questionnaire Responses from Performance DocumentSummary: Trying to count the responses to a question within a performance document. Performance is very slow and it's hard to validate the results. Content (please ensur…Rob F 41 views 3 comments 0 points Most recent by Maciej Kozakiewicz Reporting and Analytics for HCM -
Query for Business Units and Legal Entities mapping for Payables.Summary Need query to fetch Business Units and associated Legal Entities mapping for Payables.Content Hi All, I am having requirement to fetch all the Legal Entities ava…User_SJJQT 7.3K views 5 comments 0 points Most recent by Tejeswar J E Reporting and Analytics for ERP