OTBI
Discussion List
-
OTBI: Succession plans report, how can I add the Incumbent person number?Hi all, I have a problem in editing a report on succession plans. I have these columns (Plan ID, Incumbent name, Candidate name, Person number). I want to add a column w…GiovanniD 61 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM -
How to export 'comments' within OTBI Recruiting Real Time - "Job Application - Interview Feedback"Summary: We have a questionnaire that allows for comments (highlighted in picture below) to be manually added within ORC; when we export the questionnaire we cannot find… -
Length of Service CalucationSummary Need to subtract Current Date from Legal Employer Seniority DateContent Does anyone know of a SQL formula to subtract the current date from Legal Employer Senior…Rebekah Gilday 116 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Report - Performance Goals ApprovalSummary: Hello, Does anyone know how to fetch performance goals approval (pending, draft, etc.) using OTBI? Content (required): Does anyone know how to fetch performance…Hazel De Castro 81 views 2 comments 0 points Most recent by Jenna Fuchs Reporting and Analytics for HCM
-
Increase font for Dashboard Link objectSummary: Increase font for Dashboard Link object Content (required): We are developing the report landing page using a dashboard page where we want to link all reports. …Ajit Dani-Oracle 31 views 3 comments 1 point Most recent by Ajit Dani-Oracle Reporting and Analytics for HCM
-
Department EFFHi, From which table can I find the EFF field defined on the department? If you know, can you share? Regards,Cansel Karasoy 61 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Some of employees not showing checklist task name of 30days HR questionarieSummary: Hi Team, we have onboading perosn task list but some of employees have not showing even task name also and task status also. any one assist me on ? that issue s…AjayKumar Maddipati 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Tables available for ConnectionsHi, What are the tables available for "Connections" reporting. Regards, NivyaNivya Mathire 51 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Catalog objects not visible while creating Data model using Oracle BI analysisSummary Catalog objects not visible while creating Data model using Oracle BI analysisContent I am creating a new Data Set using Oracle BI Analysis, when I click on Orac…User_2025-02-03-21-28-21-735 53 views 3 comments 0 points Most recent by David Wright - More4apps Reporting and Analytics for HCM -
Report to show OTBI filters/parametersSummary Report to show OTBI filters/parametersContent Is there a report available, or a way, to pull report filters/parameters out of OTBI analyses to view? I have a lar…User_2025-02-08-04-25-10-086 55 views 4 comments 0 points Most recent by Caroline.E.B. Reporting and Analytics for HCM
-
How to calculate the number of active assignments for a personSummary: Question from a beginner: How can I calculate the number of active assignments for a person to isolate profiles with potential duplicate assignments? Content (r… -
How to add a prompts of From and To date and allow the data to filter by this in OTBI?Summary: How to filter the data to be FROM and TO date on the salary change date. I need a prompt to be used to filter the data for these dates. Thank you. Content (requ…Max W 213 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Within OTBI Job Application - Interview Feedback, how do I separate Interviewer names?Summary: I have two questionnaires - Prescreen and WAH_interview. When I run a report to list which recruiters completed the prescreen guide I get names that completed b…
-
Recruit - report showing candidates at each stageSummary: We want to be able to see at a glance, each requisition and the candidates from that req and what stage they are at Content (required): See example Version (inc…Emily Robinson 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Report unable to generate employment information prior to 2020Summary: We have an employee department dashboard which majority of our users run on a daily basis. This dashboard has prompts to support the kind of data that the user …
-
Cost Center Data not pulling in Workforce ManagementSummary: Content (required): Our reporting team have been trying to add Cost Center to numerous reports and as yet have had no luck. This current report attached, is loo… -
Data PurgeSummary: Hi Team, Could we get the list of dependent components which will be purged when we select particular object in "Data Purge" Example: if Payroll is selected in …
-
Is there a table to find the size of files uploaded on Documents of Records?Summary: Is there a table to find the size of files uploaded on Documents of Records? Content (required): Version (include the version you are using, if applicable): Cod…PrafullMadhur 31 views 2 comments 0 points Most recent by PrafullMadhur Reporting and Analytics for HCM
-
Seeded list of action and action reasons for HCMSummary Need a seeded list of action and action reasons in HCMContent Hello Everyone, Hope you all are safe and healthy. I need a list of seeded action and action reason…Akanksha Jain 265 views 3 comments 0 points Most recent by Stefan v. Glabbeek Reporting and Analytics for HCM
-
OTBI report to pull out Position/Department Historical data with effective dates.Content Hello All, I have a requirement to pull out all the data related to Position/Department from the day of creation. I have tried to pull out the data using the sub…User_2025-01-25-06-20-12-259 217 views 7 comments 0 points Most recent by SravanthiCh Reporting and Analytics for HCM
-
Assignment Row Created BySummary: Has anyone found a creative way to report on who created a row? Content (required): We are not looking for 'Last Updated By' (as that often shows who end dated … -
How to use Calendar chart in OTBI analysisSummary: I am using Detailed Calendar Report in OTBI analysis. I want to present the vacations using Calendar chart. I got one link in oracle community. but in calendar …Sudipta007 131 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can we create a Reporting Tile as a shortcut to access OTBI reports?Summary: In OTBI, is it possible to create a Reports Tile or link for managers and HR staff so there is a shortcut to access reports? It is a lot to sort through and has…Emily Wilde 71 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Agent - Promoted ParameterContent Hello all, As you help me a lot before, I would appreciate your advice. We build a DB. Combine few report: New Hires & Terminated employees. The BU is prompted. …
-
Oracle table name containing employment category informationHi, I need a list of cost center information defined in the system, can you share the table containing this information with me? I find the cost center information assig…Cansel Karasoy 574 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
OTBI : Line Managers not retrieved in Workforce Management - Workforce Trend Real Time Subject AreaSummary: We are creating a dashboard which shows attrition rate based on different aspects like country, departments, etc. We were fetching the query from OTBI analysis …Rohankumar Patel 41 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Subject Area/SQL to fetch HCM Approval Delegation detailsContent Hi, Does anyone know the OTBI subject area/Table names which can fetch the details of HCM Approval delegation in Person's Account Management page. Best Regards D…
-
Goal Task detailsHi, Which Table or subject area contains goal task details? Regards, NivyaNivya Mathire 31 views 5 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Data issue- OTBI AnalysisSummary: We have an OTBI analysis to capture benefit details and I noticed that it's providing information for one legal entity although are three legal entities added i…Ayesha Iroshani 41 views 13 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM