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
-
Expenses Employee Number to Worker - Person NumberSummary Cannot connect 2 subject areas to merge data in OTBIContent Using OTBI I am attempting to merge subject areas Workforce Management -accruals real time with Expen… -
Transaction Approvals and Person NumberContent Hi, I have created logical SQL to return 'Rejected' Document Records from the following subject areas: * Human Capital Management - Approval Notification Archive… -
Passing parameter from Dashboard Prompt to BI ReportSummary Passing parameter from Dashboard Prompt to BI ReportContent Hi, I know we can pass parameter from Dashboard Prompt to Analysis. I wonder if we can do it from Das… -
How to Remove the HTML tag from the goal comments in BI ReportSummary How to Remove the HTML tag from the goal comments in BI ReportContent Hi Expert, How to Remove the HTML tag from the goal comments in BI Report Note: OTBI Report…User_2025-02-05-01-04-36-989 52 views 2 comments 1 point Most recent by User_2025-01-25-01-10-42-578
-
Duplicate rows returned for some Employees in Production OnlySummary Duplicate rows returned for some Employees in Production OnlyContent Hi, When I run the attached analysis which is developed using logical SQL it returns duplica…
-
modify list of recipients on scheduled reportSummary modify list of recipients on scheduled reportContent We have a scheduled report to which I need to add two recipients. I have not had any luck in the schedule or… -
How to export approval rules configured for HCM transactions such as Absence, Employment etc.Summary How to export approval rules configured for HCM transactions such as Absence, Employment etc.Content Looking for a report to fetch the custom approval rules conf… -
Termination Report with Last SalaryContent I am trying to create a report that has both the reason the employee has left the company (i.e. Voluntary, Involuntary) as well as the salary the employee was re…
-
ORC - Candidate diversity dataSummary Pull the diversity data for any candidate who has gone through interview process, irrespective of current statusContent Is it possible to pull the candidate dive…
-
Issues on Termination report with datesSummary Termination report not showing correct amountsContent Hi, I have created Termination report using "Workforce Management - Worker Assignment Event Real Time" subj…
-
Why, using a RFT template it merge cells on Excel outcomeContent Hello, I did an RFT template for one report, and once I download the outcome in Excel it merge the cells. See screenshot. Do you know why?
-
Payslip Summary section is not matching main sectionSummary Involuntary deductions is doubling and does not match the summary sectionContent Hi All, Has anyone else had an issue with the Canadian payslip where the Garnish…User_2025-02-04-08-51-08-912 23 views 2 comments 0 points Most recent by User_2025-02-04-08-51-08-912
-
Displaying an uploaded document stored as a blob in a BI Publisher report?Content We have a report request to display attachments that are uploaded by employees in a BI Publisher report. The uploaded attachments are stored as a blob and the ta… -
Need inputs to link between calculation cards and Payroll resultsContent Hi All, Can we have a link between Payroll results and Calculation cards tables/subject areas? If anybody is having any links share to us. Thanks, Visu
-
Pivot tableContent I have created a pivot table for recognition against the business unit. I am trying to get a percentage of the number of employees who received a recognition aga…User_2025-02-06-11-18-47-896 36 views 4 comments 0 points Most recent by User_2025-02-06-11-18-47-896
-
First "Approved" Position RecordSummary SQLContent Hey guys. I'm trying to extract the first approved record's effective start date of all my active positions. I tried to use this in order to extract t… -
Need help with using EXISTS in logical sqlSummary Exclude INACTIVE records created due to legal entity transfer in OTBI analysisContent Hi Experts, I am trying to create an analysis to report both active and ter…
-
Combining multiple subject areas but using one as the main data setContent Hi All, As there are certain subject areas only that would contain information needed but also have it's own limitations, I am trying to combine two subject area…
-
Not able to fetch the absenec plan balance adjustment date ( i.e ProcdDate in PersonAccrualDetail.daSummary Need to Fetch Balance Adjustment details for different plans . Not able to fetch Balance adjustment date ( i.e ProcdDate in PersonAccrualDetail.dat file)Content …User_2025-01-30-17-37-30-647 34 views 4 comments 0 points Most recent by User_2025-01-30-17-37-30-647
-
Resize a performance tileSummary I would like to arrange about 10 of them next to each other and I need to reduce size of each container.
-
Column to be added with option 'Created by' which should give information of Employee Name - While cSummary Column to be added with option 'Created by' which should give information of Employee Name - While creation on new Analysis in reportsContent Hi, While creating …
-
Report on Scheduled Process (ESS Jobs)Summary Looking for report on Scheduled Process (ESS Jobs)Content Hello, I'm looking for a report on scheduled processes. Does anyone have such report and would like to … -
Logical SQL Reports and Report HeadingsSummary Logical SQL Reports and Report HeadingsContent Hi, I have created a report using Logical SQL and was wondering if it is possible to include a user friendly Colum…
-
Set PARAM_EFFECTIVE_DATE within a UNIONSummary Combine results of 2 analysis when one has an effective dateContent I have two reports with the same columns and I am combining them with a UNION. However one an…
-
Line Manager Dashboard VisualSummary Show / Hide certain visual based on a prompt field valueContent We have a requirement to show or hide a graph based on the field value of the prompt. E.g. Legal …User_2025-02-10-17-54-52-878 37 views 4 comments 0 points Most recent by User_2025-02-10-17-54-52-878
-
Organization Tree - Filter on active versionsSummary Provides you the process to filter out the inactive organization tree versions by defaultContent Issue: Organization Trees display all the versions in HCM OTBI s… -
Point in Time Org Chart with open vacanciesContent Hello, Has anyone built a Point in Time Org Chart with open vacancies? Thanks in advance!
-
View Report Based On Legislative Data GroupSummary View BI Report Output Based On LDGContent Hi All, We have custom BI report which is using seeded data model to query. We would like to view report data based on … -
Legal Employer Hire Date and Enterprise Hire Date on Work Relationship DetailsContent Hi All, Can someone help to find underline tables and fields for "Legal Employer Hire Date and Enterprise Hire Date on Work Relationship Details Tab" If you have…
-
To hide "Home", "Catalog" option while opening an OTBI Dashboard via Widget on Home Page.Content We have a requirement where we need to call an OTBI dashboard via Widget on the Home Page. The road block is to hide the Home, Catalog, Advance, etc. tab that ar…