Absence and Accrual
Discussion List
-
Min and Max columns on Assignment Effective Dates are blank in OTBI analysisSummary: 'Latest Assignment Start Date', 'Earliest Assignment End Date' columns showed data while building the report. After adding more columns and filter condition the…Vinay Hardas 253 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to read the info from the Calendar?Summary How to read the info from the Calendar?Content Hello, do you have any query that is able to read from the Calendar under Work Schedule Assignment? Many thanks to…Nicola Petri 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Accrual balance with different start dates for plansSummary: my customer is an international company and the various countries have different accrual plans. For most countries the plans start at January 1th of a year, but…Wouter.Schaap 11 views 4 comments 0 points Most recent by Wouter.Schaap Reporting and Analytics for HCM
-
Workforce Management - Absence Real Time Subject Area not returning any dataContent Workforce Management - Absence Real Time Subject Area displays 'No Data found' . Can someone who has used this Subject Area please let me know the roles that hel…Shruthi Ramesh 208 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
How to get a PTO Accruals report with ONE line of data for balance per EE?Summary: We are using a 3rd Party for our PTO Accruals (UKG). Primary issue: Some EE's are in 2 plans, so they have 2 lines of data. The issue is that UKG will only pick…
-
Users cannot see their own accrual balanceSummary: Users cannot see their own holiday accrual balance in OTBI accrual report Content (required): I have an OTBI report showing Accrual Balances using the Accrual R…s_b 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Why would OTBI reporting show a row with no absence plan name against an employee?Summary: Multiple rows showing with a blank Absence plan name Content (required): I have created a simple analysis with Person number, Name, Absence plan name and termin…Elizabeth Docherty 31 views 1 comment 0 points Most recent by Elizabeth Docherty Reporting and Analytics for HCM -
Display Extended Absences by day from Absence ModuleSummary: We have a requirement to show absences by day if they are booked over a period of time. Content (required): The example we have is if someone books a week long …User_2025-01-31-00-25-12-234 21 views 2 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Subject Areas for Work SchedulesSummary Our clients requirement is to create on the ratio of Planned/Scheduled Hours vs Actual Hours.Content Dear Experts, Our clients requirement is to create on the ra… -
Amalgamated Absence DaysSummary: My report is totalling the absence days for all absences of the same reason name and displaying that total on each line of absence in the report. I need it to d…Dawn Cawston - CPS 11 views 6 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Dynamic file name and dynamic sheet name for excel templateSummary: Content (required): I need to run the report for every month and output generated via Excel template. I need the output file name with the month and year for wh…Jaeyshree Kumaran 263 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Dynamic Pivot in excel templateSummary: Content (required): I have 2 sheets on my excel template output. the second has all the output columns and their data. Based on second sheet I need to create a …Jaeyshree Kumaran 31 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Absence Management | Hours Worked Year to DateContent Hi all, I have a request to create a report that shows hours worked year to date. Is there a specific subject area that I should be referencing? We do have the A…Tristan Aquino 20 views 2 comments 0 points Most recent by Tristan Aquino Reporting and Analytics for HCM -
Issue with "Workforce Management - Absence Real Time"Content Hi Team, We have designed a specific report using the OTBI "Issue with Workforce Management - Absence Real Time". This was working fine till last month and now w…Kiran Kancherla 23 views 3 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
Additional Information from Accrual Plan BalanceSummary Require Table and column name for additional information fieldContent Hi Team, I need to extract the additional information field description for the Absence Pla…User_2025-02-04-13-27-19-123 119 views 4 comments 0 points Most recent by User_2025-02-04-13-27-19-123 Reporting and Analytics for HCM
-
Ability to find out the Work Schedule based on ShiftSummary Ability to find out the Work Schedule based on ShiftContent Dear Team, Basic Requirement is to develop the custom BI report based on Shift Details to find out th…User_2025-01-31-16-34-04-599 20 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI report to extract Status information for Absence ManagementSummary Any pre build report to extract absence type and status information for Absence Management?Content Hello, If anyone has any pre build report/query to fetch the d…
-
Subject Area which includes Maternity Weekly Average EarningsContent Can any one help me to identify subject area which contains below highlighted field in the attachment? Absence Administration (Maternity Leave) -> Override Avera…ViswanathaReddyKetireddy 35 views 2 comments 0 points Most recent by ViswanathaReddyKetireddy Reporting and Analytics for HCM
-
Override Average weekly earning field in OTBIContent Does anyone know if the Override Average weekly earning field that can be found in Absence Records under legislative information is available in OTBI?Tasha 26 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Absence related OTBI analysis returning no resultsContent Hello, I have a couple of absence related analyses which are no longer returning any results. They worked fine last month. We just had our quarterly update this …Susan Anderson 41 views 10 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
New Absence within 3 days of old AbsenceSummary We require a report that would show any colleague who had an absence closed, and a new absence opened within 3 days.Content Hi, I am currently working on an abse…Mitch_123456 21 views 1 comment 0 points Most recent by Venkata Sumanam Reporting and Analytics for HCM
-
OTBI > Ability to Capture Name of Employee Performing Adjust Balance on Employee BalanceContent Hello All, I will appreciate your support on the following issue: Our customer wants to capture the name of the employee who performs Adjust Balance on Employee …Bernard T 16 views 6 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Accrual Balance Report is showing double the actual valueSummary Accrual Report is showing the balance as double what it should beContent Hi, I have created a accrual balance report in OTBI using the Accrual Real Time subject …
-
How to navigate from OTBI report to Absence Record Entry page in Edit modeSummary There is no Deep Link available to navigate to Absence Record page in Edit Mode using Absence Entry ID. Want to know if there is any way to open the Absence Reco…User_UM4C6 52 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI > Subject Area for Employees Assigned Work ScheduleContent Hello All, I will appreciate your support in the following issue: We have defined different Work Schedules which are assigned to different population based on sp…
-
Help required to find the User Entity for the table ANC_PER_ACRL_ENTRY_DTLS to use in extractContent Can anyone please tell me what is the User Entity for the table ANC_PER_ACRL_ENTRY_DTLS so that i could use the columns in extracts. Version Oracle Cloud Applica…Amrish Kumar-210718 40 views 3 comments 1 point Most recent by Amrish Kumar-210718 Reporting and Analytics for HCM
-
Absence Calendar Details Real Time - Incorrect Data in ReportContent Hi Experts, We have created a OTBI report in which we are getting the results as per leave type and for one specific leave type, we are getting very small (Incor…Kiran Kancherla 22 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Extract Projected Accrual Absence Balance in HCM/BIP reportSummary Extract Projected Accrual Absence Balance in HCM/BIP reportContent Hi Experts,We have a requirement to fetched projected Absence balance of employee in extract t…Rajeev Nayan 675 views 6 comments 3 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Need Employee Leave Balance Report ?Summary Need any pointers/hints for building Employee Leave Balance ReportContent Expected Layout Parameters Effective Date : 06-Jul-2015 Employee Leave Balance Report P…AshishERPCloud 717 views 10 comments 5 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Absence cases and Details linked to absenceContent I am looking to build a report that includes the absence cases and the associated absence and details from the documents that have been attached in order to prov…Sharon Harper 30 views 2 comments 1 point Most recent by Sharon Harper Reporting and Analytics for HCM