OTBI
Discussion List
-
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 856 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 71 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 15 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 100 views 2 comments 0 points Most recent by CS Yuen-Oracle Reporting and Analytics for HCM
-
Capture in OTBI the Attachment field in a Person Profile Real Time subject areaSummary: Content (please ensure you mask any confidential information): hi there, There is a field "Attachment" out of the box field at the bottom of the Talent Profile …Bobby Jourdan 11 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Generate a count of employee self service requests for certain employee data fieldsSummary: Is there a way in OTBI to generate a count of the number of times an employee changed personal information data in self-service over a period of time? My unders…
-
Absence Management - Leave Donation RecipientsSummary: We unable to find new subject area in 24D released version in S1 and S2. Subject Area Name — Absence Management - Leave Donation Recipients Could you please pro…Anup Karmankar 1 view 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Did User System Usage SA changeSummary: I had a simple analysis to pull last activity date and it's not working. Has the User System Usage SA changed recently? Content (please ensure you mask any conf…David Boudreau 11 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Fetching Job Requisition with Sensitive Information in OTBIHi Team, We are fetching job requisition details from OTBI in the Recruiting - Recruiting Real-Time subject area. However, we also need to retrieve additional candidate-…Jeeva - Cloud Vantage 12 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Analysis to catch employee with department chageSummary: We need to create a analysis that will be used to populate a Learning Initiative. some subjected area has historical data, like "Compensation - Workforce Assign…Lucas B Maciel 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to report on "Job Description" from "Job Profile"Summary: I need to report on job description and effective start/end date within each job [model] profile, but i can't seem to find it from BI. I tried to query few tabl…
-
OTBI Report Subject Area for Document Delivery PreferenceSummary OTBI Report Subject Area for Document Delivery PreferenceContent I'm looking for a subject area that fetches the document delivery preference fields. Back end ta…Rajesh Kumar Bhagtani 238 views 12 comments 2 points Most recent by gclampitt Reporting and Analytics for HCM
-
Recently updated data in an Org Tree is not displayed in OTBI reportsSummary: In mid December, I created about 20 new departments and tied them to existing Divisions in an Organization Tree. The departments were created with a 1/1/25 effe…
-
Sql query to get cost code effective start date and effective end dateSummary: Sql query to get cost code effective start date and effective end date Content (please ensure you mask any confidential information): Version (include the versi…Anup Karmankar 62 views 18 comments 0 points Most recent by Anup Karmankar Reporting and Analytics for HCM
-
adding different manager types to analysis reportsHello there, I have prepared a report from the analysis and in this report I would like to see the types of managers that people are affiliated with, such as head and ex…Sinem Kara 22 views 4 comments 0 points Most recent by Girish Kushibi Reporting and Analytics for HCM
-
Need a report to pull time change request details for time and laborSummary Need a report to pull time change request details along with manager comments for time and laborUser_2025-02-04-07-00-18-658 43 views 3 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
Submitted Timecard and Web Clock Details ReportSummary: Need to SQL query for view the detail of submitted timecard and web clock's reported hours and schedule deviation with custom attribute. Content (please ensure …Melek Cinar 491 views 6 comments 0 points Most recent by Melek Cinar Reporting and Analytics for HCM -
Candidate Drop off ReportSummary: Hi - I am looking for an example candidate drop off report Content (please ensure you mask any confidential information): Version (include the version you are u…
-
How can the seeded compensation dashboards below for managers be customized?Can anybody suggest the right way to edit these seeded dashboards and do the customization based on our company needs. The need is to Add/ remove parameters Add/ remove …Sameeksha MN 13 views 3 comments 0 points Most recent by Sameeksha MN Reporting and Analytics for HCM
-
Position Occupancy ReportHi All, We have noticed that seeded Position Occupancy Report is not working as expected. Incumbent Headcount for all the positions is showing null though there are incu…
-
Logical SQL With Dashboard PromptSummary: Hi - I am trying to build a logical SQL report that displays paycheck information along with current salary as an outer join from Compensation subject area. The…
-
Best Practices: OTBI Compensation - Compensation Stock Details Real Time subject areaSummary: This is part of a series for best practice tips to use in your cloud environments, created by Oracle BI and Product Management. Roles and Privileges Compensatio…Gail Langendorf-Oracle 13 views 1 comment 2 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
To report performance document status related information and rating detailsSummary To report performance document status related information and rating detailsContent Hi , Planning to build a report to show performance document status of a pers…Phani S-Oracle 147 views 7 comments 1 point Most recent by Pavan Kumar Thummalapalli Reporting and Analytics for HCM
-
How to use "Combine results based on union, intersection, and difference operations?Summary: I don't understand how to use it. Whenever I add my 2 subject areas and then the fields, I don't know what to do after that. I need additional fields that are n…
-
Need to get distribution curve to work when count is 0I am trying to create a distribution curve for performance ratings. It looks good when there is a count >0 for each rating but when there is a 0 count for Unsatisfactory…
-
Where can I find the Specialization Description to add to my Specialization_Courses report?I can't find the description field to add to my report using the subject area Learning Records Real Time. Is this field in another subject area? Specialization Descripti…Lisa Marchand 33 views 2 comments 0 points Most recent by Lisa Marchand Reporting and Analytics for HCM
-
Consolidated List of OTBI and BI Publisher Reports Posted (9 December 2014)Content The following is the list of published OTBI and BI Publisher reports between 15 October 2014 and 9 December 2014: * Fusion Benefits: Dashboard for Costs and Tota…Julian Challenger-Oracle 278 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Analysis - How do you select the gross earnings for the max Date Paid per employee?Summary: We are able to get a list of gross earnings for each worker per pay date but we only want to SELECT the gross earnings associated with the max check date (Date …
-
Table / View for New Features and Opt In Features?Summary: Is there a table / view that can be queried via BIP which would allow us to create a report of all of the implemented and non implemented features as seen in th…Monica Fundak 41 views 6 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM