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
-
exceeds the maximum limit error even after using filterSummary: exceeds the maximum limit error even after using filter Content (please ensure you mask any confidential information): Hi Team, Greetings! We are getting below … -
Payroll query that fetches results only if for the Employee Generate Payslip flow is not run.Summary: I need to create a BI report which retrieves Employee Information of the users along with other Common columns also needed to see if whether is employee get pai… -
Query to find fusion user details with their rolesI need to create a BI report which retrieves user information like user_id,username , email of the users along with their role information like role_id,role_common_name,… -
Remove Manager role from Worker self-evaluation Performance TaskSummary: Hello, I need help to check if my case statement below is correct. I encountered errors several times so I'm not sure what is the problem with this. I want to i…
-
Unable to pull salary amount into OTBISummary: Hi, I am currently building an OTBI report and I am unable to pull the Salary Amount into the report. The report is crossing multiple subject areas and I have i…
-
hide an RTF hyperlink field on notification report conditionallySummary: Hi forum and BI Publisher Experts: i wish to hide a URL hyperlink only when ( 2 ) previous data model person number values (will not be shown on report) are equ…
-
How can I export list of delivered reports for fusion HCM?Summary: Where can I find list of core delivered reports for fusion HCM modules. Content (please ensure you mask any confidential information): Version (include the vers…
-
Newly created prompt by one user not seen for other userWe wanted all BUs to be by default selected when LM Dashboard is opened up. So we modified the existing prompt by removing the filter of selecting the topmost BU. When c…
-
REST API for Salary, Payroll elements and StocksSummary: Content (please ensure you mask any confidential information): Hello experts, do you know where retrieving REST API for Salary, Payroll Elements and Stocks? Kin… -
I'm unable to upload rtf template in report or it is showing uploading since long timeSummary: I'm unable to upload rtf template in report or it is showing uploading since long time. Content (please ensure you mask any confidential information): Version (…
-
Can I report on whether learners have uploaded a file into their learning assignment?Summary: I'm trying to create a report that shows me which learners have uploaded a file into their learning assignment for a particular course. In their enrolment the l…
-
Guidance on OTBI Report for Transaction Summary by RegionSummary: OTBI Report for Transaction Summary by Region Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to extract tra… -
Fast Formula doesn't return expected valueSummary: Content (please ensure you mask any confidential information): Hello, we built the following FF where we should retrieve value from two different value sets. If…
-
Subject Area for Exit interview survey Responses --> Which Subject area to use ?Subject Area for Exit interview survey Responses --> Which Subject area to use ?
-
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…