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
-
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 51 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…
-
Political Subdivision Code (PSD Code)Summary Resident & Work PSD Codes!!Content Hi All, I am looking for Resident PSD Code & Work PSD Code in the "Payroll - Calculation Cards Real Time" Subject Area. I am a…
-
Payroll Table and Column that Holds Element Entry Override CostingSummary I need to locate this using SQL not the Subject Areas in OTBIContent I've written an SQL query to pull off the element entries and their values from the various …
-
OTBI Security - What is an Application Role?Summary Finding custom job roles for Catalog and Dashboard PermissionsContent Hello Experts! We've created some Job Roles in our organization for various purposes but th… -
Clicking on Cancel on analysis inside Infolet is navigating to Detail linked Report on Infolet. HowSummary Is there any way to control Detail Linked Report on Infolet.Content Scenarios: 1. When you click cancel on the analysis inside the infolet, while the analysis st…
-
Employee list with Performance Document status - whether document exists or notSummary I'm trying to get one consolidated current employee list with the performance document status of a particular document with one row per employee.Content Hi all, …
-
Is it possible to get detailed deduction reporting in OTBI from analysis for Involuntary DeductionsSummary Needing to know if it is possible to pull element amount (dollars) for involuntary deductions per pay period in OTBIContent Hi everyone, We are in the HCM realm …
-
Expense concatenated details with worker details.Summary I am using the right SA's but when trying to Cross Getting error.Content I am including the fact column it is still getting error. The intention to cross Expense…
-
How to get Matrix Manager email by OTBISummary How to get Matrix Manager email by OTBIContent Hi Experts, we are trying to create a report that will show also Matrix manager data, so we used the Matrix manage…
-
Find who a Requisition is sitting withSummary Want a Report that shows who a recruitment requisition is sitting withContent Hello all, In Oracle Recruitment Cloud, we have recruitment requisitions. I've been…
-
Duplicate RowsSummary duplicate rows with left outer joinContent Hello. I need to build a report that returns benefit information for everyone with a column indicating if someone is o…
-
Report to get data of direct & indirect Reportees of a managerSummary Looking at a way for creating a Report to get data of direct & indirect employees of a managerContent Hi I am looking to create a report which will fetch te data…
-
Rating ColumnsSummary Unable to find last four columns related to ratingContent Hi All, I'm facing difficult in BI Report while fetching the values of rating columns related to Perfor… -
Benefit Leave of AbsenceSummary BI Publisher table for Benefit Leave of AbsenceContent Hello. I am building a benefits/absence report and was wondering which table holds the field Benefit Leave…