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
-
Proper Case Function in OTBIContent Is there a function in OTBI that transforms character strings from their current state into PROPER case format? For example: 'JOHN SMITH' or 'John SMITH' to 'Joh… -
Percentage split cost centres in OTBISummary Unable to find percentage split cost centres in OTBI on payroll relationship levelContent Hi, I am trying to create an OTBI report which displays employees who h… -
Dynamic printing of column labels in OTBI or BI PublisherSummary Dynamic printing of column labels in OTBI or BI PublisherContent Hi All Kindly share your experiences on how you have been dynamically creating reports with titl…
-
Run state new hire report.Summary Trying to find the navigation to run the state new hire report.Content New to HCM Cloud. Can someone point me toward the navigation for running the new hire repo… -
Org Tree Flatenned TablesSummary Org Tree Flatenned TablesContent Hi All, Can someone share the SQL if available handy to get Org tree (Bottom -> Up) details using Flatenned tables in HCM? Regar… -
Document Records Details and Corresponding ApprovalsSummary Document Records Details and Corresponding ApprovalsContent Hi, Are we able to produce a report which details the Document Records and the corresponding Approval… -
Calculation Card Details - Table InformationSummary Additional Information on Descriptive Flexfields in PAY_DIR_COMP_DETAILS_FContent Hello, I was looking into fetching the Pension Auto Enrollment information from…
-
Need to generate audit report for Person and Assignment EFFContent I need to be able to run the 'Generate audit Report' Scheduled Process for changes made to both an Assignment and Person EFF. I have turned it on and managed to …
-
Employees with Bank AccountsContent I have attached the screenshot of the report columns if I use the subject area Payroll - Personal Payment Details real time I am able to fetch only the employees… -
BIP report leveraging the OTBI dashboard promptSummary This post contains a brief synopsis describing the technique to leverage the OTBI dashboard prompt in the BIP reportRaghavendra Raghunath-Oracle 259 views 12 comments 12 points Most recent by Sujay Bandyopadhyay-Oracle -
Model Profile - Employee Level - FUSION OTBISummary Model Profile - Employee Level - FUSION OTBIContent Hello We have the attached Model Profile Information report that details all the Role Profiles, as well as th… -
Documents of Records data in ReportSummary Need to open DOR (Documents of Records) from BIP reportContent Hi All, We have a requirement to display DOR (Documents of Records) data in BIP report and need to…
-
Manage Job Offers - Approvals HistorySummary Manage Job Offers - Approvals HistoryContent Hi All Could you please help me with the OTBI / BI Report which helps to get the history of all transactions related… -
Payroll ReportContent Hi, I am using two subject areas Workforce Management - Person Real TIme, and Payroll - Personal Payment Detais real time When I add any of the column Target Ban…
-
Subject Area to determine Reviewee Start Performance Rating, Reviewee End Performance Rating ,ReviewContent Hi, I need the subject area that provides the below information. Can anyone please suggest, a. Initial performance rating of the candidate b. End performance rat…
-
Query to display the Phases and States of the CSP in OBIContent Hi Experts, I am looking for a OBI query to display the Phases and States which are associated to the CSP. Regards, Harish Version 20D -
Reporting mulitple Types of Managers in OTBI or BISummary Reporting mulitple Types of Managers in OTBI or BIContent Hello, We have three 'TYPES' of managers defined. I need to create a report for all employees showing a…User_2025-02-04-15-06-22-759 257 views 21 comments 0 points Most recent by User_2025-02-04-15-06-22-759
-
Annualized Salary is not populating on a OTBI reportContent When running an OTBI report the Annualized Salary value is not populating. The user has AoR's and when they view the salary details via the HR forms the details …
-
Gauge chartSummary How to set maximum scale limit to a columnContent Hi I'm trying to build a simple gauge chart for infolet to show employee's accumulated learning hours. Each emp…
-
20D - Employee only see his own records when running reportsContent I'm sure this will be an easy fix for someone, but I have recently been tasked with setting up security access to allow a few of our employees to run reports/ana… -
Including Matrix Manager pulls wrong SalaryContent Hello, Has anyone created a report where you have included fields from both Worker Assignment Real Time -> Matrix Manager and Compensation Salary Details Real Ti…User_2025-02-04-15-06-22-759 19 views 2 comments 0 points Most recent by User_2025-02-04-15-06-22-759
-
HCM: "Changed Attribute" dimension in OTBISummary HCM: "Changed Attribute" dimension in OTBIContent Hi , Can some please advise, if we have the "Changed Attributes" dimension available in OTBI? I want to create …
-
Calculation on Pivot table resultsSummary Looking to perform calculation on pivot table results columnsContent Hi there, I'm looking to perform a calculation on a pivot table to insert a new column withi…
-
OTBI report to kno new employe each day or each weekSummary Hi I'm new with OTBI, I need a report's running each day or each week with only new employes with name and number ID.Content We need a report that only contains …
-
How to pass all values to BI Publisher report via URLSummary Pass all values to BI Publisher report via URLContent Hello Everyone, I created a dashboard with multiple parameter and I have added a BIP report as url link whi…
-
Creating new calculated measure using columns from multiple subject areasContent Good afternoon all, I've created an OTBI report that combines the following subject areas: * Workforce Management - Worker Assignment Event Real Time * Workforce…
-
Roles Required to access Subject Areas related to HCM/Payroll/Compensation/BenefitsSummary Looking for a reliable document listing Subject Areas and the Roles Required to access the sameContent Many a times it happens that OTBI analysis shared by exper… -
Effective date for OTL Absences issueSummary Although an effective date is set via presentation variable values are counted by a different dateContent Hi everybody, I'm struggling with the following report …User_2025-01-31-17-16-46-301 88 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
Talent Profile - Summary of RoleContent Hi all - I am trying to find the fields to create a report from our Talent Profile section. I am trying to find how to report on the area in Fusion going to Pers… -
Create PDF template in BI using existing Fillable PDF and default HCM fieldsSummary Looking create a template in BI to prepopulate some company and employee details and leave the remaining non-populated fields on the form still fillableContent N…