Absence and Accrual
Discussion List
-
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 7 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 124 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.3K 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 321 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 21 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 53 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 32 views 1 comment 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
PL/SQL - Absences in UoM: Weeks to be Displayed in Days?Hi all, Hope you are well. We have certain absence types such as Maternity, which have the UoM: Weeks. We have a requirement for reporting purposes to display this as Da…David Oldfield 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
job history reporthi Experts, From the below table I am able to get only the history of past one month. Does anyone now the table names to get the report for more than month ? fusion_ora_…Nivya Mathire 31 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Absence Date End problem with clock change in OTBISummary: During British Summer Time (BST) (GMT+1) the Date End of an absence has a time stamp of 1am the next day. So 01/05/2021 00:59 not 30/04/2021 23:59. Content (req…Robert Craske 45 views 4 comments 0 points Most recent by Mark Stoker Reporting and Analytics for HCM
-
Formula to prevent deletion of annual absences with Approved status in the system.I prepared a validation formula so that absences with "Approved "status cannot be updated or deleted in the system. The formula for updating is running and an error mess…Cansel Karasoy 52 views 7 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Possibility to Create Dynamically Different Tabs of The Same Report by Passing Diff. Param’s ValueSummary: OTBI Dashboard > Possibility to Create Dynamically Different Tabs of The Same Report by Passing Different Parameter’s Value Content (please ensure you mask any …Bernard T 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Tables to capture details about the Absence current and previous plan detailsHi All, I'm currently working on capturing details about an employee's current and previous absence plans. I'm seeking guidance on the specific tables that would contain…Sanduni Pathirathne 173 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How do people manage data load of sick where 2 absences are broken on input but joined as no RTWSummary: How do people manage data load of sick where 2 absences are broken on input but joined as no Return to work Where an employee is sick Monday to Friday and SSP i…
-
Time and Labor -- Calculated time card entries for a date range or pay periodSummary Calculated time card entries for a date range or pay periodContent Hi Friends I have been working on a report for Calculated Time Card Entries and so far i have … -
How can we enable visibility on OTBI Absences for a user?Summary: Hi all, We have a user who as per their profile can access Absence Records, but cannot view Absence reports in OTBI - any idea how to get round that? Any privil…Cora_Stanciu 13 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Table to extract BPM Approval Groups InformationHi, I cannot see any data when querying the tables below. Could it be due to the role? What could be the reason? I think it should be recorded in these tables. fa_fusion…Cansel Karasoy 21 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Working days lostSummary: Has anyone managed to do a comparison between, a work schedule that holds a person's work patten eg Mon to Friday 9-5 and days taken as sick eg Tuesday and Wedn…
-
Round to nearest 0.5 decimalSummary: Leave balance in hours, converted to days to 2 decimal points. Content (required): My formula is FLOOR("Front-Loaded Plan"."Accrual Balance"/7.4) however for so…Dawn Cawston - CPS 74 views 4 comments 0 points Most recent by Narendar Rao Naineni Reporting and Analytics for HCM
-
Can we report on users with no work schedule using OTBI analysis?Summary: Users with no work schedule not showing on OTBI analysis of work schedules by user. Content (please ensure you mask any confidential information): I have an OTB… -
Need SQL query to get absence leave requests which are in denied status.Summary: Hi Team, Can we have a SQL query to get absence leave requests which are in denied status. Thanks, Madhuri.Madhuri Brammadevara 296 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Delegate Access - InfoletsHi all, I was just wondering if anyone know if it was possible for those who have delegate access to run infolets on front end and see the same results as the manager wh…MikeW 122 views 34 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM