Absence and Accrual
Discussion List
-
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 228 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 47 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 25 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 207 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 36 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 772 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 16 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 5 views 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 45 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 29 views 3 comments 0 points Most recent by Raghavendra Raghunath-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… -
Annual Leave Encashment Final DisbursementSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…SadiqK 10 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible to report on which workers are scheduled to work on a particular date?Summary: Content (required): I'd like to be able to report on which employees are scheduled to work on a certain date, based on the work schedule held for them, and what…Leanne W 133 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get Periodic accrual Projected Hours Value in OTBISummary: how to get Periodic accrual Projected Hours Value in OTBI Content (please ensure you mask any confidential information): Version (include the version you are us… -
OTBI > Ability to AggregateSummary: OTBI > Ability to Aggregate Content (please ensure you mask any confidential information): Hello All, In order to prevent the repetition of the Time Card Commen… -
Is there any process to clear absences with withdrawn status?Summary: I would like to clear the absences with the status withdrawn, is it possible? Or do you need to apply HDL to do this cleaning? Version (include the version you … -
Annual Leave Accrual Plan Enrolment dates table values not matching screen. Any ideas ?Summary: Start Date (enrt_st_dt) and End Date (enrt_st_dt) in anc_per_plan_enrollment not matching the screen values. Content (please ensure you mask any confidential in… -
Subject area related to Work Schedule and Work schedule assignment informationSummary: Subject area related to Work Schedule and Work schedule assignment information Content (required): Please suggest OTBI Subject area related to Work Schedule and…AvaneeshJain 1.4K views 21 comments 0 points Most recent by Jay_Brannan Reporting and Analytics for HCM -
Accrual balances not roll over to Target planSummary: Hi, I have created the 3 Absence Plans, Out of that one is Main plan where accrual will be calculated and Plan term is based on Anniversary dates. Along with th… -
How to get the 'Plan Period Start Date' in absence plan balances?I am creating a report that would output each plan's balances by year. But this one sample, for 2023, its calculation started from 2022, it's a bit complex I think. For …notautomni9 413 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
hr_org_unit_classifications_fSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…VarunMittal01 26 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Current User/Logged in User Absence Details in OTBISummary Not able to fetch absence details of current user from otbiContent Hello Experts! I'm trying to build a report to get the logged in user/current user absence det… -
Check Working Day QuerySummary: Dear All, I have a requirement to check if a specific date is a working day for the employee or an off day. So basically I need a query with a parameter called … -
How do we update default expense account information for a person in Fusion HCM in Responsive UIPlease point to any screenshots/ links/documentation as i could not find any place which shows default expense account and position for employees.Srihari Manian 4 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
IN OTBI Absence Real time issue on accrual balanceSummary: we have requirement is to show the report as ui(Annual accrual balance of annual accural ) in below screen shot but shown as below wrong Could you please assist…AjayKumar Maddipati 54 views 6 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
accrual balanceSummary: I have a report on front-loaded plans to show Accraul, leave taken, Leave scheduled, Adjustments and Accrual Balance. Now we have made some adjustments for empl…Wouter.Schaap 38 views 1 comment 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM