OTBI
Discussion List
-
OTBI Analysis for Remote Workers and Onsite Associate Work Location State and Postal CodeSummary: We currently have a large population of workers who work remote or their "Work Location" is classified as their home office. Our population of around 18,000 wor…Kayla Malecki 15 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there a way to pull out job offer comments in OTBI?Summary: Is there a way to pull out job offer comments in OTBI? Content (please ensure you mask any confidential information): Hello Experts, We are challenged to pull o…Volodymyr Faranosov 14 views 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
OTBI report returning Lookup codes, how to fetch meaning instead of codesSummary Few Talent profile attributes in OTBI report returning lookup codes.Content Hi, In the Person profile>License and certifications section few fields are lookup ty…Challa Vidyasagar 280 views 3 comments 0 points Most recent by ShivaBildikarMGS Reporting and Analytics for HCM -
Optimizing Infolet Loading Time on the SpringboardHello Community, We’ve designed and implemented multiple infolets for employees, line managers, and HR, placing them on the springboard to provide quick access to releva…Harish Vummidi 12 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Request for Infolet Samples to Enhance User Experience in Core HR, Absence, ORC, OTL, and PayrollHello Community, I’m currently exploring ways to enhance the user experience for employees, line managers, and HR teams in Oracle Cloud by leveraging infolets effectivel…Harish Vummidi 22 views 0 comments 3 points Started by Harish Vummidi Reporting and Analytics for HCM
-
How to have a Batch ID parameter which is present in BIP Report in the Dashboard?Hi , We are creating a dashboard of a BIP Report for our use-case, BIP Report has a parameter called Batch ID with which we will pull the data regarding that batch load.…Sainatha B 21 views 1 comment 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
Payroll - Element Entries History Real Time Assignment ManagerSummary: Payroll - Element Entries History Real Time assignment manager subject area - what to find assignment manager to class employee as direct or Indirect staff Cont…Keith Dunlop 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI report update historyWe have several OTBI reports being updated that are not deployed by our support team. How is the owner updated to System Account? Is there a way to get the audit history…Angela Grace 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to show person data at the time of absence submission in OTBI?Summary: We have a requirement to show the person data at the time of submitting their absences. But the OTBI report brings the latest job name, FTE, department, busines…Ridma Karunanathan 11 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Determine Account date for PAY_COSTS entriesSummary: I am trying to figure out how to get back to the accounting date from each entry in the pay_costs table. We have a need to get this down to the person for some …Jason Snipes 2 views 3 comments 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM -
Calculating Days in Calendar Year on a Suspended StatusSummary: Part of our annual incentive program, we prorate any worker who has been in a Suspended Assignment Status for greater than 90 days in the Calendar Year. Looking…Kayla Malecki 22 views 4 comments 0 points Most recent by Kayla Malecki Reporting and Analytics for HCM
-
Can anyone help with a report to find potential duplicate employeesSummary: We have Contingent Workers who instead of being re hired as Permanent employees against the CWK record, these are being rehired as new employees creating duplic…Laura_Stewart_Sita 13 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Help in query to retrieve Relationship Criteria on Eligibility Profile for BenefitsSummary: Hello! I am currently biulding an query to get all the Eligibility profiles and their criterias. Currently, I am in need to find the table to give me the relati…Matheus Roberto 21 views 1 comment 0 points Most recent by Thiru-Oracle Benefits-Oracle Reporting and Analytics for HCM -
Which table contains the information from Manage Legal Reporting Unit HCM Information ?Summary: Content (please ensure you mask any confidential information): Which table contains the information from Manage Legal Reporting Unit HCM Information? Version (i…OliveiraRR 22 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How do I do a simple SQL to bring the Name, Legal Entity and registration number of the Legal ReportSummary: Content (please ensure you mask any confidential information): How do I do a simple SQL to bring the Name, Legal Entity and registration number of the Legal Rep…OliveiraRR 120 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Performance Document - Current ApproverSummary Need report for who is the current approver of a perfomance documentContent I have the report which shows the Next Performance task status. Which is great, but i…
-
Historic Grade Steps in OTBISummary: I can see a previous grade step and current grade step using the screens, I wish to see the same information using OTBI. Content (required): When I create an An…ScottHillier 84 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How is the Assignment manager List Unsecured populated in OTBI?Summary: I am executing the standard OTBI analysis "Headcount KPI - Female Managers" and I am getting a wrong number of female managers. How is it working? We have 13 fe…B Casla 78 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Projected start date field in OTBI showing incorrect valueThe Projected Start Date in the OTBI Recruiting Real Time subject area doesn't appear to be pulling accurate data. We tried changing time zones but at the end of the day…Vaishnavi Katiyar 47 views 5 comments 0 points Most recent by Chantel Berger Reporting and Analytics for HCM
-
How to create a Bell Curve in OTBI reportSummary: Client team is expecting to show the Performance Rating Distribution results in a Bell curve model as shown in the attached screenshot. Could you please share a…Santhosh Gangishetty 306 views 14 comments 0 points Most recent by Gimhani Perera Reporting and Analytics for HCM
-
Getting merged and blank rows while trying to fetch Performance rating and Salary together in OTBISummary: Hi Peers, I am trying to build an OTBI analysis to fetch both the Performance rating and the Salary. I'm using Compensation - Salary Details Real Time and Workf…
-
Presentation Variable Dashboard Prompt Not Working For KPIsSummary: We created a custom Talent Acquisition Activity Report Dashboard via OTBI and recently added a Presentation Variable prompt for 'Workplace Segment'. The dashboa…Maryellen_Gancena 12 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Assignment Manager (Unsecured) significantly slower in Workforce Performance Subject AreasSummary: Material / significant slowness that appear to be driven by [Assignment Manager (Unsecured)] folder within Workforce Performance Subject Areas, relative to othe…
-
Position DurationSummary Provides the duration of the workers in a specific positionContent This analysis provides the duration(in days) of the workers in all the positions that they hav…Raghavendra Raghunath-Oracle 194 views 6 comments 4 points Most recent by Shannon_Johnson Reporting and Analytics for HCM -
OTBI Dashboard only shows Indirect on promptSummary: OTBI dashboard is only showing Indirect in drop down prompt. Need to be able to choose between Direct and Indirect reports. Content (please ensure you mask any … -
OTBI - Calculate age in years and monthsSummary How to calculate the age in years and months?Content Hi, In OTBI I want to create a column which present the full age of the employee, for example 43.12 (means 4…Yaniv 821 views 18 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
custom report in Thrive that relates to competency assessments within an individual’s profileHi, I am looking to build a custom report in Thrive that relates to competency assessments within an individual’s profile. There doesn’t seem to be a suitable native rep…Chintan Shyara 1 view 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How long applicant is staying in Each PhaseSummary: I want to create OTBI analysis to find out how long an applicant is staying in each phase of a requisition. I tried to use "Phase or State Duration" column from…User_2025-01-28-19-26-47-704 76 views 7 comments 0 points Most recent by Justice Z Reporting and Analytics for HCM -
Some Requisitions Dropped from OTBI Reports after Adding any Data Column that is not HyperlinkedSummary: Some requisitions were dropped from OTBI report after adding a data column that is not hyperlinked. Content (please ensure you mask any confidential information…Kathleen Nguyen 12 views 2 comments 1 point Most recent by Kathleen Nguyen Reporting and Analytics for HCM
-
How to enable Report Job History to BI Consumer in Home page of BI Catalog?Summary: Please refer to the BI Catalog Home page of BI Author and BI Consumer. How to enable also Report Job History link in Home page of BI catalog to BI Consumer? Wha…CS Yuen-Oracle 76 views 2 comments 0 points Most recent by CS Yuen-Oracle Reporting and Analytics for HCM