OTBI
Discussion List
-
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 51 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 134 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 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. 739 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 267 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 Started 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 Started 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 572 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 AP Invoice real time is not bringing information when it is the second subject areaSummary: I tried to merge 2 subject areas (Fixed asset and Payables transaction real time). The Fixed Asset information is bringing the right data, but when added the se…Pablo Schenquerman 11 views 2 comments 0 points Most recent by A Lotfy Payables, Payments & Cash Management
-
Link Between Workflow Table (FA_FUSION_SOAINFRA.WFTASK) & quality (ENQ_ISSUES_B) in oracle fusionHi All, we are developing a report to get the Quality Issue approval notification details. We are unable to link the WFTASK to ENQ_ISSUES_B. The WFTASK.IDENTIFICATIONKEY…
-
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…