Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Filter analysis based on results of other fields which were based on a filterContent I created a report that will compare, by benefit, what should have been deducted from an employee's check vs what actually did get deducted. As a result I have t… -
Position OccupancySummary I'm trying to check a position occupancy report as I am not sure it is returni9ng the correct incumbent FTE value and showing staff that have left and are inacti… -
Performance Tile - Changing Totals?Summary Returning to a page with Performance Tiles shows incorrect aggregated values.Content I have a dashboard that has a first, summary page with several KPI/counts as…
-
How to fetch payroll relationship number in OTBI?Summary How to fetch payroll relationship number in OTBI?Content Hello Experts, I have a requirement where to fetch all the assignment details and payroll relationship n…
-
Ranges for Geographic DifferentialsSummary Is it possible to pull a report of salary ranges for Locations that have a geographic differential?Content If possible, what subject area and field should be pul… -
need a table name to get the "Payroll Transfer Status" field in time and laborSummary need a table name to get the "Payroll Transfer Status" field in time and laborContent Hi Team, i am looking for a table to get the "Payroll Transfer Status" fiel…User_2025-02-04-07-00-18-658 166 views 1 comment 0 points Most recent by User_2025-02-04-10-25-07-624
-
Report to fetch all the employees who is missing Home address/ work address using OTBI?Summary Report to fetch all the employees who is missing Home address/ work address using OTBI?Content Hello Experts, I have a requirement where to fetch all the employe…
-
Report on Job Seniority Date by AssignmentSummary Report on Job Seniority Date by Assignment (v3)Content We are in the process of implementing seniority dates, specifically for job by assignment. We believe this… -
What Role i need to get data out of AnalysisSummary What Role i need to get data out of AnalysisContent Hi I have BI Admin / HR Specialist and manager / Application Developer roles. I can write sql on BI report an… -
Joining Batch Processes table and Time Card DetailsSummary I need help with joining the tables associated with Batch Processes and Time Details.Content Hi All, I have a requirement to get the Time Load Batch Id for a tim…User_2025-02-05-06-55-02-399 30 views 2 comments 0 points Most recent by User_2025-02-04-10-25-07-624
-
In Time card entry, where the values like Start Time(9:00 AM) , stop time (5:00 PM) , quantity willSummary In Time card entry, where the values like Start Time(9:00 AM) , stop time (5:00 PM) , quantity will store?Content Hi Team, I am trying to fetch the few columns f…
-
Limitation in fetching balancesSummary Limitation in fetching balancesContent I have a balance group with 50000 balances in it. When this balance group is added to the Extract, it fetches the amounts …
-
Reporting ESS and MSS transactionsSummary Reporting ESS and MSS transactionsContent Is it possible to report on Employee Self Service (ESS) and Manager Self Service (MSS) transactions? What defines a ESS… -
Value Conversion through Mapping sheetSummary Value Conversion through Mapping sheet in OTBI reportContent Hello, I have created a new column in report with the values coming from another column using "Case …
-
Tables Summing Budgets IncorrectlyContent Hello, I'm created some custom columns based on Case When Statements to calculate our budgets. I've tried both of the case statements below, but the column/pivot…
-
Minimum Wage and Salary AuditSummary Is there a report or a way to mark employees as non-compliant with minimum wage and minimum salary.Content Hi, Has any one ever created a minimum wage/salary rep…
-
Reporting Capability for Field HR Reps (OTBI)Summary Need to understand how Reporting (OTBI) capability can easily be issued to field HR reps.Content Hello, We have 55 plants across the U.S. In each plant there is …
-
Compare State column in OTBIContent Hello, We have a requirement to show only those employees whose primary mailing address state is not equal to their work location state. I am able to fetch all t… -
Taleo requisitions data in Fusion OTBISummary How to get Taleo requisitions data in the fusion OTBI subject area (Human Resources - Recruitment)Content Hi We wanted to create a Human resources dashbard in fu… -
OTBI: enabling custom Working/Business Days calendars and/or reporting on Work Patterns in OTBI?Summary OTBI: enabling custom Working/Business Days calendars and/or reporting on Work Patterns in OTBI?Content Hi All, I have a couple of queries around reporting on Wo…
-
Primary FlagSummary What does it actualy do?Content Hi, total N00b here, please bear with me! In our version of Oracle, we've always used five flags (below) in order to get 'active'…
-
Report of employees not in Open EnrolmentSummary Report showing any employees that have not got an Open EnrolmentContent I need to get a report of employees who have not been put into Open enrolment. Our Annual…
-
Dependents Turning 26 Report SchedulingContent Hi All, Our benefits team has a business requirement to have a report generated at the beginning of each quarter that lists all of the dependents who will be tur…
-
Position ManagementContent All - we are implementing Position Management and I have some questions about reporting and hoping you can help direct me. I did search for this information, but… -
What are the various benefit plans to which the workers have enrolled, by various years?Content Looking at the Benefits - Enrollments Real Time subject area's business question it is noted that the subject area has attributes that will answer this question.…
-
Employees & Line Managers without Work EmailSummary We are looking to audit all employees and all managers without a work emailContent Hi all, We are working on some audits and one of the audits we are having some…User_2025-02-05-05-51-12-049 52 views 5 comments 0 points Most recent by User_2025-02-05-05-51-12-049
-
Need to build a report having more than 2.5 million data.Summary Need to build a report having more than 2.5 million data.Content Need to build a report having more than 2.5 million data. Notepad and notepad ++ is not supporti…User_2025-02-05-22-36-27-300 46 views 4 comments 0 points Most recent by User_2025-02-04-18-22-33-673
-
R13 Performance Management - Comments in CLOB formatSummary Does anyone have a sample report that would show comments in the new CLOB format?Content Hi, all, I'm trying to pull a report that shows sections comments from w… -
New 'Security - Roles & Privileges Real Time' subject areaSummary Has anyone used the new Security - Roles & Privileges Real Time subject area yet?Content The new Security - Roles & Privileges Real Time subject area has been de… -
Employee Info ReportSummary I want a report that captures the employee info we have enteredContent Hi, Not sure if this is the correct forum for this question but maybe someone could move i…