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
-
Is it possible to add a time zone prefix to an OTBI report?Summary: If I want my OTBI report's data to only display one specific time zone no matter the user's preferences, how would I do that for just one report? Could the pref… -
Is there an API in Oracle that can extract the OTBI Analysis Criteria XMLSummary: We have lot of OTBI analysis which are being used for Learning initiatives/recommendations. These reports have filters on Organizational levels/Names. Whenever … -
How to link ANC_ABS_USAGE_RULES_F and ANC_ABSENCE_TYPES_F tableHow to link ANC_ABS_USAGE_RULES_F and ANC_ABSENCE_TYPES_F table select * from ANC_ABS_USAGE_RULES_F usage_rules where ABS_USAGE_RULE_ID =300000134481566 -- ABSENCE_TYPE_…
-
Page Composer Read Only FailureSummary: Attempting to mark the "Posting Description" field to "Read Only" using the following EL expression #{securityContext.userInRole['ST_HR_REC_ADMIN_SUPER_USER_TA_…
-
Payroll register dynamic BI reportI have a requirement to get the below records in payroll register report(dynamically). Person Number|| 1|earning element run result values| deduction…
-
Select performance goal seeded report customization in not working in Production.Summary: Select performance goal seeded report customization in not working in Production . where as working in TEST pod. Below are the steps followed to customize the r… -
How can I find the system source ID/owner for payroll timecard from BI Report querySummary: We're attempting to update some timecard overtime rate entries using the HCM Data Load using USER KEY method, but system seems to still require SOURCE SYSTEM ID… -
Missed Punch report using BIPSummary: Customer wants to create a BIP report which will give Missed punches of web clock. If there is public holiday or leave applied on that day and no punch data the… -
Need to calculate month on month attrition percentageWe need to calculate month on month attrition percentage on the basis of formula = (Attrition count of that month *100)/(Average of (Headcount as of first day of month a…
-
Difference between two dates with decimal outputSummary: In an OTBI report, the requirement is to calculate years of service for terminated employees (difference between hire and term dates). The output needs to be 2 …
-
Does exist a BIP table/view with both Person Number and Employee Name?Summary: Building a valueset Content (please ensure you mask any confidential information): I need to create a value extracting person name, person number and person id.… -
Subject area for report to fetch content section of person profile typeSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the details inside 'Content Sections' under Profile > Profile type > …
-
How to provide the gap between the 2 bars in bar graphSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Analysis report to find all the talent notifications enabled in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to create an analysis report where we get the list of all the enabled and in use n…
-
how to fetch top 10 otbi reports that users access frequentlySummary: The request is to fetch the top 10 OTBI reports that users access frequently on their dashboard Content (please ensure you mask any confidential information): R…
-
OTBI output is different for 2 different usersSummary: Hi, We have a custom OTBI report which is scheduled to send report to the Business Users. This report shows that 100 employees have missing family contact infor… -
how to get the retention rate calculationSummary: HI team! Do you know how to calculate the retention rate in an Analysis Report? This is the formula: (Number of employees at the end of the period / Number of e… -
Table links between Questionnaire and candidate tables in orcSummary: I need to get candidate Interview feedback Content (please ensure you mask any confidential information): able to get interview feedback from fusion.hrq_qstnr_p…
-
Roles required for PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILSSummary: Hi, We have created a report to get employee calendar, and we are using PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS in our query. This is working for us a…
-
Seniority Date in Workforce Management - Worker Assignment RT is not returning any data in OTBISeniority Date.Seniority Date in Workforce Management - Worker Assignment RT is blank whereas Person Seniority Details.Seniority in Workforce Management - Person Seniori…
-
How to schedule an OTBI report using agent with effective date prompt?I have OTBI analysis where I have added 'Effective date' prompt. I want to schedule this analysis via agent. However, wants to select date in prompt under 'condition' se…
-
How to fetch report in hiring tab in redwoodSummary: Content (please ensure you mask any confidential information): Hello, When using the Responsive UI, we were able to add a report (Candidate tracking ) in such a…
-
Report to fetch all the questionnaire present in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the active questionnaires and the items resent in question library, a…
-
Query to fetch structural details of the admin pages and the EL Components used within themSummary: Is there any way or Query to fetch structural details of the admin pages and the EL Components used within them Content (please ensure you mask any confidential…
-
structural details of the admin pages and the EL (Expression Language) components used within themSummary: Is there any way that provide the structural details of the admin pages and the EL (Expression Language) components used within them, specifically focusing on t…
-
Latest Talent Ratings OTBISummary: We are required to create a prompted OTBI analysis that includes each of the worker's latest talent profile ratings. How can this be achieved? Version (include … -
When a filter is applied after ranking total months of service the analytic function no longer worksI have a report to pull the most recent seniority service data to get a list of employees eligible for a service award. My report works up until I set my final filter. H…
-
Redwood: Can we make attachment mandatory in Refer Candidate PageSummary: Redwood: Can we make attachment mandatory in Refer Candidate Page Content (please ensure you mask any confidential information): We are unable to make Attachmen…
-
How to set dashboard prompt where user selects name, but variable is set for person_Id?Summary: Hi team, I am seeking some assistance building an OTBI dashboard prompt. I am wanting to present the display name to the user, but when they select it I want to…
-
RTF Pivot Table Repeating GroupSummary: I'm developing a report where I would need duplicate pivot table based on country and put the data into different spreadsheets in excel. My problem is that Im n…