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
-
Candidate Address and Other - IRC_JobOffer_Accepted_External - Alert/NotificationContent Hi, Using Alert: IRC_JobOffer_Accepted_External, added template. Whereas Procurement Department need to be informed that Candidate accepted offer. Procurement ne… -
Nee a delivered report path that triggers approval notification email for time and labor module.Summary Nee a delivered report path that triggers approval notification email for time and labor module. -
Dashboards graph PropertiesContent Hello! I added some pie charts in a Dashboard but they are displaying misaligned even if they have the same graph properties. In attachment a screen showing the … -
Table for Pension Scheme name stored at PAE at UK calculation CardSummary Table for Pension Scheme name stored at PAE at UK calculation CardContent Hi Experts, I am try to pull the Active Qualifying Scheme for employee stored at PAE UK…
-
Display sum of questionnaire response scores in banded groupsContent Hello. I'm trying to accomplish the following from a scored survey in a checklist task that we ask our new hires to respond to. Each response within each of the …
-
Oracle BIP Report -> Timezone Issues (displays +5 hrs)Summary timezone offsetContent Hello, Can anyone please help me? I have a learning activity with a start time of 08:00 am and with timezone of EST. When it is included i… -
OTBI Subject Area/SQL to fetch HCM Approval Delegation detailsContent Hi, Does anyone know the OTBI subject area/Table names which can fetch the details of HCM Approval delegation in Person's Account Management page. Best Regards D…
-
How to Report available working hours of all Employees in a department excluding Absence HoursSummary OTBI Report for Available Working Hours of All Employees using either FTE or Normal Working Hours from Employee Assignment by excluding the Absence Hours during …
-
can we group the output using any templateSummary my report is displaying 300 rows but user needs to display the output in grouping ,example each 100 rows as one group ,is it possible to using templateContent Hi…
-
Org Tree Flatenned TablesSummary Org Tree Flatenned TablesContent Hi All, Can someone share the SQL if available handy to get Org tree (Bottom -> Up) details using Flatenned tables in HCM? Regar…
-
Subject Area to determine the Legal Entity details in Workforce Succession Management Subject AreaSummary Subject Area to determine the Legal Entity details in Workforce Succession Management Subject AreaContent Hi , While building some reports for the talent Module,…
-
Calculation Card Details - Table InformationSummary Additional Information on Descriptive Flexfields in PAY_DIR_COMP_DETAILS_FContent Hello, I was looking into fetching the Pension Auto Enrollment information from…
-
Remove Historical rows from TM OTBI analysisSummary Remove Historical rows from TM OTBI analysisContent Hi team, We have an OTBI analysis for listing out recent talent ratings for all the of the employees created …
-
Number of Direct Reports that are ManagersSummary Need to generate a report that shows, for a manager, which one of their direct reports is also a manager.Content * There is a requirement to get, for a manager, …
-
Need table names/SQL for Check-ins meeting and Questionnaire attached to the Check-in TemplateSummary Need table names/SQL for Check-ins meeting and Questionnaire attached to the Check-in TemplateContent Hi, I need to build i query to capture the response of ques…
-
Annualized Salary is not populating on a OTBI reportContent When running an OTBI report the Annualized Salary value is not populating. The user has AoR's and when they view the salary details via the HR forms the details …
-
20D - Employee only see his own records when running reportsContent I'm sure this will be an easy fix for someone, but I have recently been tasked with setting up security access to allow a few of our employees to run reports/ana… -
Tuning Performance Task with Performance Ratings Subject Areas for Performance!Summary I've joined the subject areas together and it's VERY slowContent I've created an analysis where I'm trying to derive the current in progress performance task fro… -
Error when scheduling Logical SQL ReportContent Hi all, I've scheduled quite a few logical SQL reports, but the two newest ones I've created (Change Value Reports) receive the attached error. Any ideas on what…
-
Calculation on Pivot table resultsSummary Looking to perform calculation on pivot table results columnsContent Hi there, I'm looking to perform a calculation on a pivot table to insert a new column withi…
-
Gauge chartSummary How to set maximum scale limit to a columnContent Hi I'm trying to build a simple gauge chart for infolet to show employee's accumulated learning hours. Each emp…
-
Can Worker Assignment Event Real Time SA provide details of Multiple Events performed on a Worker atSummary Need a BI Report that can report all the Assignment changes with change attributes on an employee, similar to what you see in the Assignment History in UIContent…
-
Need to generate audit report for Person and Assignment EFFContent I need to be able to run the 'Generate audit Report' Scheduled Process for changes made to both an Assignment and Person EFF. I have turned it on and managed to …
-
BI report Job and OTBI agent scheduleContent Hi All, We have already many BI job report scheduled daily basis with attachment (maximum 10MB per attachment), similarly for OTBI agent as well. The email would…
-
SQL count of vacant positions in each department for the last three monthsSummary count of vacant positions for each department group by the last three monthsContent Hi, I am trying to write a sql in BIP to get the count of active vacant posit…
-
Formula to add 30 days to a date fieldContent Is there a formula that can take a date field and add 30 days to it? Version 21A -
Manager Department HierarchyContent I have been able to create a top down hierarchy in my report using Person Manager and CASE/WHEN statements however, I am now being asked to bring in the departme…
-
OTBI Subject Area data discrepancySummary Seeing some data discrepancy on a OTBI Subject AreaContent Hello Everyone, Our application team has enabled new module and when I tried to create report via OTBI…
-
Date Parameter in BI Publisher ReportSummary Date Parameter in BI Publisher ReportContent Hi All Date Parameter in BI Publisher Report showing one day off in output, Tried setting of user time zone under My… -
Creating new calculated measure using columns from multiple subject areasContent Good afternoon all, I've created an OTBI report that combines the following subject areas: * Workforce Management - Worker Assignment Event Real Time * Workforce…