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
-
License and Certification ListSummary Upload License and Certification listContent Hi Everyone, we are currently investigating whether it exists any documentation on most common “certifications” cont… -
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… -
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… -
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… -
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 … -
Status Changes with Assignment CategorySummary Need to get a report that shows both previous & current categoryContent Do any of you know of a way to capture the previous Assignment Category (full time, part … -
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…
-
Auditing Hierarchy Loops in Department TreesContent Hi Guys, Does anyone happen to have a report that is able to show hierarchy loops within a department tree? We do currently have a report that shows which manage… -
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… -
OTBI - Pivot with multiple information types (Email Type, Phone Type)Content Hi, We have a report with some personal information on it. Among other columns in report we do have Email (incl. Email Type) , Address ( incl. Adress Type) and P… -
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…
-
Populating the manager hierarchies for OTBI reportingSummary Provides the steps the populate the various manager hierarchies available in HCM OTBI Content This document provides details on the process that allows the custo… -
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… -
BIP report and sql injectionContent Hello Experts, While creating BIP reports in the Oracle fusion environment , do we need to consider Sql injection? If we have a BIP report that takes input value…User_2025-01-30-00-14-06-021 88 views 2 comments 2 points Most recent by User_2025-01-22-18-30-18-571
-
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…
-
Reporting on Termination Counts - An analysisSummary This post provides an explanation on the calculation of termination counts in OTBI.Content The post contains a brief synopsis and also a sample analysis xml to c…
-
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… -
Oracle Fusion Application - Usage StatisticsSummary Oracle Fusion Application - Usage StatisticsContent Hello, Can anyone please help me to capture usage statistics on Oracle Fusion Applications? I was using one o… -
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 …