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
-
SQL to find jobs with Approval rules tiedSummary SQL to run in BI to find the jobs that are tied with approval rulesContent I would like to find the list of jobs that are tied or used in the Approval workflows.… -
Password Protecting BI Publisher Reports - Password ChangingSummary BIP Scheduled reports password changingContent Hi all, I've created a few BI Publisher reports with passwords and they've worked fine on the first part of the sc…User_2025-01-31-00-25-12-234 68 views 4 comments 2 points Most recent by User_2025-01-31-17-49-32-187 -
Line Manager to access previous worker too through reports.Content Hi Experts: We have this requirement where Line Manger should be allowed to access previous worker as well through the reports, analytics on the LM dashboard. Bu… -
Monitor an approval process:Content Hello, We need to build a report to help monitor approval processes within the system. Currently it seems there is no way to monitor the approvals … Is there any… -
Analysis giving female managers as a percentage of headcountSummary Analysis giving female managers as a percentage of headcountContent Hi I've written an analysis that returns the assignment headcount for female managers for my …User_2025-02-06-09-29-18-902 64 views 5 comments 0 points Most recent by User_2025-02-06-09-29-18-902 -
When joining 3 subject areas in an OTBI report, is it better to add the common columns and hide themContent A client has requested help in joining 3 subject areas in OTBI: Talent, Recruitment, and Core HR. What we did was join all 3 subjects areas with common elements … -
Setting an 'As at' prompt for assignment data in OTBISummary I would like to be able to set a prompt that will bring back all the assignment data at a given point in time.Content I have some reports of worker data (grades,…User_2025-02-05-19-30-09-308 78 views 5 comments 1 point Most recent by User_2025-02-05-19-30-09-308 -
ORA-03113: end-of-file on communication channel error - Please HelpContent Hi All, In last few months, for the second time we are facing one quite strange issue. Random users, with random reports (or some user with all reports) are faci… -
I need help with building a report on Approved Job RequisitionsContent Hi, I have a requirement of building reports on all approved job requisitions. I have tried on my own but I can't really seem to get it right. Have any of you do…User_2025-02-05-16-50-03-083 33 views 2 comments 0 points Most recent by User_2025-02-05-16-50-03-083 -
-
19C New Subject Area: Security - Roles & Privileges Real TimeSummary Unable to view the 19C New Subject Area: Security - Roles & Privileges Real TimeContent Reading through the 19c Readiness document, there is the new SA Security … -
bursting querySummary Bursting QueryContent Hello. I had to build a data model for a report and RTF letter. The values in the letter are based on the attached SQL. When I run the repo… -
Error when Unarchiving a CatalogSummary Receiving an error when unarchiving a catalogContent Hi all, I am trying to unarchive a catalog but receiving the following error: - Compression - inflate Error …
-
Is it possible to get the dynamic file in BI Publisher?Summary Is it possible to get the dynamic file in BI Publisher?Content Hello Experts, In BIP, is it possible to show the run date including timestamp for the file name? … -
"Extract Workflow Tasks for Archive " processSummary OTBI report is not pulling curent data.Content Hi , We are in 19C patch . Ran "Extract Workflow Tasks for Archive " to archive workflow tasks. Ran this process c… -
Reporting performance differences between BI Admin & BI consumer rolesSummary We are seeing reports run much slower for users who only have a BI consumer role compared to BI AdminsContent We have been receiving reports from our end users t…User_2025-01-28-01-47-48-868 50 views 8 comments 1 point Most recent by User_2025-01-28-01-47-48-868 -
Questionnaire Reporting IssueSummary Report using questionnaire section not returning results as expectedContent One of our business units is using a questionnaire section in their performance revie… -
Customize dashboards with css filesContent Hello Guys, I need to customize my dashboard. Is it possible add a css file in the dashboard in order to personalize it? If is it possible, someone know How Can … -
Need SQL to get Email Addresses for all Managers in Supervisor HierarchySummary SQL to get Email Addresses for all Managers in Supervisor HierarchyContent Hi Experts I am looking for a query which can get me a list of all supervisor's email … -
Recruting Real TimeSummary Recruting Real TimeContent Hello. I have built a report using the Recruiting - Recruiting Real Time subject area. I need to filter by global transfer, external c… -
Group's drill errorContent Hi everybody, I created this analysis : It displays all of employees by country who have completed or is going to the Developpment Interview. This one is "Americ…User_2025-02-06-00-11-44-868 10 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle -
Issue with Flexfield name in BISummary The FF name in BI are not aligned with name in BIContent Hi, we are facing some issue on BI displaying FF name. Do you know how to fix? Please see the attached d… -
Present Headcount on part of World MapSummary Instead of having a world map I want to have e.g. only EuropeContent Headcount van be presented on a Word Map, but we have only Workers in Europe. Can we have a … -
Absence Calendar Details Real time Subject area Calendar view not showing Days absenceSummary Absence Calendar Details Real time Subject area Calendar view not showing Days absenceContent Experts, Created Team Absence calendar using the Absence Calendar D… -
Do Standard Job Roles have access to all Data?Content If an Employee has Job Roles like "Human Resource Analyst" or "Human Resource Specialist"? Will he has data access to all data or should we associate Data Role w… -
IT: Looking for analytic/report versioning best practices and tipsSummary I'm looking for advice and best practices on versioning reports, analytics, and dashboards in a repository.Content Hi everyone, I'm looking for advice and best p…User_2025-01-22-18-30-18-571 100 views 6 comments 7 points Most recent by User_2025-01-22-18-30-18-571 -
Conditional Formatting Not WorkingSummary Simple OTBI Analysis - I'd like blank cells to turn red. This isn't working and a couple of cells with data are red.Content Hi All, I have a basic issue that I c… -
Add Recipient in scheduled mail notification from OTBI analyticsSummary Add Recipient in scheduled mail notification from OTBI analyticsContent Hello All, We have 1 requirement to schedule mail notification to new joiners with Cc to …User_2025-02-05-07-43-29-505 53 views 5 comments 1 point Most recent by User_2025-02-05-07-43-29-505 -
Infolet Security Validating as False in ELSummary Infolet Security Validating as False in ELContent Hi, We created a custom role in HCM, but it continues to validate as FALSE, thus all users are able to see this… -
Report Analitics: extract list of all the eligible documents for an employeeSummary extract list of all the eligible documents for an employeeContent Hi to all, I need to extract, for a given employee, the content of "Manage performance document…