Absence and Accrual
Discussion List
-
Absence Record Not showing after Global Transfer Or TerminationSummary: Hi Guys, I’m unable to view the absence records after an employee is terminated or globally transferred. Could anyone please help me understand what might be ca…Dharani Dhar Gupta 6 views 0 comments 0 points Started by Dharani Dhar Gupta Reporting and Analytics for HCM -
Absences created in Advanced modeSummary: It appears that the OTBI report splits out absences created in Advanced Mode onto separate lines by work week but gives the total absence duration for the leave…Stephen Jones 74 views 3 comments 0 points Most recent by Natalie Andrek Reporting and Analytics for HCM
-
Absence Detail AnalysisSummary: I'm looking to create an analysis which will show a detailed list of all absence entries in our system. I've created the following using Workforce Management - … -
OTBI Report: Accrual Balance Based on Effective DateHello Experts, We have a requirement to extract accrual balance details using an OTBI report based on an effective date parameter. This effective date should be compared…Vasanthakumar Ravi 48 views 4 comments 1 point Most recent by Swapna Govind Reporting and Analytics for HCM -
Absence Type and Absence Reason not visible on employee's timecardSummary: Hi, has anyone here encountered an issue where, when an employee logs an absence with a reason, the timecard shows nothing? I have set up the absence reason and…
-
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 …
-
How can I safely handle cases where GET_VALUE_SET returns null, and default the value to 0Summary: When the value set returns null (i.e., no leave has been taken), the formula either fails or doesn't return the expected accrual. Even though I am checking for …Pranjal Mohla 12 views 3 comments 0 points Most recent by A_R-Oracle Reporting and Analytics for HCM -
Need to update the absence Entry before holiday and after holidaySummary: Hi Everyone , We have requirement where we have to update absence entry for employees who is in long term absence. Below is requirement:- First Step: Check for …Krishna Manmohan 11 views 1 comment 0 points Most recent by Tamilarasan Sekar Reporting and Analytics for HCM -
How to Filter a Date Column by Another Date ColumnSummary: I have an OTBI analysis that is 3 subject areas. The goal is to show specific actions in Workforce Management - Worker Assignment Event Real Time, and then show…
-
BICC | Delta data records are not displayed correctlyHi, The BICC is to be used for the extraction of data. When testing the delta method, there are discrepancies between the status in the PER_ALL_ASSGINMENT_M table and th…Tobias I. 1 view 1 comment 0 points Most recent by Bala Mahalingam-Oracle Reporting and Analytics for HCM
-
Transaction Console -> Error Description and Error Resolution (hrc_txn_error)Summary: I have a requirement to get the data related to the transaction console when the transaction fails I need to get the error description and error resolution as d…
-
Query to pull balances and carryover on a specific dateHi experts, we need to generate a report that would display/ pull the balances and carryover as of specific date (Jan 1 2025). Currently, analysis is not able to do that…
-
Change to absence start or end date - event level reportingSummary: We have a requirement to report on changes to absence start and end dates i.e. when someone edits an existing absence. The OTBI Subject Areas are all Real Time …
-
N/ASummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
ANC_PER_ABS_ENTRY_DTLS table is emptySummary Absence entry Detail table not getting populatedContent Hi All When absence entry is created from the UI with basic mode, data is not getting stored in table ANC…Amol Patil HCM-Oracle 717 views 17 comments 0 points Most recent by mmnerva Reporting and Analytics for HCM
-
Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absenceSummary Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absence ONLY for 1 employeeContent Hello Dear SME's, Employee applie…C.R.Balaji 82 views 5 comments 3 points Most recent by Akhilesh_Singh-Oracle Reporting and Analytics for HCM -
Absence Balance Report Based on Balance Calculation DateSummary How to get the absence balance to include future dated absencesContent In the existing report, balances are reflected as of today; however, would like it to refl…User_2025-01-28-20-43-56-568 1.6K views 19 comments 3 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
SQL Query to get Absence Qualified Entitlements for an EmployeeSummary Need an SQL query to build a BIP report similar to what is available on the Absence Records UI which provides details of qualified entitlementsContent I'm not ge…User_UM4C6 1.1K views 6 comments 0 points Most recent by Rohini Rayavaram Reporting and Analytics for HCM
-
How to extract deleted records from HCM cloud?Summary: Extract deleted records from HCM Cloud for PaaS for SaaS integration Content (required): We are trying to build a framework, where different business objects in…BhaskarMukherjee-Oracle 292 views 6 comments 0 points Most recent by Niraj Reporting and Analytics for HCM
-
Need fetch past date absence plan balanceSummary: Need to fetch past absence balance Content (please ensure you mask any confidential information): My requirement is to perform inbound integration via OIC from …
-
How to pause scheduled process and prevent a child process from running?Summary: Hello everybody. I recently discovered that releasing a process that was on hold will cause it to run all child processes, even if the date/time of the original…AppsSupport 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Absence Plan Use report via OTBII need to create an Analysis report in OTBI (I am new to this so I have not yet able to create reports etc) that will show employees sickness absence and the days used a…Julie Searles 205 views 6 comments 0 points Most recent by User_SXNZ6 Reporting and Analytics for HCM -
Drill Down in Pivot table with BI PUBLISHERSummary I want to create a drill down from a result on a pivot table which will redirect you in another reportContent Hello, Someone know how can I crate a drill down in… -
Absence Balance MismatchHi All, Several employees have a balance discrepancy between the plan level and the accrual level. Is there a query available to retrieve this information and identify t…
-
vacation plan accrual balanceHi Team, Please find the attached screenshot below. I’m looking for the balance days of the Accrual Plan Balance in the Vacation Plan. Could anyone please let me know th…Karthikeyan s-Oracle 12 views 5 comments 0 points Most recent by Karthikeyan s-Oracle Reporting and Analytics for HCM
-
I have developed custom resource alert using workers api but it's not trigger notification for HRSummary: I have developed custom resource alert using workers api to trigger notification to HR if any employee return from maternity leave but it's not trigger notifica…
-
Plan period start date in absenceSummary: Hi Team, I am trying to get absence accrual detail in OTBI report. Please let me know how to get these details with plan period start date. Thanks Content (plea…Anup Karmankar 11 views 3 comments 0 points Most recent by Anup Karmankar Reporting and Analytics for HCM
-
How to disable the deeplink from the bot responseSummary: How can I remove the deeplink "Schedule time off" from the response coming from custom component. Content (please ensure you mask any confidential information):…
-
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 1.2K views 16 comments 4 points Most recent by GraemeC Reporting and Analytics for HCM -
Reporting on withdrawn absencesSummary Is it possible to report approved and withdrawn absence bookings in OTBI?Content We have a requirement to start reporting on absences which have been withdrawn b…Elizabeth Docherty 282 views 25 comments 0 points Most recent by ZeyadAbdullaMohamed Reporting and Analytics for HCM