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
-
Pivot tables and calculations for attritionSummary Issue with calculation column in pivot table - total leavers divided by total headcountContent Hello :) I'm hoping someone can help with an issue I am having. I … -
report to pull manager rating and participant reviewSummary report to pull manager rating and participant reviewContent Hi All, I have prepared two simple reports to pull manager performance rating and participants review… -
Excel output from RTF template is having one blank line in the topContent Hi All, I am using the RTF template to get the output in Excel format. I have used the page break to get the output in different sheets in excel. When the output… -
Extract or Report for Benefit Enrollment Files (834)Summary Has anyone developed an extract or report for benefit enrollment files (834)?Content Has anyone developed a report or extract to run benefit enrollment files (83…User_2025-01-23-23-19-37-647 151 views 2 comments 1 point Most recent by User_2025-01-23-23-19-37-647 -
Find Out a Person's Grade at a Particular DateContent Hi, I've been fiddling around with SQL but getting nowhere quick due to a number of factors. I'd like to keep it to SQL as my OTBI related permissions aren't 100… -
Outputting Dates (no timestamp) to Excel and keeping date formatSummary Outputting Dates (no timestamp) to Excel and keeping date formatContent Good afternoon. In our BIP reports, we have been removing the timestamp portion from date… -
Query taking more time to split,compare using regexp_substr() functionSummary Query taking more time to split,compare using regexp_substr() functionContent Hi , i have a report to get goal approvers names w.r.t. goal if pending with approv… -
Scheduled report doesn't have all rows. Stops at 25k rowsSummary Scheduled report doesn't have all rowsContent One of my OBTI report gives me 65k rows. IF i were to schedule this and deliver my excel2007+, it generates only to…
-
Workers Missing from Performance Document Eligibility Subject AreaSummary Population in Performance Document Eligibility Not the same as Assignment Real timeContent Hello, I'm trying to produce a simple report that shows the list of wo… -
Assignment Manager - Performance / GoalsSummary Issue with Displaying Performance / Goals with Assignment ManagerContent I cannot figure this out I have added the Assignment Manager to a report for Goals for L…
-
Performance Ratings report creates an additional line for an employee when both Employee and ManagerSummary How can I make both the employee rating and manager ratings appear on one line?Content When creating a performance report and I pull in both the manager and empl…User_2025-01-28-20-43-56-568 56 views 4 comments 1 point Most recent by User_2025-01-22-18-30-18-571
-
Some business unit employee data missing while working on Organization HierarchySummary Some business unit employee data missing while working on Organization Hierarchy in AnalysisContent My requirement is to count employees as per business unit nam…
-
Add pre-saved address emailsContent Dear comunity, I have a question about the possibility to saved a slot of email to a 'rubrica' when I have to select the destination of a report in the Business … -
One page entry with several dashboardsContent I need to enable one page entry for a specific user with several dashboards. I have created a page entry in the welcome page and now it is showing. Then how to s…User_2025-01-28-21-18-43-496 70 views 4 comments 1 point Most recent by User_2025-01-28-21-18-43-496
-
Send a report to SFTP siteSummary How to send reports to a SFTP siteContent Very new to Oracle, but wondering how we can send reports to SFTP sites? Is there a good reference material on this? Th…
-
Track user activity including AORSummary Track user activity including AOR over a periodContent Hello, We would need to track the active users in the system, especially the last login and the last actio…
-
BI publisher - How to add dynamic passwords to PDF outputSummary BI publisher PDF output - dynamic passwordContent Guys, Anyone know how to attach passwords in run time to PDF output generated out of BI publisher? The password…
-
Can you add a prompt to an analysis that uses a left outer join (or any join)?Content I have created an analysis that pulls in data from the "Workforce Succession Management - Talent Pools Real Time" subject area and the "Workforce Profiles - Pers… -
BI Report Output columns will shrink over one another.Summary BI Report Output columns will shrink over one another.Content I have created a Data Model with 75 columns. Now while i am creating BI report , i used option 'Gen… -
InfoletSummary The duplicate column is appering once click on the one of the column in the Trigger Report ( Expanded View)Content Hi All, I am facing the below issue can any on…
-
How to pass the string values from the dashboard prompt to analysisSummary passing string values to the analysis which is created from direct database request from the dashboard promptContent I am creating a analysis using direct databa…
-
ORA-00600: internal error code, arguments:Summary I am creating an analysis by Using direct database request.I am getting An error code: 00600Content I am creating an analysis by using direct database request.I …
-
Base table for Compensation Component ColumnsSummary Not able to find the base table which holds data for Compensation component columnsContent I am writing a BI Publisher report to fetch Compensation worksheet dat…
-
Report showing new managers with direct reportsContent Hello, We need a report that will show managers with direct reports and the effective date of when they had their first direct report assigned to them. This repo… -
BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the YeaSummary BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the Year ParameterContent Hi, This is related to earlier post: https…
-
BIP Publisher Bursting:Can we burst a consolidated pdf file (having all employee records) to a singlSummary BIP Publisher Bursting:Can we burst a consolidated pdf file (having all employee records) to a single email idContent Hi, In BI Publisher bursting, we usually bu…
-
OBIEE 11.1.1.9.0 Archiving: Difference between 'Keep Timestamps' and 'Keep Permission'Summary OBIEE 11.1.1.9.0 Archiving: Difference between 'Keep Timestamps' and 'Keep Permission'Content Hi, I need to know the difference between 'Keep Timestamps' and 'Ke…
-
Double Column PromptSummary Can we do double column prompt in OTBI like we can in data model?Content In data models, we can create double column LOV similar to... select description, id fro…
-
Add MTD in Employee active payroll balance reportSummary Add MTD in Employee active payroll balance reportContent We are trying to clone the Employee active payroll balance report and make few modifications in it. Alre…
-
Run Employee Active Payroll Balance report for All Balance levelsSummary Way to run Employee Active Payroll Balance report for All Balance levelsContent Is there any way to run the Employee Active Payroll Balance report for All Balanc…