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
-
Performance Rating With Compensation Data causing duplicate rowsContent Using Performance Rating from Compensation - Workforce Compensation Real Time subject area causes rows to duplicate for individual employee. I have tried to use …User_2025-02-10-08-27-16-805 26 views 5 comments 0 points Most recent by User_2025-02-10-08-27-16-805 -
OTBI - get language which user is connected withContent Hello, we need to detect the language which the user is connect with. How it is possible? (OTBI) Thanks Nicola -
OTBI filter cross subject areas problemContent Hi Guys, I created a report with elements from 4 subject areas, It work well, but when I add some filters it give me no results even if before the filter the val… -
Display Parent Manager First Name and Last Name in 2 separate columnsContent Hello, I have an analysis I am creating that the end user has requested manager first name and last name to be in 2 separate columns. I have referenced this post…
-
Report for Duplicate DependentsSummary Report for Duplicate DependentsContent Hi , Any one can help is their any report to find the duplicate dependents for each employee Regards, Reddykrishna -
Metrics for News and Announcements?Content Is there anywhere we can see metrics for how many times people have clicked on News and Announcement articles? Many Thanks Amanda
-
Report for MFA Multi factor authenticationSummary Report to identify which employees have activated Multi factor authenticationContent Hi Do you know if there is any subject area or database table where I can se…
-
Oracle Learning Planning Prices -> Any alternates to get previous history from 'wlf_plan_records_f'Summary wlf_plan_records_f - does not keep date-tracked rowsContent Hello, Can anyone please help? At the moment, the OLC table 'wlf_plan_records_f' does not keep date-t… -
In need of an AAP Promotion report (FROM and TO details on job)Summary In need of an AAP Promotion report (FROM and TO details on job)Content We have AAP promotion report due in which they are asking FROM and TO of a job in a promot…
-
OBTI Formula for January 1st of Current YearContent I need to get the age of the worker for the start of the year in an OBTI analysis. I have Oracle's formula to calculate age: TimeStampDiff(SQL_TSI_YEAR, "Worker"… -
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 24 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.