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
-
HCM BI Report - table to extract value set data (table type)Summary HCM BI Report - table to extract value set definition (table type)Content Hi, I'm creating a BI report to show Value Set Definition (Table Type) and wonder which… -
Can we hide Factory delivered folders from Reports and Analytics based on role?Summary We have a requirement to hide all the factory delivered folders except Human Capital Management from Reports and Analytics.Content Requirement is : When login as…
-
Table name for Comments in a Learning CommunityContent For every learning community, members can comment using the seeded Comments functionality. We have a requirement to report on the comments made by the users. We … -
what are the duty roles for viewing worker detailsSummary what are the duty roles for viewing worker detailsContent Hi - Already have the following duty roles added to the custom role: 1. Workforce Profile Transaction A… -
Transpose rows to columns in OTBISummary I need to build a report that shows every employee as a column. Convert all rows to Columns in OTBIContent Hi I hope you can help me. I need to build a report th…
-
how to get read only access to reports and analyticsSummary how to get read only access to reports and analyticsContent Hi Team - I need to grant only read access to Reports and Analytics page...With this grant,the user s…
-
How to link consecutive absences with same absence type together in an analysisContent We are not using OT&L and have an interface bringing in absence hours into Oracle HCM. The absences are stored in 1 day intervals so when we have employees on a …
-
In process Termination ReportContent Has anyone developed a report that shows terminations in process and who it is currently pending approval with? Ideally we'd like a report that includes date/tim…User_2025-01-28-07-43-27-066 43 views 3 comments 1 point Most recent by Raghavendra Raghunath-Oracle -
Get the list of persons included in an Access Group for a Learning OfferingContent Hi everybody, for an Offering in the Learning Catalog I have created an Access Group. I would like to extract from HCM tables the list of persons that are includ… -
SQL Filter for the System Date (current Date)Summary SQL Filter for the System Date (current Date)Content Hi All We need to Create an OTBI report filter for the current system Date. The original requirement was to … -
Deriving IS Manager column in OTBISummary Deriving IS Manager column in OTBIContent Hi ALL, I'm building OTBI Report. And I want to derive column "IS MANAGER" ( Note we are not maintaining in WorkerAssig…User_2025-02-07-19-03-14-525 53 views 4 comments 1 point Most recent by User_2025-02-07-19-03-14-525
-
How to Incorporate a Person Number Dynamically in the "Email Subject" using OTBI AgentContent We are trying to trigger an email alert using OTBI Agent, with a subject line which should pick up the person number from the analysis we have created. However, …
-
Rel 20B (11.13.20.04.0)-> No data for Pending Workers in 'Workforce Management - Checklist Real TimeContent HCM OTBI Prod Dev Team, Can anyone please confirm if the issue documented in Doc ID 2600452.1 (https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-… -
Reporting on Active User Role EmailSummary Email address for non-employee active user.Content Hi, I am developing a BIP report for Non-Employee Active User. But cannot find the table email address that wa…User_2025-02-04-07-19-57-588 51 views 4 comments 1 point Most recent by User_2025-02-04-07-19-57-588
-
OTBI - change field from text to numberSummary Changing text format fields, which include number values, to number formatContent Hi :) I have a report which shows information on Element Entries. The input val…
-
Employee Self Service Transaction reportContent Hi, I`m trying to find the subject area for self service transactions - we need to ensure that for a period of time some employees aren`t putting through self se…User_2025-02-06-11-18-47-896 51 views 3 comments 1 point Most recent by User_2025-02-06-11-18-47-896
-
Pay Period Start & End Date IN BI ReportSummary Pay Period Start & End Date IN BI ReportContent Hi ALL, Can someone help me, I'm looking for Pay Period Start and END Date. Which table do i need to refer to get…User_2025-02-07-19-03-14-525 38 views 4 comments 1 point Most recent by User_2025-02-07-19-03-14-525
-
No fact table exists at the requested level of detail (Assignment and DoR SAs)Summary [nQSError: 14025] No fact table exists at the requested level of detail (Assignment and DoR SAs)Content Hello, Just wondering if anyone faced this type of issue …
-
Any way to restrict BIP output file either with Datamodel name or Template nameContent Hi All, When we click on OPEN on BIP report and enter required parameters and then click on apply button it will generate output in Excel format as DatamodelName…
-
Formatting Code appearing in some columnsSummary Success Criteria & Comments ColumnContent Hi, I've just ran a Goals reports from the Workforce Management - Goals Tasks Real Time and found lots of formatting co…
-
Salaries in WordsSummary I Need to put in Word Template the Salaries in wordContent I need to put in template WORD (bi publisher) , the salary in full (Words) can someone help me?
-
Set default parameter for date to SYSDATE in BIP Data ModelContent Hello I have a date parameter in my BI Publisher Data Model, and I would like to set it by defaut to today's date. I tried using CURRENT_DATE and SYSDATE but it …
-
Adding Case Statement to Existing Data ModelSummary Need assistance with case statementContent I am in need of assistance with the following: (1) case statement syntax and (2) adding a case statement to an existin… -
Get legal entities addresses in a BI Publisher Data ModelContent Hello, I am creating letters templates based on a BI Publisher Data Model. Inside these letters I need to put the address of the employee's legal entity. Is it p…
-
Assignment Status in BI ReportSummary Assignment Status in BI ReportContent Hi, I want to find out table field in BI Report which hold value Assignment Status = "Active Payroll Eligible" or "Inactive…
-
List of Succession Plan for a personContent Hi all, I am trying to get a list of all succession plan where an employee is active. Thank you! -
Date Prompt QuestionSummary As Of Date Prompt QueryContent Hi, I have a number of reports that use the SET VARIABLE PARAM_EFFECTIVE_DATE ='@{AsOfDate}'; that work correctly up to a certain …User_2025-02-05-22-44-35-842 54 views 28 comments 1 point Most recent by User_2025-02-05-22-44-35-842
-
How to display Active employees count month wiseSummary How to display Active employees count month wiseContent Is there any way on calculating employee count by month in OAC. The starting point is an Employees table …
-
Daily Breakdown ProcessSummary Workforce Management Absence Calendar Details Real TimeContent Hi, I've received a request to build an absence report using the 'Workforce Management Absence Cal…User_2025-02-05-22-44-35-842 37 views 8 comments 1 point Most recent by User_2025-02-05-22-44-35-842
-
Row limits in OTBI ReportSummary Row limits in OTBI ReportContent Hi ALL, I have created OTBI Report based on Logical SQL. When I run it for one of the employee I see his data being populated wh…User_2025-02-07-19-03-14-525 113 views 9 comments 1 point Most recent by User_2025-02-07-19-03-14-525