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 pull only active and suspended recruiters full name from Recruiting - Recruiting Real Time SuSummary How to pull only active and suspended recruiters full name from Recruiting - Recruiting Real Time Subject areaContent Hi Team, Please find attached analysis whic… -
Dashboard with auto refreshSummary Need to know if there is a possibility to auto refresh dashboard to show 'live' view when it's openContent Hello, I was wondering if it is possible to auto refre… -
How to Fetch the Direct reports of Line Manager as of specific dateSummary How to Fetch the Direct reports of Line Manager as of specific dateContent Hi Team, PFA catalog of analysis. We have created an analysis which we use to pull the…
-
Query help needed to determine duration in job code, title, pay gradeSummary Query generates a list of the job code, title and paygrade combinations for an employee with start and end datesContent Hi All, I have seen several queries regar…User_2025-02-04-08-51-08-912 24 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle
-
Union Dues reportContent Hello, I am looking for a Union Dues report that is created in BI publisher. Please advise if anyone knows if it exists in the forum. Thanks
-
Can't unarchive catalog from Prod to DevSummary Get error message Compression - inflate Error -3 OK when trying to unarchive from Prod to DevContent Hi Apologies if this has been covered before but I couldn't … -
Too much SQL!Summary Prompt not limiting by another field - Support have advised too much SQLContent Hi I'm getting an "unexpected token" error message when trying to limit one field…
-
Regd tracking name change in OTBISummary Regd tracking name change in OTBIContent Hi , We have name change report where we track any changes to person name in past 7 days and display the person's detail… -
OTBI Analysis performance is very slow on Dashboard PageSummary OTBI Analysis performance is very slow on Dashboard PageContent Hi Team, We have created a sample analysis using Worker assignment real-time subject area and it'…
-
OTBI:"Workforce Management - Worker Assignment Real Time"-->Worker"."Previous Last Name"Summary OTBI:"Workforce Management - Worker Assignment Real Time"-->Worker"."Previous Last Name"Content Hi All, When we will see data in the Worker"."Previous Last Name"…
-
Exported analysis output is not formatting correctly in ExcelSummary Exported analysis output is not formatting correctly in ExcelContent Hi Team, PFA catalog file of analysis. We have created an analysis which we use to pull dire…
-
Pull in results from another analysisSummary combine the results from two analysis into one analysisContent Is there a way to combine the results from two analysis into one analysis? I have two separate ana… -
Salary changes after a particular dateSummary I need a report which will identify employees that have saalry changes after a given dateContent When we apply a pay award (i.e. uplift grade rates) it does not … -
CEO direct reportee nameSummary CEO direct reportee nameContent Hi all, We have a requirement to pull CEO direct reportee name For eg. Get the name of manager4 Employee->manager1->manager2->man…Reddykrishna Chidella-Oracle 25 views 3 comments 0 points Most recent by User_2025-02-05-06-26-19-951 -
How to report on Unsubmitted Timecards?Content Has anyone been able to produce a report showing which employees haven't yet submitted a time card in a given period? Any help would be much appreciatedUser_2025-01-28-05-35-00-925 121 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle
-
Need query to get Termination or Resignation Requests pending for approvalContent Need query to get Termination or Resignation Requests pending for approval
-
Transaction comments reporting - Termination ReportContent With the release of the new UI, the per_periods_of_service table no longer contains the comments for the termination transaction, instead the comments are placed… -
Assignment Changes on Employment HistoryContent Our organization is working to transition to utilizing the Quick Actions verse Person Management. One feature we use is the “view history” and then "export" on t…
-
Audit and Performance Monitoring for OTBISummary We want to track how many people are using OTBI analyses - looking for audit information similar to that available for BI PublisherContent We have recently set u…
-
Delivering OTBI report results to webcenter content serverSummary Is there any way we schedule OTBI reports to deliver results to webserver content server?Content Is there any way we schedule OTBI reports to deliver results to … -
Empty spaces in RTF if there is condition not to show a sectionContent We are working on Talent Profile print and it has multiple section so we are creating an RTF template and having a condition to display section conditionally to …
-
Inaccessible column: "Organization Hierarchy"."Level 01 Organization Name"Summary Error trying to access Org Hierarchy column with Employee roleContent Hi, We need to access "Organization Hierarchy"."Level 01 Organization Name" column through … -
what are the duty roles for viewing worker detailsSummary what are the duty roles for viewing worker detailsContent Hi - Already have the following duty roles added to the custom role: 1. Workforce Profile Transaction A… -
Starters as at Start DateSummary Data must be returned as at the Start DateContent Hi all I have a starters report that provides me with all the starters between two points in time however the d… -
Development Goals (individual) approval StatusContent How can I get the Approval Status and time approved into Development Goals Status Report. Saw a few recommendations but some seem to be for goal plan for perform…
-
EEO reporting with the new check box system for Personal Details?Summary How are you getting around the removal of "Two or More Races" as an option? How are you adapting to multiple choices for ethnicity?Content Hi all, We recently up… -
BI report based on questionnaireContent Hello, We need to create a BI report using following tables. HRQ_QSTN_ANSWERS_TL HRQ_QSTNR_PARTICIPANTS per_persons Appreciate if some one can let us know how to…
-
Survey ReportSummary survey report subject areaContent I am trying to build a report on the on-boarding survey responses. I have tried building the report in Workforce Management-Che…
-
Need sample query to check if employee has location as on hire dateContent Hi All, I'm in need of a sample SQL query to check if employee has location as on hire date.Please share if you have the same. Thanks, Ravichandran Version R13
-
Comparing two datesSummary Comparing two datesContent Hello, I am trying to create a new column whereby I am comparing the effective start date from 'Worker Assignment Event Real Time' sub…