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
-
Reporting on Weekly Changes to Workforce TrendsContent We have a business requirement to report of weekly changes to FTE count for our departments. Where there's not a weekly time dimension in the Workforce Trends su… -
Payroll User-Defined Tables Real TimeSummary OTBI joining subject areasContent Hello. I am trying to link the "Payroll User-Defined Tables Real Time" subject area to the "Person Real Time" / "Workforce Mana…
-
Auto-fill Dashboard PromptsSummary Auto-fill Dashboard PromptsContent Hello, Anyone knows how to enable auto-fill dashboard prompts in current version of OTBI? It is possible in on-prem versions. … -
Query to find recent payroll actionSummary Query to find recent payroll actionContent For a particular employee, on the same day, they have processed payroll actions such as "Regular Normal" once and "Pro…
-
How to show Zero or another message in Infolet if Analysis does not return dataSummary How to show a message or 0 if analysis does not return any row, When there is a count it shows the count.Content How to show a simple message or just Zero (0) as…Prateek Parasar - GTUK, ACE Pro 38 views 11 comments 0 points Most recent by Caroline Gladwin-Oracle -
Can we get 'Time in Position' through OTBI?Summary Can we get 'Time in Position' through OTBI?Content Hi Team, Is it possible to get 'Time in Position' column through OTBI. Means how long the assignment exists in…
-
How to get link between Plan, Plan option and Elements for individual compensation plans?Summary How to get link between Plan, Plan option and Elements for individual compensation plans?Content Hi Team, We have a requirement where to fetch all the elements a…
-
Limit what data users can see in OTBISummary We want to limit certain data that the users can see in OTBIContent We have a requirement to limit data on the UI and in OTBI that the user can see. For example,… -
Trying to create a simple analysis or report to view the performance document questionnaire questionSummary I am trying to create a simple analysis via OTBI to view the performance document questionnaire questions, but it will not pull up 2019 performance documents whe… -
Report for Absences are going into auto denial statusSummary Report for Absences are going into auto denial statusContent Report for Absences are going into auto denial status We have Absence going into Denial status, not … -
How to calculate the correct number of employeeContent Hi Guys, I need to calculate the correct number of the employee active in the company. I used the Headcount field with the filter Assignment status == Active, Ac… -
Analytics for Absence BalanceSummary Is it possible to make an analytics to get absence balance for a given dateContent Is it possible to make analytics to get the absence plan balances for a given …
-
Need a BI Publisher Add-In Supported by MS Office 365Summary Need a BI Publisher Add-In Supported by MS Office 365Content Hi, We need a BI Publisher Add-In Supported by MS Office 365. Please provide a link to download the … -
How to user Variable in OBI Agent AlertsSummary How to user Variable in OBI Agent AlertsContent Hi we used & to include any Variable in Oracle Alert and we have a similar requirement where we want to use the E… -
Plans to move from OBIEE 11.1.1.9 to 12.xSummary When does Oracle plan to move the OTBI/BIP cloud platform from version 11.1.1.9 to 12.xContent Is there a Statement of Direction or a blog post that states if an…
-
Export Pivot Table with >75k rows (Data Model)Summary Trying to export Pivot but keep hitting row limitContent Hi, I have a pivot view on a report that I need to export out in to Excel. Unfortunately, the list canno…
-
Fiscal Year ReportingSummary Reporting from 1st date of fiscal year up until today, and from tomorrow up until last date of fiscal yearContent Hi, I am still very new to OTBI and SQL. What I…User_2025-02-05-10-44-58-756 62 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle
-
ANC_PER_ABS_ENTRY_DTLS table is emptySummary Absence entry Detail table not getting populatedContent Hi All When absence entry is created from the UI with basic mode, data is not getting stored in table ANC…
-
Distinct row in a employees reportContent Hi Guys, I need to realize a report with the following field: National Identifier National ID National Identifier Person type Name Last Name Name First Name Legi…
-
HCM HR/Payroll Approval Reminder EmailsContent My task is to send out emails to assignees that they have pending HR/Payroll approvals on Wednesday and Friday mornings. I wrote a data model containing this dat…
-
We need to know table which stores Absence StatusContent Hi , We need to know which table stores status shown in attached screenshot. I have checked columns ABSENCE_STATUS_CD and APPROVAL_STATUS_CD in table anc_per_abs…
-
Need to display Hire details from last six months in OTBI reportContent Hi All, We have a requirement to display HIRE Employees from last six months in OTBI report. In OTBI analysis we selected "Workforce Management - Worker Assignme…
-
Performance Rating Level Name for Section and ItemsSummary Show Rating Level Name for both section and item when they use the same rating modelContent Hi, I kindly need to know if there is a way to display section rating… -
Reporting on Late TermsContent Hi all - hoping you can help with how to report on a termination keyed late? My understanding is that a line manager keys in the termination 01SEP for 10SEP. The… -
Audit for multiple open assignment-related transactions on same associateSummary Audit for multiple open assignment-related transactions on same associateContent Good afternoon. Wondering if anyone has built an audit (in either OTBI or BIP) t… -
Employee Education DetailsSummary current employees and their Name, Major, University, Title, Division, Group, Start Date,departmentContent Hello, Does anyone know which suject area on Oracle HCM…
-
Subject Areas for Work SchedulesSummary Our clients requirement is to create on the ratio of Planned/Scheduled Hours vs Actual Hours.Content Dear Experts, Our clients requirement is to create on the ra… -
Oracle Learning Cloud (OLC) OTBI Reports not pulling employee dataSummary Using OLC Subject AreaContent Hi all, I'm trying to create a report in the OLC Subject area. I've been able to pull in the Learning information, but I can't pull…User_2025-01-31-00-25-12-234 37 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
HY000. Code: 60009. The user request exceeded the maximum query governing executioContent We have created an analysis with BI Admin role. When we are running this analysis with BI consumer/author role. we are getting error: HY000. Code: 60009. [nQSErr…
-
Salary reportSummary Salary reportContent I need a report which pulls current salary and previous salary details. Can any one have SQL to pull the data. PERSON_NUMBER OLD_SALARY_STAR…