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
-
SQL to get Level 1,2,3,4... for an employee?Content What is the SQL (Not analysis) to get the different department levels for an employee? -
Individual record for Absence Data for EmployeesSummary Using OTBI subject Areas to fetch absence detailsContent Hello All, I need to create an analysis where I am reporting on Direct Reports who have absences. What d… -
Termination Report not picking up Terminated EmployeesSummary Timing off between termination and reportContent We are new to Oracle and are looking for a solution to the following issue. We run a Termination Report every Mo…
-
Absence taken between two datesContent Afternoon all, I've trawled these forums and have scoured the report Sharing Centre and cannot find something which i thought was an easy ask: I have an absence …User_2025-01-28-05-39-23-766 131 views 2 comments 1 point Most recent by User_2025-01-28-05-39-23-766 -
Element Entry ReportSummary Element Entry ReportContent Hello Experts, Wondered if anyone could help with xml/sql that will help me pull out all the element entries against all employees (i…
-
Table name to get Element CategorySummary Table name to get Element CategoryContent Hi Team, Can someone help me with the table name to get the "Element Category", i was able to get this information inOT…
-
Empty Data Set ProblemSummary Empty value effects all Data Set valuesContent Hi All, We have one Data Model which using 4 data sets for creating report. All data sets are connected between wi…
-
Learning Analysis Need Column for Last Job ChangeSummary Find the date the colleagues Job Title ChangedContent How do I add a field to an analysis for Learning Module that will show the correct date the colleague's Job… -
Bargaining Unit (Name) - Table and Column ?Content Hello Everyone, I'm trying to build a BI Publisher Report (complex requirement therefore cannot utilize OTBI) and I am requiring Bargaining Unit field, or to be … -
SQL for Element Status Processing RulesSummary SQL for Element Status Processing RulesContent We are looking for a SQL to display element status processing rules where we attach the element to a fast formula …
-
Need Logic/Query to get base element_type_idSummary Need Logic/Query to get base element_type_idContent Hi Team, Need logic to get the Base element_type_id from Earnings results element. Ex: Currently i have Regul…
-
How to get the Person Number for WHO Columns Like Salary Last Updated BySummary How to get the Person Number for WHO Columns Like Salary Last Updated ByContent Hello Everyone, I am looking to get the person number for the WHO columns like Sa…
-
Oracle Report Jam at Collaborate 2019: Here to Build Your Reporting ConfidenceSummary April 8-10 2019, San Antonio TXContent Come and meet reporting experts from across Oracle HCM product development who can build a report with you, answer your re… -
MonthName function not WorkingSummary MonthName function not WorkingContent Hi All , I am trying to get the Month Name (Jan / Feb / Mar) from a Date entry - Eg -I'm using the following function - Mon… -
Person Profile Report - Reduce Number of RowsSummary How can we combine the row data per employee?Content We have a requirement for a report which HR can use to view employee's person profile data: certifications, … -
Increasing Export Limit into Excel, CSV, XML, etc.Summary Is there a way to increase the row limit when exporting to Excel, CSV, XML, etc.?Content Is there a way to increase the number of rows that can be exported out o…
-
Error when Filtering Logical SQL Report off OTBI ReportSummary Obdc Driver Error when filtering based off OTBI ReportContent Hello, I'm currently trying to filter a logical SQL changes report based off an OTBI Analysis that …User_2025-01-31-00-25-12-234 38 views 3 comments 1 point Most recent by User_2025-01-31-00-25-12-234
-
Limiting Results of Reports Based upon Data Security Level DefnintionSummary Limiting Results of Reports Based upon Data Security LevelContent We have custom HR roles which limit some users from functions and AORs used for approvals. Is i…
-
Any way to query a table to capture the IP Address of user logging in?Summary IP Address of user logging in?Content I have been asked if it is possible to provide a report of users logging in to HCM Cloud over the past 30 days and provide … -
probation confirmation Letter automation in oracle fusion HCMSummary Probation Confirmation letter Automation in Oracle fusion HCMContent Hi Team, I have to create the bursting report, in which whenever probation status for an emp…
-
Probation Confirmation letter Automation in Oracle fusion HCMSummary Probation Confirmation letter Automation in Oracle fusion HCMContent Hi Team, I have to create the bursting report, in which whenever probation status for an emp…
-
Using Max function for bank account highest process orderSummary Issue with using MAX for selecting highest processing order (Priority) within PAY_PERSON_PAY_METHODS_FContent Hi, We are setting up an extract of bank accounts w…
-
How we can export data from Infolets ?Summary If a table is displayed at expand view and we need to export it. Is there any way ?Content Hi All, We are displaying the data of manager reportees on the expand …
-
Significance of default Data Source 'AuditDB' in BI PublisherContent Hello What is the Significance of default Data Source 'AuditDB' in BI Publisher while creating the new data set. My Oracle Cloud Application is: 19A (11.13.19.01… -
REPORT EMAIL DID NOT RECEIVEDSummary REPORT OUTPUT DID NOT RECEIVED VIA EMAILContent Hello, We have existing BIP report job which runs and deliver report output via email. And today few customers re…
-
Row disappearing in the output of RTF when the XML group tag is not thereContent Hi All, I have built one RTF template and have 5 fixed absence plans. If any of the plans is not there then the row is not appearing in the output file. My requi… -
Need OTBI RpdSummary Need OTBI RpdContent Hi , I believe if we install BI Apps (OBIA) we can get RPD which has OTBI subject areas. Can some share OBIA/OTBI Rpd. I am mainly looking f…User_2025-01-29-21-55-25-526 38 views 5 comments 1 point Most recent by User_2025-01-29-21-55-25-526
-
Dashboard prompt returned error (Failed to load (Odbc driver returned an error SQLExecDirectW).)Content Currently I am using SQL Results option to populate value of a dashboard prompt called "Global Job Band".I am using below SQL code for this : Select SUBSTR ("Gra…User_2025-02-04-22-00-05-391 46 views 2 comments 1 point Most recent by User_2025-02-04-22-00-05-391
-
Employee Self Service: how do you show employees their salary history?Summary Employee Self Service: how do you show employees their salary history?Content Hi, Our team would like to display an employee's own salary history on the Personal…
-
Minimum Wage and Salary AuditSummary Is there a report or a way to mark employees as non-compliant with minimum wage and minimum salary.Content Hi, Has any one ever created a minimum wage/salary rep…