Absence and Accrual
Discussion List
-
Where can we find the latest list of all HCM PVOs to be used in BICCSummary: We want to use BI Cloud Connector to pull HCM data. Where can we find the documentation for all available PVOs supported in BICC ? Content (please ensure you ma…Soumya Suravita 305 views 6 comments 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM -
Top 5 reasons for sicknessSummary: Hi, Has anyone got any ideas how i can get top 5 reasons for sickness and display the same as a % of the total absences? Also how to achieve the top 5 reasons a…BillM 31 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need info on how to connect Absence Table with Time And LaborSummary: Hi All, I am facing an issue to connect the Absence Table with Time and Labor Tables to Fetch Absence Entry on Timecard. We basically want to Fetch absences ent…Abhishek Bhaskar 115 views 2 comments 1 point Most recent by Dineshkumar Ammasaikutti Reporting and Analytics for HCM -
How should I find the full names of the people in the approvers column in the fa_fusion_soainfra.WFTHello, I use the APPROVERS column in the fa_fusion_soainfra.WFTASK table in my report, but the username is included there. I need approvers display name information. Can…Cansel Karasoy 11 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Absence Accrual BalancesContent Hi - I have a report that shows the absence accruals for each of our plans and it works great for those that are calendar year Plan Period Type. It shows me the …Prudence K 334 views 27 comments 4 points Most recent by Shameer Shaik Reporting and Analytics for HCM -
Absence Daily BreakdownWe have a daily absence breakdown report built using the subject area Workforce Management - Absence Calendar Details Real Time. SQL code attached. There are a number of…
-
All Scheduled Absences Report Not Pulling an EmployeeSummary: There is a custom BI publisher report that our HR department runs every pay period to view absences for that pay period. For some reason, in the last pay period…
-
Seniority date - Legal Entity Hire Date or Rehire dateSummary: Requirement to identify the Lenth of Service based on Rehire date Content (please ensure you mask any confidential information): We have requirement to accrue t…
-
User Entity to extract Absence plan enrollments of an employeeSummary: I have a requirement to extract all absence plan enrollments of an employee , using HCM Extract. I am looking for a User Entity which can suffice this need. The…Pankaj_Singh 132 views 2 comments 1 point Most recent by Pankaj_Singh Reporting and Analytics for HCM
-
Absence Plan Balance (as of Date) in ReportSummary Absence Plan Balance (as of Date) in ReportContent Hi All I need to display the Absence plan balance of an employee as of certain date in Report. For example whe…Shabrawi 284 views 6 comments 1 point Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
Sickness Absence - Working Days LostSummary: Hi Is there any way to calculate Working Days Lost in OTBI for sickness absence? We are using the Absence Real Time subject area and have Calendar Days Lost cal…stusc 53 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Multiple assignment abseSummary: Hi, I am trying to create a report for absences that are assigned at assignment level. As you can see from the image attached the moment a column is added from …
-
BIP report date format is not working in Dashboard promptsContent Hi All, I have created a BIP report with date parameter and it is working fine. When I tried to apply dashboard column prompts on the same report data is not fet…Sachin.Satpute 79 views 4 comments 1 point Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Information about who rejected the rejected absence recordsHi, I need to add information about who rejected the rejected absence records to my report. When I use the 'fa_fusion_soainfra.wftask table', I cannot access it for reje…Cansel Karasoy 11 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Incorrect Absence Hours Calculation in OTBI ReportSummary: Somehow the Absence Hours calculation is pulling in an extra 8 hours of PTO into the day. Content (please ensure you mask any confidential information): We have…SeanWesche 11 views 2 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
GET_VALUE_SET not returning any value in Fast FormulaSummary: Hi, I am using the Value Set of Table type in Absence Accrual Matrix formula but it is not returning any value in Fast Formula though scenario is valid. Expecte…
-
Absence ApprovalSummary Looking to produce a report to show denied absences.Content Hi all, I need to create a report to show historic absence data and to include denied absences. I'm u…User_2025-02-03-21-36-22-672 183 views 11 comments 0 points Most recent by HCM Consultant Reporting and Analytics for HCM -
Authorization error with REST API to move candidate between phases / statesSummary: Content (required): Hello everybody, We are trying to use the rest api made available by Oracle to move a cadidate present in the system in the ORC module betwe…Gerardo Peluso 221 views 5 comments 0 points Most recent by Stefan v. Glabbeek Reporting and Analytics for HCM
-
Add Pay Group using data augmentation.We are trying to bring the field of Pay Group through data augmentation. Can you guide me to select the source tables (see attached screenshot)? which PVO contains Pay G…Rodrigo Durán 41 views 7 comments 0 points Most recent by Rodrigo Durán Reporting and Analytics for HCM
-
OTBI Workforce Management absence entitlement case real timeSummary: How do you report out of this subject area. We have added the Job and duty roles and yet the subject area doesn't return any detail. Its as if the entire subjec…Kevin Robertson 22 views 3 comments 0 points Most recent by Kevin Robertson Reporting and Analytics for HCM
-
Estimated End Date associated with an Absence - OTBISummary: I am having trouble getting the Estimated End Date associated with the absence to pull into an OTBI report. Is there a way to pull in this value? Content (pleas…
-
Privileges/Duty roles required to extract Absence data via OTBI AnalysisSummary: Hi Team, Could some one kindly help us on the below requested issue. We are unbale to extract Absence related data from the Subject Area: Workforce Management -…User_2025-02-07-03-03-32-616 192 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How do I add the last absence end date from the last 5 occurrences?Summary: I need to report on the last absence end date on the attached report. It is currently filtered by rolling last 52 weeks and number of absences measure of 5. Is …Mark Stoker 31 views 1 comment 0 points Most recent by Fechete Iustin - Support -Oracle Reporting and Analytics for HCM -
Query or table to get the employee work schedule as of the leave start dateSummary: Hi Every one, Do any one have any query to get the employee work schedule as of the Leave Start date . The requirement is when employee applied the leave, I nee…Charan Kollipara 665 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Hi Guys query is returning DATA_DS, please help me where i went wrong int he query.Summary: My Query: select per.person_number, per_name.FULL_NAME PER_ABSENCE_ENTRY_ID , abs.absence_type_id, apae.APPROVAL_STATUS_CD,abs.name absence_type,to_char(apae.st…
-
Details of employees who are having the access of respective modules.Hi Everyone, For audit reason We have received an requirement where our need to is to get details of employees who all are having an access for respective modules and al…Jebarsan Thangam John Durai Raj 11 views 0 comments 0 points Started by Jebarsan Thangam John Durai Raj Reporting and Analytics for HCM
-
-
department reportSummary: How to extract or Query to get this information Note No.of employees Means Count Content (please ensure you mask any confidential information): Version (include…ahmed foly 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query to get the rollover balance of Annual Absence Plan on January-1-2024Summary: Hi Guys, i have i have scenario, Plan A and Plan B. Plan A is Base plan and Plan B is target Plan where rollover is being transferred. for example Plan A has 20…
-
Solutioning Data Archival for US(United States) and CA(Canada) Legislations.Summary: My Client has a requirement to archive complete fusion data and I want to understand how could we preserve anything and everything from Fusion HCM Cloud's Criti…SAHILVASYANI 41 views 5 comments 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)