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
-
SQL for Hire Date + 30 daysSummary does anyone have a quick SQL for finding employees hitting their 30 day mark after hire?Content Hi folks - hoping this is an easy one! Does anyone have a quick a… -
R13 20A - How to include OTBI subject area in BI SQLsSummary Wanted to include in the BI SQL select statement OTBI subject areaContent How can i include OTBI subject areas in my BI SQL reports being created Version 20A
-
Adding Dynamic BI Publisher Link to DashboardSummary Creation of a simple dashboard with links to all reports in our instance (static BIP links don't solve our issues)Content Hi all, We are trying to create a more … -
Reporting through Payroll Balances Real TimeSummary Guideline to build reports using Payroll Balances Ream TimeContent This document will help user build scalable reports using OTBI Payroll Balances Subject Area. …
-
Adding Home Email AddressSummary adding home email address without having people drop off reportContent I need to add the home email address to an existing analysis, however, employees who don't… -
Where to find definitions for each standard OTBI measure?Summary I'd like to see the definitions or specific criteria used for defining which HCM transactions affect each of the predefined standard measures in OTBIContent Is t…
-
Will it be possible to get direct & Indirect employee assign to managerSummary Will it be possible to get direct & Indirect employee assign to managerContent Hi All, Will it be possible to get direct & Indirect employee assign to the manage…
-
BI Report for IntegrationSummary Need a BIP report with .dat output formatContent Hi Experts, As a part of business requirement we need a BI report with output in .dat format and need to send th…
-
LSQL QuestionsContent Hi all - I am working on an LSQL report for combining salary/assignment data to show old/new information. I have run into a few questions that I am really hoping… -
Issue with Text file output for eText Template with Data Model with 2 Data Sets in OTBISummary Issue with Text file output for eText Template with Data Model with 2 Data Sets in OTBIContent I have a report using a Data Model that uses 2 data sets. I use an… -
Need help for building Confirmation Letter after probationContent Dear All, I am new to report development in oracle fusion HCM cloud. It would be really helpful if someone can post Confirmation Letter after Probation & Extensi…
-
How to see custom fields in OTBI?Content Hello experts, I have created a custom field in worker assignment page. How can I see custom fields in OTBI? Are there any batch processes to launch? Thanks in a… -
Agents querySummary Recipient / Specified UserContent Hi, If I set up an agent as a specified user i.e. (me), will the recipient who is located in a different region still only see …User_2025-02-05-22-44-35-842 34 views 2 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Embed a BI Publisher Report link in the Goals page to fetch data for the searched employeeSummary Approach to embed a link to run a BI Publisher report to fetch Goals details for that employeeContent Hi, Apologies if I had missed any existing thread/post on t…
-
Email address not accepted in scheduled BI Publisher reportSummary & in email address is preventing scheduling of BI Publisher ReportContent Hi, A colleague is trying to schedule a report but he is unable to enter an email addre…User_2025-02-05-22-44-35-842 31 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Passing values from report to an oracle fusion pageSummary Passing values from report to an oracle fusion pageContent I have a BIP report with bursting to email, which will be sent to the manager for individuals. Now in …
-
BI Publisher Termination ReportSummary Can a fix I made to the analysis version be applied to the Data Model version?Content Hi, Can someone please add the following Action Codes to this Data Model & …User_2025-02-05-22-44-35-842 52 views 10 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
Need inputs to display data under "Calculated Time" section in OTLContent Hi All, As per the OTL setup we are referring two layouts while displaying OTL data. Initially employee will enter hours , Payroll time type, Hours and related f…
-
Job field empty for one employee but filled for other employeeSummary In a report the job field for some employees is empty and for some it does contain informationContent I have created a report with two subject areas (workforce m… -
Here is the below query need to put some manual calculation formula. Can any one please help me in dSummary =IF((Base SalaryContent SELECT DISTINCT(b.person_number) "EMPLOYEE No.", b.person_id as "Unique_id", (select salary_amount from cmp_salary where assignment_id=a.…
-
Managers are unable to view Performance Document Task Status OTBI reportSummary Managers are unable to view the Performance Task Status OTBI report, whereas they can view the data on Front end. We are using the delivered Line Manager role. A…User_2025-02-06-20-49-14-481 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle
-
Here is the below query need to put some manual calculation formula. Can any one please help me in dSummary round(base_salary * 4.81%)Content SELECT DISTINCT(b.person_number) "EMPLOYEE No.", b.person_id as "Unique_id", (case when C.MIDDLE_NAMES is null then C.FIRST_NAM…User_2025-02-07-09-10-02-492 58 views 2 comments 0 points Most recent by User_2025-02-07-09-10-02-492
-
Analyses report to fetch Supervisor Level 2 and aboveSummary Analyses report to fetch Supervisor Level 2 and aboveContent Hi, I am looking to fetch the following using Analyses. * A list of Supervisors with Level 1 (not ma… -
Reporting Requirement to Find Employee's VP or above Manager Level in Reporting ChainSummary Reporting Requirement to Find Employee's VP or above Manager Level in Reporting ChainContent Hi, I am not sure this is possible within a single select statement …
-
Performance Tile - create a measure of maxium distance from CEOSummary How to create a measure of max of levelContent Hi, we need to create a measure that is the maximum distance from CEO. Level is calculated by the following formul…
-
Performance Tile - create a measure #managers/#employeeSummary How to create a measure #managers/#employeeContent Hi, we need to create a measure that is the ratio within the number of managers and the numbers of employees. …
-
Filled Requisition ReportSummary Need help troubleshooting a few things on a filled requisition reportContent Hello! Looking for some help troubleshooting the attached filled requisition report.…
-
OTBI job history report with previous/current values?Summary I'd like to report with previous and current valuesContent Any one have examples or advice on developing an OTBI which will display both the previous and current…
-
Pending Workflow Notifications DashboardSummary Dashboard to be created for pending workflow notiifcationsContent Hi all, We are trying to create a dashboard which will display the number of pending workflow n…
-
Assignment Overview with effective date (Report)Summary This report gives an overview over changes to assignments within your organizationContent The main purpose of this report is to give a manager or HR an overview …