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
-
Learning - Reporting on RecommendationsSummary Would like to report on who recommended learning items and to whomContent I would like to create a report to show who recommended learning items and to whom. I h…User_2025-01-25-05-06-07-246 57 views 3 comments 0 points Most recent by User_2025-01-25-05-06-07-246 -
BI report Name change and path changeSummary Impact AnalysisContent Team, We have a request to change report name and path of few reports . These reports are scheduled already. Just wanted to know what woul… -
SQL Query to fetch Talent Profile History DataSummary SQL Query to fetch Talent Profile History DataContent Hi Experts, How to fetch Talent Profile History Data. Please provide SQL Query. Regards, Bala Version 20A
-
How to update the link for an embedded reportSummary Links for Embedded reportsContent Hi All, I am attempting to update the link for an embedded report after a recent copy from our production to test environment. …
-
Matrix Manager - Additional DetailsSummary Reporting on additional details of Matrix ManagerContent Hello Reporting Guru's! I'm wondering if anyone has found a way to report on a matrix manager's details … -
Reports got failed when scheduled in DEV3 completed in DEV2Summary Reports got failed when scheduled in DEV3 completed in DEV2Content Some of our reports got failed when scheduled in DEV3. On analysis we could see that the Data …
-
Payroll Balance Duplicating with Multiple AssignmentsContent Hi, I am trying to write a report in OTBI to pull Gross Earnings in a specific time period, and I am running into a problem where the amount is duplicating in so…
-
Identify users logged into the applicationSummary Identify users logged into the applicationContent Hi All, does anyone know if there is a report or process that can be run to check which users are logged into t… -
Using LIKE with FILTER() in an AnalysisContent I am trying to build a simple tile that gives the total number of employees with a job name that contains 'Director'. Example - 'Director of Compliance' I run in…
-
SQL to pull Previous Line ManagerSummary Sample SQL to pull Line Manager from the Previous Assignment RowContent We have created a data model that pulls most current assignment row where actions = Promo… -
OTBI Learning - Department, job, grade... at enrollmentSummary OTBI Learning - Trying to get department, job, grade... at enrollment date (Offering Start Date) instead of actual oneContent Hello guys, As per title, I am tryi…User_2025-02-05-11-42-08-011 60 views 3 comments 0 points Most recent by User_2025-02-05-11-42-08-011
-
Tables for getting user information under Security consoleSummary Query to get security console User infoContent Hi All, I am developing a BI Publisher report to get the User information that is available under Security console…
-
New Line of data for each variableSummary Just checking options available to prevent multiple lines if data in reportsContent Hi, I think I know the answer to this already but apart from using BI Publish…
-
How to identify resubmitted goals for approval?Content Hi, I am creating a goal status report where I am able to get proper goal status from the table HRG_GOALS with column GOAL_VERSION_TYPE_CODE except for those who… -
Is it possible to initiate HCM BI Publisher Reports from a batch script on a seperate server?Content We are hoping to integrate HCM to a custom EPM implementation using BI Publisher extracts.We are hoping to integrate HCM to a custom EPM implementation using BI … -
Ability to add hierarchy fields as Dashboard promptsSummary Unable to add hierarchy fields as Dashboard promptsContent I am trying to add "Hierarchy"."Level 1 Department" from Worker Assignment real time subject area as D…
-
Having more than 1000 values in List of Values for Parameters in BIP ReportSummary Need to have all option in Parameter for Manager Name in BIP ReportContent When we tried to have Manager Name Parameter with Select All value option in BIP Repor…User_2025-02-04-17-42-01-535 752 views 7 comments 0 points Most recent by User_2025-02-04-17-42-01-535
-
Hide options in cogwheel on embedded DashboardSummary As the title implies, we have a dashboard that we would like to hide some options on.Content Hi all, In the attached picture, we have two dashboards -- the botto… -
Reporting on employment contractsSummary New hires are still showing as pending workers in Employment Contracts Real Time subject area.Content I'm trying to write a report that will show all employees w…
-
Identify users logged into the applicationSummary Identify users logged into the applicationContent Hi All, does anyone know if there is a report or process that can be run to check which users are logged into t…
-
Using analysis as a sub query - many values for the IN predicate errorSummary Using analysis as a sub query - many values for the IN predicate errorContent Hi, Using OTBI analysis as a sub query for a field for the another analysis . While…
-
Briefing BookSummary Customization in content of Briefing BookContent Hello, We have created a Briefing book with combination of different analysis and schedule it. Struggling with b…
-
General BIP Report AssistanceSummary I have a series of questions about a BIP report I am trying to developContent Hi all, I just have a series of questions about BIP reports/Dashboards when embeddi…
-
User Role Historical DataSummary Getting the Historical data of RoleContent Hi, Is it possible to get the historical data of User Role in HCM? We are not using the End_date on the user role, but…
-
BI Report: Restrict Line manager access to only his/her reportees in BI Report in Fusion HCMSummary BI Report: Restrict Line manager access to only his/her reportees in BI Report in Fusion HCMContent Hi All, Please find below URL; https://youtu.be/XSt2S3xBBx0 T…
-
Logical SQL not recognizing Custom Fields in OTBIContent Morning all, I'm amending the Logical SQL for a report, but every time I try to reference our custom fields, the report errors out (see picture). It recognizes O…User_2025-01-28-05-39-23-766 30 views 4 comments 1 point Most recent by User_2025-01-28-05-39-23-766
-
(Under Oracle Review) Data Dictionary for ReportsSummary Create Data Dictionary for ReportsContent We want to have a data dictionary of our reports created Can this be pulled via SQL. 1. Path 2. Report Name 3. Report D…
-
How to link Person Real Time Subject Area with Workforce Management - Worker Assignment Event Real TSummary Is it possible to do this using logical SQL?Content Hi, I'm new to OTBI and I'm experiencing a lot of frustration regarding the Person Real Time Subject Area not…
-
Creating Charts in BI PublisherSummary Need resources on how to design charts on BI Publisher reportsContent I am needing to create some statistical charts from BI Publisher reports. I have gotten so … -
Error on Report Template - java.lang.ClassCastExceptionSummary In the data model, all is good, data is is showing but when I run the report template this error pops out "java.lang.ClassCastException". Please see attached ima…