Absence and Accrual
Discussion List
-
SQL Table where Webclock events information will be storedSummary: Hi All, We are looking for a report to capture details of Webclock Events. Its use is to check which all entries have Clock in And Clock out correctly, and the …Abhishek Bhaskar 36 views 2 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM -
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 …Amanda Hope 27 views 3 comments 0 points Most recent by Shivam Trivedi-Oracle Reporting and Analytics for HCM -
How to eliminate duplicate measure after joining 2 OTBI subject areaSummary: Hi all, I have a report with 2 subject areas (HCM and Projects) Is there a way to show for highlighted values 8, instead on 40 reported hours? Basically is the …Raluca Balan-Oracle 10 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Absence calendar seeded report does not show any dataSummary: Absence calendar report does not show any data Content (please ensure you mask any confidential information): Could someone advise why does the data does not po…Nancy Dsouza 9 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
The label 'Time and Absences' needs to be updated to 'Time and Any Time Away'Summary: The label 'Time and Absences' under the navigation path Me >> Time and Absences (Tile) needs to be updated to 'Time and Any Time Away' Current Behavior The labe…Rama Krishna_Annam 7 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
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 16 views 2 comments 0 points Most recent by Divya Kamsani 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 20 comments 3 points Most recent by Gaurav Bhardwaj Reporting and Analytics for HCM -
Is there a table which stores Absence balance for future date of and incremental planSummary: We are looking for a table or sql query which gives Absence balance as on future date. Absence plan is incremental, and accrual process will run for every bi we…Abhishek Jois 41 views 6 comments 0 points Most recent by Gaurav Bhardwaj Reporting and Analytics for HCM
-
Fast Formula for getting balance avail date in Oracle Absence Management?Summary: fast formula for getting balance avail date in Oracle Absence Management Content (please ensure you mask any confidential information): I need a fast formula fo…
-
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…
-
From which tables can I get the Workflow details of transactions archived in transaction console.Summary: Tables to get the Workflow task details of transactions archived in the transaction console. Content (please ensure you mask any confidential information): Vers…
-
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…
-
Roles required for PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILSSummary: Hi, We have created a report to get employee calendar, and we are using PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS in our query. This is working for us a…
-
Is there other table store info about qualified entitlement planHi Teams, table anc_per_abs_qual_entl is holding the data when user records an absence, do we have any other table or view stores the entitlement information when user n…
-
Report for Qualification EntitlementsSummary: Hi, we have a requirement to create a report for the Qualification Entitlement details of employees. We have checked OTBI and BIP (both ANC_PER_ABS_QUAL_ENTL an…
-
FMLA Qualified Entitlement Balance ReportSummary Does anyone have a report that pulls balances on qualified entitlements?Content I am able to pull reports of absences but not entitlements. Since some absences a… -
Can we set BPM expiration date for Absence Approval Tasks per absence type?Summary: In 24D, there is a new function in Absence Management called "Action on BPM Transaction Expiry," where we can configure each absence type to automatically appro…Shannon Teves 12 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
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 759 views 18 comments 0 points Most recent by Mr H 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 71 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 60 views 4 comments 1 point Most recent by Swapna Govind Reporting and Analytics for HCM -
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 27 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. 3 views 1 comment 0 points Most recent by Bala Mahalingam-Oracle Reporting and Analytics for HCM
-
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…
-
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…
-
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 83 views 5 comments 3 points Most recent by Akhilesh_Singh-Oracle 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