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
-
Back end table name for "Hourly Paid or Salaried"Summary Backend table and column name for Oracle HCM data element "Hourly Paid or Salaried "Content Good Afternoon, Does any one know back end table and column name for … -
TopicSummary Ora TestContent Testing topic comm
-
OTBI - Manager person number as the main keySummary Is it possible to refer the manager person number as the primary key in OTBIContent Hi, Can I make a report in OTBI so all the fields (assignment status, job, de…
-
Error when consulting a report with parameters of start date and end dateSummary Error when consulting a report with parameters of start date and end dateContent Hi everyone, I have created a report that must show information according to two… -
Percentage of columnSummary Need to calculate a percentage off Median salary by various attributesContent Attached sample. I can get the first 4 columns. However, I can't come up with the r…
-
BI Publisher - tracking of an email notificationSummary Schedule Report JobContent Hi All, One of users has complained about some of their scheduled processes not sending email notification even though she filled up t… -
column information for PAY_ACTION_INFORMATIONSummary PAY_ACTION_INFORMATION Developer DFF Columns detailsContent I am looking for details on action_information1...300 columns in pay_aciton_information. what data is…
-
Finding the Right User for AgentContent Hi all - I am creating an agent to send a report to a user. When I go into the Select User screen and search users, there are times where more than one option co… -
Unable to get results when pulling Grade data in with Job Structure dataSummary Report fails when fields from Grade Rate Real Time are pulled inContent Using two subject areas: Workforce Profiles - Model Profile Real Time and Workforce Manag… -
Drill back using SQL query from GL_JE_LINES to PAY_COSTS tableContent We are building a report to get the related Pay Cost data from the GL Journals that gets created after transferred to GL. We have few documents for EBS which men… -
Manager Details (more than one)Summary Writing an OTBI Report which pulls all of an employee's managersContent Hello, We record two managers for each employee at our company. One is the line manager a…
-
CEO - Historic DataSummary CEO - Historic Reporting IssueContent Hello We have setup infolets in our environment for 5 Year Historic Trends (IE Turnover/Gender Distribution/Etc.). When our…
-
Mandatory Parameters in BI PublisherSummary Mandatory Parameters in BI PublisherContent Hi, How can we make the parameters as mandatory/required in a BI Publisher report ? Thanks, Nitin -
Going to Collaborate 19 conference? Want reporting help?Summary April 8-10 2019, San Antonio TXContent Come to the Report Jam room (305) and meet Oracle HCM Product Development who can help you with your reporting needs. Cont… -
Check for duplicate Position Codes using COUNTSummary Show count of position code to identify duplicatesContent Hi, I am using the Position Real Time subject area and I'm trying to determine which position codes are…
-
Session Timezone in BI PublisherSummary BI publisher not using the timezone from the Account screenContent I've found that the CURRENT_DATE in BI Publisher isn't applying the timezone entered on the us… -
How to get the Top Down Manager Hierarchy in OTBISummary How to get the Top Down Manager Hierarchy in OTBIContent Hello Everyone, Currently we are looking to fetch top down manager hierarchy in one of our OTBI reports …
-
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…
-
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… -
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…