Absence and Accrual
Discussion List
-
Need SQL Query to fetch the Advanced Mode Absence Duration in Absence RecordsHi Experts, Could you please help me on SQL Query to fetch the Advanced Mode Absence Duration in Absence Records. Thanks, Nagaraju.Naga raju Ibba 334 views 4 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
Need table name to fetch 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen.Summary: Dear Experts, Which table stores the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached Screenshot for your reference. Than…
-
Reporting on Holiday Entitlement and Remaining BalanceHi all, Is it possible to report on total holiday entitlement as one combined field (factoring in employees carry over, annual accrual and other adjustments) within OTBI…
-
I can't see absence approvers in transaction tableHello, I am preparing a report to see who approved or denied the absences for the absence records in the transaction console. However, I cannot access the approver infor…
-
Issue in dashboard PromptSummary: Issue in dashboard Prompt Content (required): Hi All, We have created a dashboard prompt using the Workforce Management - Worker Assignment Real Time subject ar…Venkatesan 36 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
we ae getting multipule dublicate records in BI report with out any changeSummary: HI Team, we have absence reports but in recent we observed multiple dublicae records for each employee how can we sorted out this issue ? example: one employee …AjayKumar Maddipati 34 views 7 comments 0 points Most recent by Riyaz Ali-Oracle Reporting and Analytics for HCM -
How to calculate cost of sickness in UKSummary: Calculate the cost of sickness using salary from element entry Content (required): I have been asked to calculate the quarterly cost of sickness. I was wonderin…Isabela Radivoi 25 views 2 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM -
Getting Absence Reason in BIPSummary: I need to get the absence reason for a large number of absence in a BIP report. However, when trying to link the Absence Entry Reason ID to the Reason ID using …
-
Annual Leave Buy / Sell - ReportSummary: A Report to identify those Employees who Bought / Sold Annual Leaves Content (required): Hi, Can you please help me to develop a report which will give details … -
How should I calculate the employee's seniority?Hi, I have a query where I calculate the seniority of the employee and I want to sort by the highest seniority. The query works like this if the 'Seniority Reference Dat…Cansel Karasoy 47 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
how to change columns as rows in below requireimentSummary: Hi Team, In OTBI how change annual accrual and carry over coulmn into row we need . Any one help me on ? Content (required): Version (include the version you ar…AjayKumar Maddipati 85 views 20 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
We need Work Schedule Name, Work schedule start date, Work schedule End date on OTBISummary: Hi Team, we looking below columns in OTBI subject areas May i know which subject area available? Thanks, Ajay Content (required): UI: Version (include the versi…AjayKumar Maddipati 39 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
OTBI:I need to pull the carryover limit of persons enrolled in an absence planSummary: I need to pull the carryover limit of persons enrolled in an absence plan Content (required): I need to create a BI Publisher report that pulls the carryover li…Jose Lorenzo Amarado 52 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM
-
HowThere is aCansel Karasoy 47 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM
-
Need to know approval date file & table name of absence records attached my sql, if anyone please moSummary: we use oracle fusion cloud. OBI report and analytic Need to know approval date file & table name of absence records attached my sql, if anyone please modify and…RIfdhy Zain 533 views 3 comments 0 points Most recent by RIfdhy Zain Reporting and Analytics for HCM -
How do I get absences that are ongoing during a period but may start/end outside it?Summary: We are trying to build an absence summary report that shows individuals off between two dates but the start and/or end dates may not be during the dates in the …
-
Any function is available that can be used in OTBI reports for calculating annual leave balance.Summary: Any function is available that can be used in OTBI reports for calculating Annual leave balance. It should work same as 'balance calculation' in oracle fusion h…Meera Sajeevu 240 views 1 comment 0 points Most recent by Asmit Piyush Reporting and Analytics for HCM
-
OTBI created to fetch details of Absence accrual balance is not picking latest dataSummary: Content (required): We have created a custom otbi report which fetches the details of accrual balance. But we observed that the data is not getting updated on d…Veeru15 223 views 5 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
View Display Error - Error Codes: EKMT3FKSummary: I am running a fairly simple OTBI analysis and the report won't return all the records. The below error is presented when exporting the report: View Display Err…
-
Time Entries SQL HelpHi Experts, we need to fetch all the time entries including Absences.SO for Absences we need to have a column for Absence Type.But i am not sure how can we find the abse…minati_behera-Oracle 47 views 4 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
I'm looking below columns in otbi or any reference reportSummary: Hi , I'm looking below columns in otbi or any reference report ,any help me on below columns. Thanks, Ajay Content (required): Opening EL leave balance /DOJ (Da…AjayKumar Maddipati 44 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
we need below BI columns but unable to development of those from absenceSummary: any one help me and to the requirement Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that …AjayKumar Maddipati 46 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI report run for some users onlyDear , we have custom otbi report which is showing absences and working fine for all users but suddenly it is works for some users and not working for some users can any…Mirza_Adeel 58 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
End Dated values no longer appear in OTBI reportsSummary: We have end dated a number of Sickness Reasons (sub reasons), which used to pull through on OTBI reporting, these no longer appear after being end dated Content…Luke Harrison-126889 42 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Is it possible to customize AbsenceApprovalEmailNotification report to get Absence Balance included?Summary: We need to somehow modify the data model so that the absence balance of the absence type from the absence request gets displayed on the report. Content (require…bervin13 55 views 2 comments 1 point Most recent by Michelle Juergens Reporting and Analytics for HCM -
we need annual accural and carry over columns in biSummary: Hi Team, we looking above two columns from BI reports . any one can help me on. Thanks, Ajay Content (required): Version (include the version you are using, if …AjayKumar Maddipati 68 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Delegation Approval Query /TableSummary Delegation Approval Query /TableContent HI , i have a requirement to create BI/OTBI report for delegation approvals. Can any one please share the table/query whi…
-
Count of week days for absence reportSummary: We need to count the weekdays (Mon - Fri) in a selected period to calculate absence percentage. Anyone a suggestion or solution how to get this done? WouterWouter.Schaap 56 views 6 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Can't see absence reason in reports after putting end date inside the relevant absence typeSummary Can't see absence reason in reports after putting end date inside the relevant absence typeContent Hi, We have an issue that after putting the end date to an abs…Markovich Chen 37 views 3 comments 0 points Most recent by Jonny Varley Reporting and Analytics for HCM
-
MonthName function not WorkingSummary MonthName function not WorkingContent Hi All , I am trying to get the Month Name (Jan / Feb / Mar) from a Date entry - Eg -I'm using the following function - Mon…Jo Black 93 views 11 comments 0 points Most recent by Raghavendra_M-Oracle Reporting and Analytics for HCM