Absence and Accrual
Discussion List
-
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 36 views 2 comments 1 point Most recent by Pankaj_Singh Reporting and Analytics for HCM
-
SQL Table where Webclock events information will be storedSummary: Hi All, We are looking for a report to capture details of Webclock Events. Its use is to check which all entries have Clock in And Clock out correctly, and the …Abhishek Bhaskar 23 views 1 comment 0 points Most recent by Raghavan p-Oracle 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 287 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 51 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 70 views 4 comments 1 point Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Analysis showing projected absence accrual at year endSummary: Hi We have a periodic accrual scheme for annual leave which accrues monthly at the month end. However we give our employees their entitlement up front (e.g. Mr …HRJon 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-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 13 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 AP.HCM 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 21 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 174 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 328 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Absence Calendar / Dashboard (Sample Report)Summary This dashboard creates an absence overview that can be used by either HR or the line manager to get more information about absences for the organization, team, o…Even Kjorsvik-Oracle 1K views 15 comments 3 points Most recent by Manuj_HCM 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 12 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)
-
Reporting on Leave Duration Without Absence ModuleSummary: Need to report on how long employees have been on a continuous leave using assignment real time subject area. This is for an existing report and my preference i…Matthew Phillips 21 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report Data is incorrect because Time zoneHello, we just recently faced an issue related to BI report on absence related data. It will give last one hour updated records of employees absences. (submitted/awaitin…Dara Nagasai 1 view 3 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Adding approval history information to the reportHi, I designed a report that works the same as the standard notification with custom parameters. I would like to add the following field to the report, which comes in th…