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
-
CASE statement THEN valueContent I would like to add a case statement logic where if a condition holds true, a column value is displayed. But in addition to the value being displayed from the sy…User_2025-02-10-08-27-16-805 25 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805 -
Subject Area in OTBI to extract default Expense Account information of userSummary Subject Area in OTBI to extract default Expense Account information of userContent Hi, I am trying to build a OTBI report which has cost center and company infor… -
Ethnicity bar graphSummary Bar graph does not match tabular view.Content I am trying to pull employee ethnicities from the system. I have come across multiple posts on how to bucket employ…User_2025-02-10-08-27-16-805 68 views 6 comments 1 point Most recent by User_2025-02-10-08-27-16-805
-
Direct Report Headcount in OTBI?Summary Are there any fields in OTBI which can pull a manager's direct reports / headcount, or otherwise indicate that they are a manager?Content Are there any fields in…
-
Sample Workforce Compensation BIPContent Hello experts, where could I find sample Workforce Compensation BIP? I need to build a BIP report allowing managers to see their direct/indirect reports for the … -
BIP Report Jobs IssueContent Hi all, I asked a couple of weeks ago about changing the privacy of Report Jobs from Private to Public which was answered here: https://cloudcustomerconnect.orac…
-
As of Date Worker ReportSummary OBTI Report with Worker Information as of specific dateContent I am looking for way to build a report in OBTI that contains worker data that can be pulled from a… -
Head Count as of given dateContent Hi Experts, We are looking for a report which has the below data point. The worker subject are giving information as of date and in the current requirement we ne…
-
Report on Performance Document AcknowledgmentSummary Is there a table or Subject area to report on employee acknowledgement?Content Is there a table or Subject area to report on employee acknowledgement? We need a …
-
Reporting on saved goalsSummary Reporting on a goal before it's been approved by the managerContent Hello, We used to be able to report on goals using Goal Status Overview Real Time. The Versio… -
Hire Date using OTBI Reporting (Not to include Global Transfer Dates)Content Greetings, We recently went live with Oracle HCM Cloud in January and we are trying to figure out how to correctly report a hire date using OTBI Analysis reporti…
-
AOR using SQLSummary Display AOR fields by Employee Number and NameContent HI All, I hope someone can help me with a SQL. I want to try and build a common query that we can use in ou…
-
As Of Date reporting and dimensional attributes in OTBIContent Hi, We want to use As Of Date reporting with OTBI. But we are not sure which dimensional attributes will also move to the value at this 'As Of Date'. Will all di…
-
Instance identifier in BIP reportSummary We need specific report to run only if it is on specific instance (say Test POD).Content We need specific report to run only if it is on specific instance (say T…
-
Table for Attachments under position profileContent Hi, Can someone help me with the table contains the attachment information under position profile? Regards, Nivya -
How to load sample report in Oracle HCMContent Hello experts, I need to load a custom template as example in Oracle HCM. I want to load an image showing a sample performance document. In addition, I have crea…
-
Simple logical sql query fails to load in data modelSummary Simple logical sql query fails to load in data modelContent We were trying to create a data model with Simple query(Name = Any , Data Source = Oracle BI EE, Type… -
Customize Rating Distribution graphContent Hello, Would like to know using which analysis the graph is generated on this Performance Calibration page. We have a requirement to cutomize this graph and want…
-
Question on .catalog filesContent Hello Experts, I got two questions (probably a weird ask) on BI catalog objects. In /analytics (OBIEE), the archive will create a .catalog file instead of a.xdo/…
-
Infolet Visibility IssueSummary Can we use Assignment's Descriptive field value in Infolet EL expressionContent Hi, We need to set the Infolet Visibility based on Assignment's Descriptive field…
-
How to remove an unwanted character in rtf template (PDF Output)Summary How to remove an unwanted character in rtf template (PDF Output)Content Hi Experts, We are generating confirmation letter with PDF format for this we are using R…
-
Multiple Worksite report is not returning data for TX after 21-A updateSummary Multiple Worksite report is not returning data for TX after 21-A updateContent Multiple Worksite report is not returning any data for Texas or New Hampshire afte…
-
How to fetch the deleted goalsSummary How to fetch the deleted goalsContent Hi, We are in REL 13 20 D. Our customer want to fetch the Goals details of the employees which are deleted. Could you pleas…
-
Report for final year-end performance ratingContent Hello Oracle community, We are looking for a report for final year-end performance rating for each employee. Version 21A
-
CONVERT FF to UDT creationContent hello Experts, I would like to ask for your assistance in converting fast formula - XX_RECOMMENDED_MAX_QUARTILE_FF to a user defined table. This FF is used in BP…
-
Absence Calendar Details Real Time - Incorrect Data in ReportContent Hi Experts, We have created a OTBI report in which we are getting the results as per leave type and for one specific leave type, we are getting very small (Incor…
-
Delegated Roles TableSummary Delegated Roles TableContent Hi All, Is there any other table which stores delegated roles details? I am able to find the table PER_DELEGATED_ROLES but this repo…
-
how to schedule an OTBI Agent using SoftDates such as: {$SYSDATE()$}Summary Scheduling an OTBI Analysis to run for previous month using {$SYSDATE()$} and {$SYSDATE()-30$}Content Hi, We'd like to schedule an Agent to run monthly, on the f… -
Extract Projected Accrual Absence Balance in HCM/BIP reportSummary Extract Projected Accrual Absence Balance in HCM/BIP reportContent Hi Experts,We have a requirement to fetched projected Absence balance of employee in extract t…
-
We need to fetch all active records from current Organization Tree for department structureSummary We need to fetch all active records from current Organization Tree for department structureContent Hi Experts, We need to fetch all active records from current O…