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
-
Is there a compensation event real time subject area similar to worker assignment event real time?Summary: Is there a compensation event real time subject area similar to worker assignment event real time? Content (required): We created a report using the worker assi… -
Seeking confirmation of what is stored in 'question response answer text'.Summary: We currently use OBIEE and will migrate to OTBI later this year. I do not have access to OTBI to try this for myself :) . As part of the migration I am trying t… -
Application channelSummary: Mobile vs Desktop - Is there a way to report on how candidates are applying, whether it be on a mobile device or from a desktop/laptop? Content (required): We a… -
Tuning Performance Task with Performance Ratings Subject Areas for Performance!Summary I've joined the subject areas together and it's VERY slowContent I've created an analysis where I'm trying to derive the current in progress performance task fro… -
How to split excel template into multiple sheets for each employeeSummary: We need to split the excel template into multiple tabs for each employee. For Example if any excel template has 3 employees in the output, then we need to split…
-
HCM OTBI Index ColumnsSummary This workbook documents index columns in HCM OTBI subject areas.Content This document is published by Oracle OTBI Development. Index columns use database index f… -
in RTF how to use a parent attribute for comparison inside a child repeating group while summingSummary: In a rtf template we are trying to compare the value of child attribute to a parent attribute if the value matches then the sum of an child repeating attribute …
-
Change LOV in Comp dashboardSummary: I am looking to add a LOV in the dropdown box for Out of the box dashboards available for managers under workforce compensation Content (required): Need to add …
-
How to show a report in the user interface?Summary: How can I show a specific report/analysis directly to end users in different screens? Content (required): Basically I want to know how to show data to end users… -
When we apply below query we only get the one recordHi Team, When we apply the query the only we get the one recod. Could please assist on. Thanks, -
How to add logical sql analysis to dashboardContent Hi, I have created logical sql OTBI analysis , now I want to add this into Dashboard page which is already having dashboard prompt(all are column prompts) and ot…
-
Business Title Not Pulling CorrectlyContent We are currently migrating to use the delivered business title field, but I'm having some difficulty pulling it into an OTBI report. If I don't add any employee … -
we work in Hebrew environment but language changes to EnglishSummary: Our site work in Hebrew in most cases, when entering into reports and analytics many times the UI language changes to English Content (required): how to avoid t…
-
What filter can I use to only list the Last Assignment details for employees and not duplicate rows.Summary: Hello Community - I need assistance listing employees "Last Assignment" or "Latest Assignment" details. If someone was Rehired, or Terminated more than 1 time, …
-
Any way to find that scheduled BI report is running or got struckSummary:Any way to find that scheduled BI report is running or got struck Content (required): Hi All, We have scheduled a Custom BI Report to pull some payroll related d…
-
How to split in two different columns an information through OTBISummary: Need to create an additional column for "Email type" Content (required): Need to have two different column for work email + personal email and not different row… -
How to change path color for a node path in Hierarchy TreeSummary: Change color of the node path in Hierarchy Tree. Content (required): Hi All, We are creating a manager hierarchy tree report, our client wants to change the col…
-
Performance Tile counting assignments based on the sum of a flex field by assignment.Summary: Since upgrading to 22A we're having trouble with a performance tile used to count assignments based on the sum of a flex field we've designed and I'm looking fo…
-
Remove filter values from Export to Excel from DashboardSummary: Content (required): I would like to remove the filter from a dashboard when exporting to Excel. As seen below there is a screenshot of the Excel export I made. …
-
OTBI - Is it possible to retrieve working days per employee?Summary: Hi, We are using absence mgmt module (no time and labor) and one of the reports requires us to display how many days a month is an employee supposed to work (ba…
-
I have create a analysis on seniority subject area but few employees who have seniority are missingSummary: I have create a analysis on seniority subject area but few employees who have seniority are missing Content (required): how it can happen and where to start che…
-
List of All reports in BI PublisherHi Experts, Do we have any table or web service that can list out all reports present in a BI Publisher instance? So far we have used: XXXXX.oraclecloud.com:443/xmlpserv… -
Significance of SOURCE_ACTION_ID in pay_payroll_rel_actions tableSummary: Hi, At the time of using table pay_payroll_rel_actions , we generally put this condition in where clause: SOURCE_ACTION_ID is not null. I observed that in table… -
Effective DatingSummary: I'm using Compensation - Salary History Details RT subject area to get someone's salary as at 29-10-21 (so in that subject area I use the Salary Change Date
-
Burst notifications are sent to inactive managersSummary: We have notifications to inform the current manager about the contract expiry dates of their employees. The OTBI was done using the Worker Assignment Real Time …
-
Users with FBI_CAREER_DEV_TRANSACTION_ANALYSIS_DUTY are unable to see their own development goals.Summary: Users with FBI_CAREER_DEV_TRANSACTION_ANALYSIS_DUTY inherited by either ORA_PER_LINE_MANAGER_ABSTRACT role or ORA_PER_HUMAN_RESOURCE_ANALYST_JOB role are unable…
-
Additional comments and Reason for joining can't fetch the OTBI reportSummary: Question test to response answer in Pivot Table format Content (required): Formula for Question test CASE WHEN "Checklist Questionnaire"."Question Text" = 'What…
-
Where to find in OTBI Calculation Card Start and End Date?Summary: Where can I find in OTBI Calculation Card Start and End Date? Content (required): Please see image below. I am using the "Payroll - Calculation Cards Real Time"…
-
I need to create a group or a bin based on 2 different columns. Is that possible?Summary: Group or bin based on 2 fields Content (required): I am working on turnover report and need to create groups or bins from a hierarchy tree value and a company b… -
I have 2 parameters for analysis both are list of values on the same table - how I can write the sqlSummary: I have 2 parameters for analysis both are list of values on the same table - how I can write the SQL the will limit the lov of the second parameter Content (req…