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
-
HR_LOOKUPS vs HCM_LOOKUPS ViewSummary Need to know the difference between HR Lookup and HCM Lookup viewContent Can anyone let me know the difference between HR Lookup and HCM Lookup view. From view S… -
Oracle Gateway Error in OTBISummary Oracle Gateway Error in OTBIContent Hi Team, In our OTBI reports, we are getting the below gateway error Error View Display Error Odbc driver returned an error (…
-
Cant see reports saved in My FoldersSummary Cant see reports saved in My FoldersContent User has same roles and OBI privileges as me. When i save any personal analysis reports to My Folders i can see them …
-
BI Publisher model to find stuck transactions in HCMSummary Has anyone a data model that will find stuck transactions within the HCM moduleContent Has anyone developed a data model that will find all of the stuck transact… -
Reporting on Performance Rating from Compensation Subject AreaSummary When reporting on Ratings from the Compensation Module, it is returning ratings for employees for every year they have a rating. I am looking to report on only t…
-
Payroll Costing Report - Need to add additional columns in Summary Mode ReportSummary Need to add some additional columns in summary mode report which are available on Detailed Mode reportContent Hi , We have a requirement to add some additional c…
-
HR Specialists building reports with OTBI ? Looking for an HCM cloud customer referenceSummary Looking for HCM cloud customers who would have opened the possibility to build reports outside of a dedicated HRIS / reporting teamContent Hello, We at SGS have … -
Audit Report using BIPSummary Looking for a custom BIP report query for Audit purpose. #AuditContent Hi, We enabled the Audit for multiple products using the task 'Manage Audit Policies' and … -
Goal Setting StatusContent We need to create an analysis to capture the employee/ manager task status for the set goals. I have created one with the basis of Performance Task Real Time sub… -
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…
-
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 …
-
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… -
TopicSummary Ora TestContent Testing topic comm
-
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 -
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… -
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…
-
Workforce Trend Real Time Headcount DefinitionSummary How is headcount defined in this subject.Content Is there documentation on how the headcount fields are defined (i.e. Period End Headcount)? I'm playing around w… -
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…
-
Row numberContent Hi How to display row number in BI Answers , I am using Rank function but if any duplicate values comes then it does not gives me correct values. Thanks Rajesh
-
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… -
How to embed a OTBI Report in the landing pageSummary How to embed a OTBI Report in the landing pageContent How to embed a OTBI Report in the landing page - Need to access the OTBI Report from Landing page directly … -
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… -
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…
-
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? -
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…
-
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
-
Seated Line Manager Dashboard : Unable to see Termination (Hierarchy)Summary Line Manager is unable to see his/her TermsContent Hi There, We are working on using the Seated Line Manager Dashboard (Shared Folder --> Human Capital Managemen… -
Performance Task StatusSummary Is there a field within any of the subject areas in OTBI which can used to identify if an employee has shared their goals with their manager.Content Trying to id…User_2025-01-23-20-43-34-115 52 views 2 comments 1 point Most recent by User_2025-01-31-00-25-12-234
-
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 … -
Manager HierarchyContent Hi , Iam trying to create a employee hierarchy report (display complete employee hierarchy in a single row) using "Parent Manager" . Iam getting a lot of blank e…User_2025-01-25-02-10-14-549 123 views 17 comments 1 point Most recent by Raghavendra Raghunath-Oracle