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
-
how to create an OTBI Report to extract Employee details who do not have Line Manager RoleSummary OTBI Report to extract Employee details who do not have Line Manager RoleUser_2025-01-29-02-01-53-212 61 views 7 comments 0 points Most recent by User_2025-01-30-20-59-13-989 -
Job DurationSummary Provides the duration of the workers in a specific jobContent This analysis provides the duration(in days) of the workers in all the jobs that they have held so … -
Learning Assignment Event TypeContent Hello Experts. I need to do an Analysis that gives me if the course assignment is Required or Voluntary. I was Unable to map it into the Workforce Learning - Lea… -
OTBI for enrollment in OLC - Selection of one Department in One locattion and All Departments in AnoContent Hi there, I am using OTBI report for enrollment in OLC. I need to create a report that includes - All the Departments in Location A and - One Department in Locat… -
OTBI - Reporting Monthly Net Pay ValueContent Hi all, Does anyone know the correct subject area and field to use in order to report on the net pay value an employee would receive? I've been looking at the fo… -
Reporting on Termination and Performance Review Data in the same analysisSummary I am trying to pull a report that shows employees performance review rating before their termination as well as their termination reason.Content I am attempting …
-
Is it possible to created Facts/Measure in Logical SQLSummary Is it possible to created Facts/Measure in Logical SQLContent Hi all, I need to pivot and show percentage of a column but seems like it is not possible to create…
-
Oracle BIP DataModel -> Default views 'Table View' and '200' rows - PossibleSummary BIP Default ViewsContent Hello, Just wondering if there are any default settings available to achieve 'Table View' and '200' rows. Attached a picture. I don't an… -
Report: Avg. Time in Job/Job Family/Grade/Position throughout the years - using current and past yeaContent Hi all, I'm looking to create multiple analyses that will show me the average time that employees have remained in a job/job family/grade and position throughout…
-
OTBI report link creation for End usersContent Hi Team, We have created an OTBI report and given its link in the folder for the end user to click so that it will take them directly to the report. The problem … -
OTBI - Workforce Performance - Performance Rating Real Time > Average Calculated Manager Section RatSummary We have a requirement to report on both the submitted Perfomance Rating as well as the Calculated Perfomance RatingContent We have a simple Report that shows the… -
BI Data Model: finding all reports that this is attached toSummary How to know all the reports that use xyz data model?Content Hello, I have a data model in BI Publisher. I assume 3 reports are connected to it. But how can I be …User_2025-01-28-21-53-32-678 30 views 3 comments 2 points Most recent by User_2025-01-28-21-53-32-678
-
Performance document analyses with CommentsContent Hello Experts I need to do an Analyses with Performance Rating and Comment given. In Analyses Performance Rating real time, any of the Comments Field there retur…
-
When bursting a BI report gives error NearSummary I am trying to bursting a BI report with data source as Oracle BI EE by converting OTBI to BI query it is giving error [nQSError: 27002] Near
-
BIP Report job's output in PDF format is not getting downloaded but opened in the browser.Summary BIP Report job's output in PDF format is not getting downloaded but opened in the browser.Content We have created a report with bursting logic to split a pdf fil…
-
Deliver OTBI report to SFTPContent I could see there is limitation in sending OTBI report output to SFTP folder. Is there any workaround that is being followed or is it just via BIP report? -
OTBI Report error for employeesSummary OTBI Report error for employeesContent Hi Team, I have enabled a HCM infolet to show personal details and is working fine from admin user. but when custom employ… -
Conditional Logic in RTFSummary Conditional If-Then-Else and Looping logic in RTF TemplateContent Hi All, I am trying to add conditional logic, specifically using If-Then-Else statements, in an… -
BIP Data Sources accessSummary BIP Data Sources accessContent Hi Experts, Does anybody know if it is possible to restrict access to the Data Sources in the BIP data model UI? I appreciate any … -
Employees with Leave Status within a Specific MonthSummary Employees with Leave Status within a Specific MonthContent We are tracking leaves through Manage Employment using Action and Assignment Status. Our HRBPs would l…
-
Audit DahsboardSummary Need help finding Audit DashboardContent I remember seeing Audit Dashboard. I can't seem to find it. Does anyone know is there a Oracle delivered Audit Dashboard…
-
Edit Grand total in pivot tableContent Hi there, we made a Pivot table in OTBI analysis with pay elements in column. We have been able to add the Grand Total of them but we would like to exclude an el… -
Department HierarchyContent Hi all - I have a great report that we use for Department Hierarchy through OTBI, but we need this report through BIP. We have users that will pull this data the… -
Compensation Components table for BIContent Hello experts, do you know the Oracle tables to extract compensation components values and components name? Thanks in advance for your time! Kind Regards, Valerio -
Requisitions with Inactive ManagersSummary Is there a report showing requisitions with inactive managers?Content Hi all, I am developing a report to identify requisitions with inactive managers, so that w… -
Payroll-Calculation Cards Real Time OTBI SA issueSummary Payroll-Calculation Cards Real Time OTBI SA issueContent HI, We have a issue with "Payroll-Calculation Cards Real Time" SA. I am picking the Calculation Card :'S… -
SQL Expression on column filter in OTBI reportContent Created a headcount report and looking for a SQL Expression for a column filter so I can generate the report based on current or system date employee start dates…
-
Table(s) that store Persons Language, Degree, Prior Work Experience, Licenses/Certificate InformatioSummary Looking for the hcm tables that store Person info such as Language, Degrees, Prior Experience, LicensesContent Hi, We want to create data model(s) to pull the Pe…
-
Hours worked counted by Calendar Weeks LogicSummary Need help with logic to count hours worked based on calendar weeks worked for 401K vendorContent Hi Friends, We have a requirement where our 401K plan requires h… -
Query to fetch BIP report job historySummary Query to fetch BIP report job historyContent Hi Team, Is there any query from table to fetch the BIP report Job History. Thanks, Sourav