OTBI
Discussion List
-
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…Clifford Trett 21 views 9 comments 0 points Most recent by Clifford Trett Reporting and Analytics for HCM -
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 267 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 216 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 … -
Assign a course 14 days after the Fusion profile is createdSummary: Content (required): Hi there, we have a bunch of mandatory courses for new joiners. We want the enrollment in some of these courses to be done not on the day th… -
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 145 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to trim leading and trailing spaces in a text fieldSummary: How to trim leading and trailing spaces in a text field Content (required): The use case is to trim leading spaces in "Asset Number" field. When the user enters… -
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 73 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 592 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Fusion OTBI - Structure and Components Real TimeSummary Fusion OTBI - Structure and Components Real Time subject areaContent HI I am trying to do an OTBI Analysis with Structure and Components Real Time subject area t…Angel Espadafor 119 views 3 comments 3 points Most recent by tapan.nayyar Reporting and Analytics for SCM -
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 51 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there a OTBI Subject Area for listing the Movement RequestsSummary: Content (required): We need to get a list of all the Movement Requests along with their status. Is there a OTBI Subject Area for that? Version (include the vers… -
Why doesn't the Costed BOM (Cost Element) report show all the accumulated elements?Summary: The Costed BOM (Cost Element) report does not display all cost elements that were used in rollup. The report shows a total cost of the item of 6123.92119 In the… -
How to grant users access to report that was built using Projects - Performance subject area?Summary: Users are able to access report built using the Projects - Performance Reporting Real Time subject, but not the data that populates the parameters needed to run…Matthew - Town of Aurora 31 views 6 comments 0 points Most recent by Matthew - Town of Aurora Project Management -
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 -
Creating a Report in OTBI for New Hires, Name changes, LOAs, and TerminationsSummary: Hello, I need to create a report in OTBI for New Hires, Name changes, LOAs, and Terminations but I am unsure if this can all be on one report or if I would need…Latia 83 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there any standard report for GRN return ordersSummary: We need a report with GRN return orders with debit and credit records. Content (required): We need a report with GRN return orders with debit and credit records…Soumyasri P 21 views 1 comment 0 points Most recent by Lynn Warneka-Oracle_inactive Inventory Management -
Rehired Employee gets the same due date from her first enrollmentSummary: Content (required): Hi there, We have a few cases in which people who used to be with the company and are rehired, get the same due date of old enrollments from… -
Reporting on Withdrawal Reason if excluded from transcriptSummary: If a person is withdrawn from learning, and the exclude learning from transcript is selected, I understand that the assignment status is changed to 'Deleted'. I… -
Evaluation Report is not shown Answer Text and Comments attached to AnswersSummary: I created an Evaluation Report with following details like Question Text, Answer Text, Response List ShortText, Response Status using Learning Managment Real Ti… -
Ethnicity causing Workforce Trend SA to produce inaccurate headcountWhen adding ethnicity to the Workforce Trend SA it causes the Period Start and End headcount to double/triple for those that have selected two or more races. I have atta…Andrew Mc 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM