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
-
Report on Terminated Employees Sickness AbsenceSummary We cannot report on sickness absence data for terminated employeesContent Hello, We have a requirement to report on the average working days lost for all employe… -
Formula for get the emlpoyees enrolled benefits planSummary Need benefits formula to get the employees who are enrolled the benefits plansContent Hi All, fast formula type : Person Selection rule Rule Criteria: Person who… -
Number of columns mismatch. Expected: 6 columns. Actual: 7 columns.Summary It is happening while adding "Worker"."Person Number" on groupbyContent Hi, we are facing an error while we are adding "Worker"."Person Number" on groupby. The e…
-
OTBI Based Dashboard OutputSummary Multiple Employees in different Pages in Dashboard OutputContent Hi All I created a Dashboard for Talent Profile using 10 analysis (Each analysis will bring its … -
How to display grade from prior salary change on same lineSummary In a comp history analysis, I need to report on employee's grade as of the salary update immediately prior to the current salaryContent Subject Area: Compensatio…
-
Watermark not coming in HTML ( Email body) outputContent We got a requirement to send an email (not an attachment in email) to user on his/her anniversary. We are trying to use BIP bursting concept to send an email. In… -
Payroll - Element Entries History Real Time - Input ValueSummary Payroll - Element Entries History Real Time - Input ValueContent Hi, I am trying to create an analysis for the subject area Payroll - Element Entries History Rea…
-
Can we create OTBI report for COmpetencies which include audit detailsContent Hi All, We have created competency, in OTBI is only showign the latest update on competency. for example we are changing rating for comp A from medium to Low on … -
Security QuestionSummary Report needs to be run by many usersContent Hi, I have a simple report that runs using a From and To Date prompt that shows all New Hires within the chosen date …User_2025-02-05-22-44-35-842 41 views 2 comments 0 points Most recent by User_2025-02-05-22-44-35-842 -
Emergency Contact Details Report - Required Duty/Data RoleContent Hi All, We have created Emergency Contact Details Report from Person Subject Area to support our Business Continouity agenda (attached). We have two custom roles… -
Fusion Table for BIP informationContent Hello All, Is there any tables available which is holding the information of BIP(Data models, template, etc) details. Thanks Ganesh -
OTBI Analysis Error: Subquery contains too many values for the IN predicate.Summary State: HY000. Code: 42029. [nQSError: 42029] Subquery contains too many values for the IN predicate. (HY000)Content Hi, I have a OTBI report which needs to pull … -
Could not find the lookup HRC_TRANSACTION_STATUSSummary Could not find the lookup HRC_TRANSACTION_STATUSContent Hi Experts, As a part of pulling the Approval Transaction Details, I have used the table HRC_TXN_DATA. Th…
-
Issue passing the date parameter to the date parameter while creating a link to the other BIP reportSummary I have been tryingng to create a link for a custom BIP report in my existing report for which I am passing 3 string parameters which worked fin, while passign th…User_2025-02-07-18-15-37-534 131 views 2 comments 0 points Most recent by User_2025-02-07-18-15-37-534
-
Data-model from Analysis not working after 20BSummary Data-model based from Analysis keep saying path not foundContent After receiving 20B update, it seems like our Data-models are having issues (which are tied to A…
-
HR Helpdesk Seeded Dashboards And AnalyticsSummary HR Helpdesk Seeded Dashboards And AnalyticsContent We are looking to explore if there are any seeded HR analytics available for the HR desk. We have referred to …User_2025-02-10-08-27-16-805 80 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805
-
Reports and Analytics - Individual CompensationSummary Reports and Analytics - Individual CompensationContent Hi within Reports/Analytics is there a Subject Area where I can get data on individual compensations. Such… -
Change column to NumericSummary I want to change a column to numeric so I can add formulas. How would I do so in the SQL?Code Snippet SELECT "Workforce Management - Worker Assignment Real Time"…
-
Need to Print Salary Amount in Spanish and Portugese in Employee letter ( BI Report)Summary Need to Print Salary Amount in Spanish and Portugese in Employee letter ( BI Report)Content Hi AllWe have a requirement to build Employment letter, letter is in …
-
Row Limit? Missing RowsContent Hi all - I have a query (Logical SQL) that I use to run for changes. It runs Assignment and Salary changes. When I ran the report in April, it pulled back ~132K … -
20c Subject Area Changes - Transaction AdministrationSummary Additional fields added to Human Capital Management - Transaction Administration Real TimeContent I have been reviewing the readiness docs for 20c HCM, but I hav…
-
Seniority hoursContent We are developing a report using OTBI and one of the columns is to populate employees Seniority hours. Wondering which subject area contains that information? We…
-
Multiple Rows For Assignment ManagerSummary Updated the assignment manager job today and each employee now has multiple rowsContent Hi, Today we ran the jobs to update the assignment manager fields. After …
-
OTBI Report with Position Headcount data as of current month and as of previous month in the same anSummary Current and Previous month data in the same OTBI analysis based on AsOfDate variable parameterContent Hello All, Request help! Trying an OTBI report which includ… -
Resume an automated Job - after PAUSINGSummary Resume an automated Job - after PAUSINGContent Resume an automated Job - after PAUSING results in: 1. immediate submission of the job 2. And also runs for all th…User_2025-02-05-22-13-16-277 169 views 1 comment 0 points Most recent by User_2025-02-05-22-13-16-277
-
Could not able to fetch Manager Hierarchy for Contingent workers using Workforce Management - WorkerSummary Could not able to fetch Manager Hierarchy for Contingent workers using Workforce Management - Worker Assignment Real Time Subject AreaContent Hi Experts, We are …
-
How to increase the number of characters for a OTBI Analysis columnContent Hello experts, a text column returns truncated text while in Core HR I can see the entire text. As a result, I think that it depends on the report configuration.… -
Embedding Dashboard on context UIContent Dear All, I have embedded dashboard on Hiring page by creating another tab as shown in attached screenshot. I don't want to show all the catalog options with das…User_2025-02-06-14-37-05-233 67 views 8 comments 0 points Most recent by User_2025-01-30-00-32-10-452
-
Get the date of change if a field in BI reportSummary Get the date of change if a field Work from home in BI reportContent Hi, we need to get the date of change if a field Work from home in BI report. Pls find the q…
-
How to Hide Prompt Section in Dashboard OutputSummary How to Hide Prompt Section in Dashboard Output While printing it.Content Is there a way to hide the Prompt from the Dashboard when we print the Dashboard output …