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
-
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… -
Generate barcode in PDF outputContent Hello, I am trying to generate the bar code in a RTF template with an output as PDF. When I use the output as HTML or any other the bar code is printed correctly… -
Recover Deleted Report or FolderSummary How can I recover a deleted report or folder in any environment after deletion?Content Hi all, I would like to know if there is a recover option when a report or…
-
Emergency Contact Details Report - Required Duty/Data RoleContent Hi All, We have created Emergency Contact Details Report from Person Subject Area to support our Business Continouity agenda (attached). We have two custom roles… -
Workforce Management - Position Real Time - Missing Assignment CategorySummary Unable to find Assignment Category field in Position Real Time subject AreaContent When creating a position, we are using 3 fields on the setup - Assignment Cate… -
Need past 8 years historical data based on a effective date-OTBI analysisSummary Need past 8 years historical data(Counts based on their color) based on a effective date-OTBI analysis, We need to show data in a Graphical format attached.Conte…
-
AAP - Disablity Self Disclosure field in OTBI analysisSummary AAP - Disablity Self Disclosure field in OTBI analysisContent Hello, Like many of us, we are getting ready to do our annual AAP reports. For Disability Self Disc…User_2025-02-04-15-06-22-759 45 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle
-
Absence Report showing Annual Accrual, Carryover and remaining balanceSummary Require a report that will show the employee absence information for reporting purposesContent Hi All, I need some help in trying to figure out where my numbers …User_2025-02-04-08-51-08-912 483 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
Trying to embed a dashboard on shared My Team PagesSummary Trying to embed a dashboard on shared My Team PagesContent On the Manage my team absence balance page (We have renamed this to Time Off Balances) I have embedded…
-
Current Performance Document TaskSummary Looking for a report showing only the current document taskContent We are looking for a report, one line per employee, that would list the current step that thei…
-
Selecting All outputs in ESS Job by default?Summary Selecting All outputs in ESS Job by default?Content Hi All, I have created a report with 6 templates and i have created ESS Job for it. I can able to select all …
-
Is there any way to connect Oracle Fusion OBI from SQL ServerContent H Is there a way to connect to Oracle Fusion OBI server to our local SQL Server? We would like to report on Data in conjunction to our local HRIS system. Thanks,… -
Data Models Best PracticesSummary Are the Best Practices for Building Data Models using Tables vs. ViewsContent Wondering if there are best practice guidelines for building Data Models? For examp… -
How to get the Latest Hire Date of Employee and compare the same with DFF attribute in OTBI AnalysisSummary How to get the Latest Hire Date of Employee and compare the same with DFF attribute in OTBI AnalysisContent Hi All, We have a DFF attribute called Beneficial ser…
-
Combining Pay Dates in a ReportSummary Need to combine all Results by Date Paid into one Number by MonthContent Greetings, I have a detailed pivot table that displays the run results by pay period by …
-
Need to display Hire details from last six months in OTBI reportContent Hi All, We have a requirement to display HIRE Employees from last six months in OTBI report. In OTBI analysis we selected "Workforce Management - Worker Assignme…
-
SUBSTRING & DESCRIPTOR_IDOF Conditions in OTBISummary SUBSTRING & DESCRIPTOR_IDOF Conditions in OTBIContent Hi All, Can some one explain to me that how does the below conditions work and what's the in detail meaning…
-
Want to subtract two dates for absence leavesSummary Hi all, I am trying to create a column with the total days in an absence.Content I am trying to subtract the start and end dates of the leave to create that info…
-
Caution -> Inappropriate Content through re-direct links in Sample OTBI Dashboard (change link for cContent Hello, The seeded 'Sample OTBI Dashboard' (Profiles / Assignment Details and Drill to Person Gallery') has a link which goes to 'inappropriate content'. I guess … -
OTBI Custom Reports - User Interface Language Issues (English vs French)Content Hello, Can anyone please help me with these two questions? 1) created a custom report (based on seeded SubjectAreas) and renamed the columns in English. When Use…