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
-
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 132 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
-
How to add "Year" ,"Start Date" and "End Date" as prompt parameter in BI analysisSummary How to add "Year" ,"Start Date" and "End Date" as prompt parameterContent Hi. I am having one requirement in absence management where need to fetch the absence t… -
Worker Assignment Event history - job title "as of" assignment effective dateSummary Pulling data relevant to the history effective datesContent We have a report that is pulling all assignment events for an employee -- essentially a full summary … -
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…
-
Adding Subject Areas - errorSummary Using the 'Create Analysis' option and selecting 2 Subject AreasContent Hello, I am new to reporting and trying to use some of the out of the box features. The s…
-
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…
-
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…
-
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, … -
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 47 views 2 comments 1 point Most recent by User_2025-02-04-22-00-05-391
-
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…
-
Multiple Rows to Columns, from different FieldSummary Conver multiple rows into columns where the rows are generated by more than one fieldContent HI I want to convert multiple columns to rows, I'm trying to use piv…
-
Extract all values from Person Profile Content Type in single cellSummary I want the entire contents of an employee's "Skills / Areas of Expertise" in one cellContent Hello I'm looking for a way to combine everything an employee entere…
-
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…
-
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…
-
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…