Absence and Accrual
Discussion List
-
is there a way to access other countries absence calendar?Hello, I was thinking if it's possible to access other absence calendar like for example from HR from Brazil to access US absence calendar. is this possible? -
Cost of absence sicknesSummary: Report to show cost($ amount) of employee leave balances Content (please ensure you mask any confidential information): Hi Team, We have developed a report for …Thomas Samuel19 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to join a Timesheet Row to an Absence Row (HWM_TM_RPT_ENTRY_V to ANC_PER_ABS_ENTRIES)Summary: If we have a person with 2 timesheet rows on the same day, each representing half day of absence, and we have 2 absence rows each of a different absence type - …
-
What is the fast formula definition for Enterprise Hire dateSummary: I'm building a fast formula that will pull the Enterprise Hire Date of an employee for an eligibility profile. Need your help please. Content (please ensure you…
-
OTBI Analysis Columns displayed by prompt valuesHi Experts, We have a balance report that works well. However, we would like to display in it some context based assignment DFF's. We would like to keep 1 report for eac… -
Absence Calendar Direct Reports Current Month not returning any valueHi Experts, When we are running the report "Absence Calendar Direct Reports Current Month" from Line manager Dashboard, It is coming as empty. I have checked then backen…Nivya Mathire 85 views 8 comments 0 points Most recent by Gunasagar Thimmapuram-Oracle Reporting and Analytics for HCM -
Need to report on Employees work schedules and patternsContent Hello, We need to be able to report on employees work schedules and patterns so we can create a report that looks like a calendar and show the days that employee…
-
Accrual balance report/ how to use months in column and years in rowsI'm building an OTBI report to based on Accrual Real time subject area, with the goal of displaying accrual balances. To have a report that makes sense I used Pivot Tabl…Marius Neata 13 views 2 comments 0 points Most recent by Marius Neata Reporting and Analytics for HCM
-
How can i get absences in BIP Report that where approved and then withdrawn/deleted .Summary: Hi, Please suggest tables that stores absences that where approved and then withdrawn , are there any transaction table that stores the data or absence events t…GummadiNamrata 45 views 4 comments 0 points Most recent by GummadiNamrata Reporting and Analytics for HCM
-
Need to add Adjustments and Absences in two different columns. Please hep me with the querySummary: Hi Folks, I need to add Adjustments in one column and Absences in one column in the report in Absence Management. Please help me with the query. Content (please…Raj_540 3 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Employees on Leave - Retrieving Assignment Dates for Old Reason CodesSummary: We are trying to create a report that has all employees who are on leave with the date they went out on leave. However, in OTBI if a change is made to an employ…joshvanlaan 2 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
what is the table that can pull Available absence plan balance.i just want to pull absence plan and balance available for each person in system . Can someone ping me the table name,and is it possible to pull the balance for each abs…
-
Extracting the absence durationSummary: Hi, I need to extract the absence duration of employees for a report need. I thought I could use the GET_PAY_AVAILABILITY function for this, but it didn't work.…Barış Ergün 45 views 2 comments 0 points Most recent by Omnia-Oracle Reporting and Analytics for HCM -
OTBI Absence reportSummary: I have created a OTBI report to pull absence details and it has parameter of two dates start date between. Client is passing the dates of 1st of Aug to 30th Aug…Reddykrishna 42 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Periodic Accrual in OTBI giving wrong valueSummary: Requirement is to create a OTBI report that has accrual plan balance and accrual value from last period. Plan is incremental so every period, employees accrue a…
-
Accrual ReportHello All, Is it possible to get Accrual rate in OTBI report? Thank you, Shameer Shaik
-
Making All value selectable in date parameter definitionI have an absence start date parameter in the report and its definition is as seen in the screenshot below. It works like this: First, the registry number is selected, a…Cansel Karasoy 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Approval Date of the Approved Absence in Workforce Management - Absence Real TimeI'm currently creating a dashboard for Absence Management. Why there are Approved Absence, but the Approval Date is Null?Welsey 11 views 2 comments 0 points Most recent by SatheeshSamy-Oracle Reporting and Analytics for HCM -
Table to get fixed accrual of an employeeSummary: We have a customer requirement to create custom report which displays the fixed accrual for a person and the accrual as of period. We are looking to get the fix…Dijo Maliakal-Oracle 82 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Absence update history not availableSummary: Currently when the employee update the existing absence record and submit it, the back end does not hold both the data on the absence entry table. Unfortunately…Sobitha Venkatraman 2 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
What is a variable formula that uses the standard working hours converting our analysis to days?Summary: What is the formula that we can use for our Absence Analysis that will use "standard hours" (which isn't always 8 for us, sometimes it's 24, sometimes 7.25 etc)…MissHeidiJ 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable to add table or link to a oracle analytics deliversWe have the next análisis with the next details: this is the text in the notificatión: [u] Hola, @2 [/u][br/] Recuerda que debes registrar tus vacaciones en la plataform…
-
Employee details at the time of the absenceI would like to report on the worker details at the time of the absence. If for example an employee changed department today, the absence from last year would show the d…NusratB 33 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
call bip report from Absence page and pass person_id as parameterSummary: I need to call bip report from Absence page and pass person_id as parameter Content (please ensure you mask any confidential information): Version (include the …Farah Alajou 12 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
We need OTBI column name in Absence as per below image to get leave applied dateSummary: We need OTBI column name in Absence as per below image Type is Adjustment. Content (please ensure you mask any confidential information): Version (include the v…AjayKumar Maddipati 13 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Work scheduleSummary: Is the a way to export all work schedules set up and whether they are in use? Thanks Content (please ensure you mask any confidential information): Version (inc…Lara Slater 21 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
SQL query for absence disbursementSummary: Hi Experts, I need to fetch the absence disbursement value for a plan (screenshot attached) using a SQL query. Can some one please help with a sample SQL for th…Pinky Mukherjee 49 views 1 comment 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM -
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 274 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 32 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 103 views 2 comments 1 point Most recent by Dineshkumar Ammasaikutti Reporting and Analytics for HCM