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 have a report send email that report is ready to be viewed in checklist?Summary: We would like to have a report send notification that the report is ready to be viewed in checklist. But, we do not wish to attach the report output to that ema… -
Based on the parameter year i should get the data based on that year i should get the data.lets say the paramter is audit_year = '31-12-2021' the requirement is something that we should get the data based on the parameter i.e i should get the person record bas… -
Help Needed: Retrieving Current Address for a Legal EntityHi Everyone, I'm trying to retrieve the current address for a Legal Entity, but I'm facing challenges in identifying the correct tables and joins. Context: I understand …
-
Object Validation Rule for Salary Adjustment Percentage not supporting as expected.Summary: Object validation rule for Salary business object is triggering for conditions where Salary.Adjustment Percentage should generate error message. Condition is se… -
Data Security Policy is not working for the custom role which has Purchase Analysis role addedSummary: We have created a custom role by copying it BI Consumer Role, We have also added the Purchase Analysis role under this custom role so that users can access the … -
How to customize the seeded deduction report?Summary: We would like to add additional columns like assignment status to the standard deduction report that runs part of the payroll flow. What is the recommended appr…
-
Manager information regarding the last active assignment of inactive employeesHello, In Oracle HCM system, the manager information of the employees who left the job is emptied, therefore the managers of the inactive employees are empty in my repor… -
Request Documentation on Critical PVOs for Oracle Fusion HCM Integration with Data LakeDear Team, We have recently implemented Oracle Fusion HCM and are now working on integrating it with our Data Lake. To better understand the critical PVOs required for t… -
Report that identifies when an employee becomes a manager of peopleSummary: Is there a way to build an report that will identify when an employee (non-manager) becomes a manager (people leader). We utilize the "Working as a Manager" fie…
-
OTBI report available for employeesSummary: OTBI report available for employees Content (please ensure you mask any confidential information): Hello, we have configured a guided journey which is visible i… -
Learning Users Showing Different Output in OTBI ReportGood Day, We have 2 learning users running the report in OTBI but they don't have the same report output. Example, user1 showing 10K rows while user2 only retrieving 8K …
-
Impact in the reports/dashboards after enabling RedwoodHave you encountered any issues with Reports/Dashboards after enabling Redwood across the HCM modules? Is there any documentation or impact analysis available for this?
-
HCM report for monitoring access visibilityHi All, As a part of Executive and above (10,000+ employees) salary migration to the Fusion system, we are planning to introduce controls on salary visibility and access…
-
Rolling Average Wage ReportHi Does anyone have a sql query or a report that provides the average weekly wage over a 52-week period based on a specific date? We are trying to provide our Workers Co… -
Workforce Goals - Goal Tasks Real Time 'Development Goal.description same as 'Task Name.description'Creating a simple analysis to report each development goal along with it's associated task(s) by using the Workforce Goals - Goal Tasks Real Time subject area. The 'Deve…
-
Current and Previous name of employee - logical SQLSummary: I am trying to build a report which should pull current first name, last name and previous first name and last name of employee using logical SQL but it's not w…
-
Standard PL/SQL API Caching ErrorWe use SOA to expose a PL/SQL procedure as a REST API and post requests to it. This procedure utilizes standard PL/SQL APIs to create and update Person and Assignment re…
-
How to report on details held in Past Incumbents section of Position DetailsSummary: We need to add some of the fields held in 'Position Details' into an existing report but cannot find within any tables columns that correspond to the fields vis…
-
Multi Language update to existing OTBI reportsSummary: Multi-Language: How would you create or update existing reports to pull in any language? Is there a way to update all reports simultaneously with the option to …
-
SQL to extract location mailing addressSummary: Please could you let me know the SQL to extract mailing address that is stored in Manage Locations task. I have checked in the HR_LOCATIONS table but I cannot f…
-
Can you help me to adding the name of the employee in this SQL query?Summary: Hello team! I have this code, but I don't know how to add the name of the employee. Could you please help me with that? Content (please ensure you mask any conf… -
XSLT Template Add Day to DateSummary: XSLT Template Add Day to Date, There is a date to which we need to add two business days (excluding weekends) and display in the output. in XLST Template only. …
-
OTBISummary: Hello Everyone, Unable to access OTBI reports data, able to access BI reports using her current roles Thanks Krishna Content (please ensure you mask any confide…
-
Emails with analysis tables are putting in extra spacingSummary: We have analysis that displays jobs that were posted in the past week. We send this report to users via email and have the data displayed in the body. The data …
-
How to encrypt and decrypt images in Oracle fusionSummary: How to encrypt and decrypt images in Oracle fusion Content (please ensure you mask any confidential information): Hi All, We got a requirement to encrypt and de…
-
how to personalize / customize all Oracle HCM notifications - my changes are not showingSummary: Customer requirement is to personalize all HCM notifications for users. The requested changes are the following: - place their logo in all HCM workflow notifica…
-
SQL query to fetch number of direct reportees to a line managerSummary: I want to build a BI report where I need to fetch the count of direct reportees to the Line Manager. Content (please ensure you mask any confidential informatio…
-
Does SFTP setting done in Production is copied over to non-production environment during P2T?Dear Experts, Can someone let me know if SFTP setting done in Production is copied over to non-production environment during P2T? Please share oracle documentation for r… -
SQL to get number of Grades in a Grade laddersSummary: I need SQL to get number of grades contains in all the grade ladders that organization is having. If anyone having it please share Content (please ensure you ma…
-
BI Publisher - RTF Template - Numbered List in Offer LetterSummary: Hello everyone, I am new to build the BI Publisher, I would like to check a feasibility for my client requirement. My client offer letter has a numbered list e.…