OTBI
Discussion List
-
Base table - Email Notifications Workflow approvalsContent Hi, I am looking for a table that holds emails sent out of the workflow mailer. I am specifically looking for details such as Transaction/Task id along with an e…Sriharsha Devraj 706 views 2 comments 0 points Most recent by User_AOTJG Reporting and Analytics for HCM -
OTBI Subject area for Candidate Extra Internal InfoSummary OTBI Subject area for Candidate Extra Internal InfoContent Hello team, I'm looking for OTBI subject area for Candidate job application extra internal info. Thank…Santhosh Bachu 453 views 20 comments 0 points Most recent by Denise Izzi Reporting and Analytics for HCM -
📄 OTBI Report to Generate HDL File for Deleting Feedback RequestsSummary: This provides a custom OTBI report built on the Workforce Performance – Requested Feedback subject area. It helps companies generate HDL-formatted data to delet… -
Does exist an official/unofficial presentation for OTBI reporting training?Summary: Looking for OTBI reporting training presentations. Content (please ensure you mask any confidential information): I need to teach the customer how to use OTBI r…Stefano_Mazzocca 26 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Help Desk Data only role for access to reporting for HR Service Requests and Knowledge ManagementSummary: I am trying to provide access to a Help Desk and Knowledge dashboard for users that cannot access the Help Desk and Knowledge modules. The subject areas that th… -
Processing Bar Not Visible During Report Generation – Needs Left Alignment or Fixed PositionSummary: When running a wide report, the Processing bar appears centered on the report, making it not visible unless the user scrolls horizontally. This causes confusion… -
Capability to add CSP Progression Comments in OTBI analysisHi All, Currently, it is possible for a recruiter to add the comments while moving a candidate to different phase / state. The comments are visible in Progress tab under…PranitSawant 15 views 2 comments 0 points Most recent by PranitSawant Reporting and Analytics for HCM -
Payroll OTBI with Balance Definitions, Names, Feeds and Element names with Input Value NamesSummary We have a Balance Name called Net Pay with a Balance feed of multiple combinations of Elements and Input Value Names but I cannot find this relationship in the m…
-
How to join Transaction ID with Assignment IdentifierSummary: We are trying to join "Compensation - Individual Compensation Real Time" with "Human Capital Management - Approval Notification Archive Real Time". This is so t…Michelle Hughes 27 views 8 comments 1 point Most recent by Michelle Hughes Reporting and Analytics for HCM
-
HCM Alert Employment DFFHi Gurus, We have a termination Alert Configured using HCM Alerts where we send notification to all HRBPs for employee who got terminated one day prior. The alert is wor…Debasish Saha 26 views 1 comment 0 points Most recent by Tamilarasan Sekar Reporting and Analytics for HCM
-
OTBI Report isn't showing all employees' dataSummary: OTBI Report isn't showing all employees' data. shows only Person number and name. Content (please ensure you mask any confidential information): When creating O…
-
Is it possible to embed OTBI report and BIP report in one dashboard?Summary: Hello, I would like to confirm if it is possible to embed OTBI report and BIP report in one dashboard wherein both reports share with the same dashboard prompt?…Hazel De Castro 722 views 24 comments 0 points Most recent by Yves Chassein Reporting and Analytics for HCM
-
Subject Area for Question in Question LibrarySummary: Hi Experts, I am trying to look for OTBI subjects areas for reporting on question which are present in Question Library. Main focus of reporting would be time o…Saurabh Pratap Singh 217 views 10 comments 0 points Most recent by K Trubenbacher Reporting and Analytics for HCM -
How to get average years of service by company and gender in OTBI?Summary: I need to create an OTBI report to calculate years of service by company and gender. Content (please ensure you mask any confidential information): This is my s…Stefano_Mazzocca 36 views 7 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
BIP Parameters Not Working Correctly with SQL in Data Model and ReportHi all, I'm hoping someone can possibly take a look and help me out with an issue we're having with our BIP Data Model and SQL. We're needing to build an OTBI based repo…
-
OTBI Logical SQL complex query assembler - NOW 10 subject Areashttps://us.v-cdn.net/6034893/uploads/IRBUUHV044EZ/logical-sql-assembler-v5.xlsx Summary Now updated - Combine analyses from up to 10 different subject areas (V4) Content…Maxime Pignot-Oracle 1.6K views 14 comments 15 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM -
Birthday In Next 7 Days (Birthday THIS WEEK)Summary: Could someone please share an OTBI Birthday report that can be scheduled to run every Monday, showing Birthdays that week (Monday thru Sunday). For example, whe…
-
Tables Containing Approval History with Approver Names and Statuses in Oracle HCMHi! Which tables contain the information from the Approval History section, including the names of the approvers and their statuses? Do you have an example query?LeonardoNogueira 28 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Absences created in Advanced modeSummary: It appears that the OTBI report splits out absences created in Advanced Mode onto separate lines by work week but gives the total absence duration for the leave…Stephen Jones 81 views 3 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM
-
Absence Detail AnalysisSummary: I'm looking to create an analysis which will show a detailed list of all absence entries in our system. I've created the following using Workforce Management - … -
Pending Action Items ReportSummary: I am attempting to create a report of all current pending action items in our system in OTBI. However, I seem to only be receiving completed action items and no…User_2025-02-11-20-55-10-551 469 views 8 comments 1 point Most recent by Sanskriti Gupta Reporting and Analytics for HCM -
when I scheduled OTBI report through agent it's failingSummary: Hi Team, when I scheduled OTBI report through agent it's failing. Thanks, Ajay Content (required): Version (include the version you are using, if applicable): C…AjayKumar Maddipati 103 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Rate in OTBI Report displays as double the amountSummary: Rate in OTBI Report displays as double the amount Content (required): I created an OTBI analysis report to display information related to the salary history qui…Nick Henderson 136 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI Report: Accrual Balance Based on Effective DateHello Experts, We have a requirement to extract accrual balance details using an OTBI report based on an effective date parameter. This effective date should be compared…Vasanthakumar Ravi 83 views 4 comments 1 point Most recent by Swapna Govind Reporting and Analytics for HCM -
Creating a report to show those exempt from Federal Income TaxI have a requirement to build a report that shows those who are exempt from federal income tax. I have searched through subject areas and data lineage and I can't find a…Sean-B-01 10 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How can we identify the columns for Employee comments and manager comments in the OTBI Report?The issue we're facing is that we are unable to locate the columns for employee comments and manager comments in the OTBI subject areas in order to retrieve the accurate…Vikas V. Kamat 106 views 3 comments 0 points Most recent by Thulasi Ram Reporting and Analytics for HCM
-
Analysis showing projected absence accrual at year endSummary: Hi We have a periodic accrual scheme for annual leave which accrues monthly at the month end. However we give our employees their entitlement up front (e.g. Mr …
-
icp sortingHi, I am trying to sort the icp column so that the recurring records comes first and with in recurring records the latest records comes first and after recurring the non…
-
How to create report on employee project manager ?Summary: Hello, For our Blue Collar Population we are using the role of Project manager in addition to the Line Manager. Our issue is that we don't find the subject area…LucieWS 26 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM