OTBI
Discussion List
-
What is the impact of General Ledger Segment Security on OTBI reportsOracle document 2486655.1 refers to a document which state in Page 26 he operator "Is last descendant of" is not currently supported for Segment Security Conditions in O…ramesh.sivapalan 41 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
EIT Field value is not displaying in OTBI-AnalysisContent Hello Community, We have created an Analysis in OTBI, with simple fields from the "Workforce Management - Worker Assignment Real Time" subject area, which work v…User_2025-02-05-16-57-43-236 35 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Is there a standard report for Work ConfirmationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
OTBI icon with starSummary: Regards Oriana Content (please ensure you mask any confidential information): Hello experts, does anyone know what this icon refer to? I basically have an otbi …Oriana L. 23 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Benefit & Pension Calculation Card HistoryIs there an analysis or report that shows the history of a calculation card? I have an employee who was enrolled in main LGPS scheme up to 30 September 2023 but as of 1 … -
enable password to custom OTBI Text FileSummary: Dear, Customer request to enable in custom Report password security, as following User Run the Custom Text File Report User Download the File to Open that file …Mostafa Yassin 1 view 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Project receivable invoices payment statusIs there any analysis or OTBI subject area that can help in tracking the Project AR invoices status based on the applied amount. the image below is captured from the man…Mohamed Abdelbar 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
BI Publishing: bursting without attachmentsSummary Bursting to selected people, without attachmentContent Hi all, I am trying to use BI Publishing to burst an email to colleagues who have handed in their notice. …User_2025-01-31-17-49-32-187 1.6K views 10 comments 4 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Learning Enrollment status blank in OTBISummary: Content (please ensure you mask any confidential information): Hello Experts, we are trying to create an OTBI report with the Subject area: Learning record real… -
Report output to send in Team channelSummary: Do anyone know if a report output can be transmitted to a MS team channel? Content (please ensure you mask any confidential information): Version (include the v… -
How to export 500K rows from OTBI report into ExcelSummary: We have a report where total data is coming close to 500K and we are only able to export 25K in Excel, is there is any way to do this? If I develop this in BI P…Sam Samaddar 72 views 4 comments 0 points Most recent by Sam Samaddar Reporting and Analytics for ERP -
OTBI report for salary basis history exampleSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample OTBI report tracking the employee salary basis history with a…Valerio Curzi 137 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Payroll Data to Transaction DetailsHello I am looking to create a report that shows pay element details linked to the transaction data. We issue Special Payment to several of our employees. When it is ent… -
Is there a simple way to create a report based on Service request, Work Order and Debrief?we are working to create a report that will include information from the Service request and all the work that was done by the engineer. the entity structure we need (or…Boaz Hayon-Oracle 2 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
How to query the Configure requisitioning business function setup?Summary: I need to extract information from this Page in Oracle Fusion using a Data Model in OTBI, I couldn't find the tables related to this page, I need to extract "Sh… -
Person id equals to 0 using the Person Profile Real time subject areaSummary: Person id equals to 0 using the Person Profile Real time subject area Content (please ensure you mask any confidential information): Hi experts, we are facing t…Oriana L. 21 views 5 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Talent Ratings - OTBI ReportContent Hello! Can anyone tell me where the Talent Ratings are stored so that I may report on them? Please see screenshot attached. I'm looking in the "Workforce Talent … -
Remove Edit Capability from the Reports Shared Folder but Retain Edit Capability in the My FolderSummary: We are trying to update report permissions to remove the edit capability from the shared folder but retain the ability to edit in reports in My Folder. We have …G. Class-Peters 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Unable to see newly created elements in OTBI reportSummary: I am using the attached report and am able to see elements on employees/pending workers. We recently created some new elements, and I can't get them to pull eve…Shanna Oppenheim 32 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Table Name and Column name required error while writing a CASE Function in OTBI AnalysisSummary: Requirement is to populate the data in a EFF attribute column based on the other column in OTBI analysis. Trying to get condition establish using CASE function.…sudheer.movva 182 views 5 comments 0 points Most recent by Sam Samaddar Product Master Data Management -
Adding Total Headcount and Response Percentage Columns in OTBI ReportHi Community, I am working on an OTBI report that aggregate responses from employees related to their self-identification. Current Setup: The report currently includes c…Ashok Kumar Sharma 22 views 1 comment 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM -
V3 Seniority Dates in OTBISummary How to report on V3 dates in OTBIContent Hello, We're migrating to the V3 seniority dates with the release of 20B, but we're running into a number of reporting i…Whitney Van Way 103 views 8 comments 1 point Most recent by THawkins_LGI Reporting and Analytics for HCM -
Absence Plan Balance (as of Date) in ReportSummary Absence Plan Balance (as of Date) in ReportContent Hi All I need to display the Absence plan balance of an employee as of certain date in Report. For example whe…Shabrawi 294 views 6 comments 1 point Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
-
Associating the reconciliation history table with system transactionsIn the CE_RECON_HISTORY_ITEMS table stores the bank statements reconcile record. The field RECON_SOURCE shows where the matching item comes from. And I believe field SOU…July_Yanlin 72 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management -
Year over year disability disclosure reportsOur requirement is to provide a report and graph with year over year counts of disability self disclosures. Attached is an xml version of my report. I'm joining the Work…Jenna Fuchs 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Identifying duplicate emailsSummary: An analysis that highlights the same emails being registrered to multiple persons Content (please ensure you mask any confidential information): I need an OTBI … -
Duplicate data for employees Worker Assignment Real Time & Employment Contract Real TimeSummary: We have an analysis to fetch the full staff list. Recently, we have updated some position with new departments and parent positions due to organization restruct…