OTBI
Discussion List
-
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.5K 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 71 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 123 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 reportThere was an error rendering this rich post.Shanna Oppenheim 31 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 185 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 23 views 1 comment 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM -
Document Sequence category Expense Report vs Payment Request (Document Sequence Category Name)Summary: I am configuring the "Document Sequence" for the Expenses module. Under the Assigment section, I see two categories : "Expense Report Invoices" and "Payment Req… -
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 61 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… -
Procurement - Purchasing Real Time project DFF missing after 24B updateSummary: Procurement - Purchasing Real Time project DFF missing after 24B update. This was working fine before the update. Did this get removed from the subject area? Co…MichelleHaynes 11 views 2 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP -
DFF on "Issue and Return Materials from Inventory" ScreenHi Gurus, Is there any way we can create a DFF on Issue and Return Materials from Inventory in Maintenance Module in Oracle fusion. Need to capture couple of additional …