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
-
Absence BalancesContent Hi all - I am working on a report to show absences taken during a period of time, and I have it just fine for calculating how many absences someone has taken in … -
Need Sample Query on Head Count BIP ReportSummary Need Sample Query on Head Count BIP ReportContent Hi All, I am trying to build a Headcount Summary Report in BIP to achieve the below results, Head Count Summary… -
Conditional Formatting of Blank Cells not workingSummary I want Null / Blank Cells in RedContent Hi, I have a report (see XML attached) that has 17 columns, some of which have missing data (NULLS). All I am trying to d… -
Department name not available in Position Subject area - causing duplicate rowSummary Looking to report on position listing and incumbent information and getting duplicate rowContent Hi there, I have created a report based on position and have add…
-
Future Starters / Pending WorkersSummary Need a list of pending workersContent Hi I'm trying to build a simple report that shows all pending employees (yet to commence employment). Which subject area sh…User_2025-02-05-22-44-35-842 85 views 7 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Manager name for the CEOSummary After promoting an associate to CEO, the former CEO is still seen as his managerContent When our previous CEO retired, he was replaced by an associate within the…
-
sql to use to find out if someone is a line a manager ?Summary sql to use to find out if someone is a line a manager ?Content What sql to use to find out if someone is a line a manager ? We dont use the manager flag at assig…
-
Adding Case Statement to Existing Data ModelSummary Need assistance with case statementContent I am in need of assistance with the following: (1) case statement syntax and (2) adding a case statement to an existin… -
Schedule a BI Report based on custom logic (makes use of Payroll Flow Pattern and Custom Fast FormulSummary Schedule a BI Report based on custom logic (makes use of Payroll Flow Pattern and Custom Fast Formula)Content Many a times we may have a requirement that we woul… -
Involuntary Turnover ReportSummary Involuntary ReportContent Hi, I'm trying to build a report from scratch that will show the number of involuntary leavers and their reasons (e.g. redundancy) etc …
-
Original Hire Date and Grade ReportContent Hi, I am looking to report on original hire date, grade and time in a grade. Could anybody please help on this? Thank you! -
Updating Existing GeographiesContent Hi, Would like to know if it's possible to insert a value to existing geographies? Like I want to add a code for a county? -
Date Prompt QuestionSummary As Of Date Prompt QueryContent Hi, I have a number of reports that use the SET VARIABLE PARAM_EFFECTIVE_DATE ='@{AsOfDate}'; that work correctly up to a certain …User_2025-02-05-22-44-35-842 54 views 28 comments 1 point Most recent by User_2025-02-05-22-44-35-842
-
Set default parameter for date to SYSDATE in BIP Data ModelContent Hello I have a date parameter in my BI Publisher Data Model, and I would like to set it by defaut to today's date. I tried using CURRENT_DATE and SYSDATE but it …
-
Get legal entities addresses in a BI Publisher Data ModelContent Hello, I am creating letters templates based on a BI Publisher Data Model. Inside these letters I need to put the address of the employee's legal entity. Is it p…
-
user unable to see reports in a folderSummary user unable to see reports in a folderContent User is not able to see reports in any folder. Even in My Folders. It is just blank. Could see only folder structur… -
YTD MTD QTD Balance reports for 401KSummary YTD MTD QTD Balance reports for 401KContent Hi Team, I heard that we do not have Time to date (YTD,MTD, YTD dimensions in OTBI. I have to fetch 5 YTD values for …
-
Is there any option to change field name in Data VizSummary Is there any option to change field name in Data VizContent Hi Gurus Is there any option to change the field label in Data Viz (OAC). Like in data set column nam…
-
OTBI - Limit results in a bar graph only out of 10, but not on dataSummary Limit results in a bar graph only out of 10, but not on dataContent Hi all we build a report with several graphs. For the attached graph we need to list the top …
-
R13 Table or view name for Goal module attachment formSummary Table or view name for Goal module attachment formContent Was unable to find table or the view name associated for the Goal attachment form. Does anyone know the…
-
Row limits in OTBI ReportSummary Row limits in OTBI ReportContent Hi ALL, I have created OTBI Report based on Logical SQL. When I run it for one of the employee I see his data being populated wh…User_2025-02-07-19-03-14-525 116 views 9 comments 1 point Most recent by User_2025-02-07-19-03-14-525
-
Area of Responsibility - Work Contacts - Table NameSummary Area of Responsibility - Work Contacts - Table NameContent Where the work contacts (Area of Responsibility) are stored in the database. If you know they are stor…
-
filtering by custom promptSummary We setup a custom prompt but we need to understand how to link into filtersContent Hi Ladies & Gentlemen, we configured a custom prompt based on following SQL co…
-
List of Succession Plan for a personContent Hi all, I am trying to get a list of all succession plan where an employee is active. Thank you!
-
Unable to Unarchive .xdrz filesContent Hello, We have some .xdrz files that we've found on customer connect, but receive the attached error when unarchiving them. Is it still possible to unarchive the…User_2025-01-31-00-25-12-234 44 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
How to add a date promptSummary I would like to add an 'As At' date prompt to an existing basic employee analysis reportContent Hi, I'm relatively new to OTBI and unable to add a 'as at' date p…User_2025-02-05-22-44-35-842 138 views 14 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Previous and Current values for a shift, crew, rotation beginsSummary Due to Covid-19 we have had to introduce new shifts for our job sites. Need to report both current and previous values for auditingContent I have been tasked wit…
-
How to get the last incumbent date for vacant positionsSummary Trying to get details on vacant positions as to when it was last filledContent Looking to get whether the position ever had an incumbent and if so what the last …
-
How to count number of Management layers between an incumbent and the top of the organizationContent Looking to find a way to count all the management layers between employees in an organization. Have been able to do a span of control report but need to count ho…
-
How to identify employees who haven't created any performance goals and those who haveSummary Looking to create a quick reference report for Division heads to see which employees have created goals and which have notContent I have been trying to use the G…