OTBI
Discussion List
-
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
-
Schedule Agent to run report last day of each monthSummary cannot select report to be sent on last day of each month.Mike Borghoff 31 views 7 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM
-
How to show Other compensation in the Job offer through OTBISummary: Unable to show Other compensation (Individual Compensation) present in the Job offer in OTBI. Content (required): We are unable to show Other compensation (Indi…Sujay Bhowmick 32 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
We need department and cost center details with effective state date in BI or OTBISummary: Hi Team, we need department and cost center details with effective state date. i tried in worker assignemnet real time but no effective start date. only two clo…AjayKumar Maddipati 31 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
"Number of Job Application changed to..." Code NeededDoes anyone know the code behind the following columns? For example, when viewing the numbers, the highlighted "Number of Job Application changed to Job Offer Phase" fie…