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
-
How do you report in OBI on workers who have not created any goals?Summary Cannot work out how to bring back colleagues who have not even created a goalContent Hello everyone, One of our business requirements is to be able to report on …User_2025-02-04-13-09-16-898 64 views 2 comments 0 points Most recent by User_2025-02-04-13-09-16-898 -
Reg count (Person Number)Content Hi Could you please let me know why count (Person Number) is showing 2 even though only one row is return ? attached xml. Thanks -
Regarding e-text template used in HCM extractsSummary Regarding transformation on e-text templateContent Hi, We need to transform the date on the text template used in an extract.What we need is to add + 1 day in th…User_2025-01-31-02-27-22-166 52 views 1 comment 0 points Most recent by User_2025-01-31-02-27-22-166
-
Performance Head countContent Hi How to use head count in "Workforce Performance - Performance Rating Real Time" Subject area as I count not see head count field ? Thanks
-
Turnover Calculation in OTBISummary What is the formula for the out of the box turnover calculation in OTBI?Content What is the formula for the out of the box turnover calculation in OTBI? Thanks, …
-
Is there any subject area is available which shows the inprocess/complete/initiated resignation infoSummary Is there any subject area is available which shows the inprocess/complete/initiated resignation informationContent Is there any subject area is available which s…
-
Query to get non person account detailsSummary Query to get non person account detailsContent Using the below query to get the non person account details but for few users the first name, lastname and email a…
-
how to avoid multiple rows in OTBI ReportsSummary how to avoid multiple rows in OTBI ReportsContent Hi Team, we have a requirement to pull "Work E-mail" so i have written case statement with email type code as "…User_2025-02-04-07-00-18-658 111 views 12 comments 0 points Most recent by User_2025-02-04-18-22-33-673
-
OTBI How to add All Value to columnContent Hi, I have added a gender column graph prompt , so while selecting the gender values graph gets refreshed. Now I want to add value to gender column like 'All Val…
-
Report with two different As-Of-Dates to calculate Delta variationsSummary We need to pull two lines for employees, one referring to CURRENT_DATE and the other to the previous monthContent Hi All, we do need to calculate, for Payroll pr…User_2025-01-31-00-30-34-540 29 views 4 comments 0 points Most recent by User_2025-01-31-00-30-34-540
-
Competencies OTBISummary Cannot view the competencies for position in OTBI reports while the values in the position profileContent Hi , Cannot view the competencies for position in OTBI … -
Agent mail trigger issueContent Hi, I have created a agent. In 'Delivery Content' tab I have given content as 'Briefing Book' with PDF format , and also configured mail ids in Recipients' tab, …
-
Issues with BIP reportSummary Issues with BIP reportContent Hi, I have following issues with my BIP report: 1. How to fetch country name from a country code ? I need to print country name in …
-
HR can't see all HR Action valuesSummary We have analysis and HR can't see all HR Action values.Content Hi All, In our analysis we see who left the company, why and dates, actions etc. In HR Action we h…User_2025-02-04-18-26-11-309 45 views 2 comments 0 points Most recent by User_2025-02-04-18-26-11-309
-
HCM Cloud OTBI Workshop at Oracle ParisContent In the last few years we have been running a popular HCM Cloud OTBI Workshop in EMEA to help customers get the most from their investment in HCM Cloud. We plan t… -
Need Subject area to get the Person Identifier number for external applicationsSummary Need Subject area to get the Person Identifier number for external applicationsContent Hi Team, Does any one have an idea on which subject area to use for gettin…User_2025-02-04-07-00-18-658 148 views 2 comments 0 points Most recent by User_2025-02-04-07-00-18-658
-
Global Transfer ReportingContent Hi all - we have come across an issue for reporting that we need your expertise on. Recently, we found that a Global Transfer action-action reason can be correct… -
Agent Deletion errorContent Hi I am getting below error while deleting the agent , please assist on this. Thanks
-
OTBI Conditional Formating - Color Coding Not workingContent Hello everyone, I have created passport details report. This report contains field Passport Expiration Date. I would like to color cells where expiration date is… -
Prompt Filter - Date Format ChangeSummary We can't change filter's Date Format at promptContent Hi All, I added date filter with using Prompt for analysis. In Analysis, I can change date format as I want…User_2025-02-04-18-26-11-309 94 views 12 comments 2 points Most recent by User_2025-02-04-18-26-11-309
-
As-of-Date Doesn't work anymoreSummary As of date variable in OTBI doesn't workContent Hi, Since the last release, the feature of putting variable in OTBI analysis for effective date doesn't work. The…
-
Identify ALPHABETS in STRINGS in OTBIContent Hi All, We have an report where we need to identify ALPHABETS from a values coming up in the report as a filter criteria. For examples, pick all the Account numb…
-
Payroll Check Details ReportSummary We have a requirement to pull out Payroll Check Details for an employeeContent Hi, Can anyone help me with a Sample query which will give Payroll Check Details (… -
OTBI Does Not Produce ResultsContent Hi All, I am just running a simple query to get the list of all employees. It's only showing my name, plus as soon as I one more column it does not produce any r… -
Report for users with current rolesSummary Not able to pull all users for above reportContent Hello Folks - We have been using below report to satisfy one of our downstream system for periodic audits. Req…
-
EIT - India Nomination InformationContent Hi All, We have a requirement from our business in India regarding their benefits program. We require to report on Extra Information - India Nomination Informati…
-
Audit report for user roles in HCMSummary Audit report for user roles in HCMContent Hi When I tried to pull the User roles report form the delivered LDAP report it is displaying roles which are currently…User_2025-02-01-08-16-14-343 211 views 3 comments 0 points Most recent by User_2025-01-25-04-02-13-126
-
19B caused a number of BIP reports to now fail - HY000Content Hello, Following our upgrade to 19B at the weekend a number of custom reports are now no longer working that we had built. I wonder if any reporting experts woul… -
Entitiy Model/relationship diagram for HCM CloudContent Please could someone point us to the entity model / entity relationship diagram for the Bi reporting tables for HCM Cloud Thanks
-
Is it possible to create a Data Model In Oracle HCM Cloud Using Multiple Datasources (One as SQL QueSummary Is it possible to create a Data Model In Oracle HCM Cloud Using Multiple Datasources (One as SQL Query Data Set and other as Static Excel Spreadsheet)Content Hi …