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
-
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 38 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… -
Email Subject line/Body with year and monthSummary Email Subject line/Body with year and monthContent Hi All, We have a requirement in which BI report output(excel attachment) need to be send to user (one email i…
-
Restore "My Folder" contentsSummary How can we restore "My Folder" content if a new profile created for contractor conversion to employeeContent Hello, I have converted from Contractor to Employee …
-
User Report With Last LoginContent Hello, I'm having a hard time understanding why there is a lack of information regarding User login data. Does anyone have a report to be able to see the last lo…
-
HCM Subject Areas - Field ListSummary List of fields within HCM Subject Areas - and DescriptionContent Hi, I am new to reporting within HCM OTBI so this may be a silly question and may or may not hav…
-
Job Entry Date and Department Entry Date Equivalents in OTBIContent Wondering if anyone has identified a way to access job entry date and department entry date in fusion hcm. These were delivered calculated fields in People Soft,… -
Reporting on Questionnaire ResponsesContent Hi All, We're getting ready to deploy an onboarding questionnaire as a task in our enterprise onboarding checklist. Does anyone know which subject area can be us…