Absence and Accrual
Discussion List
-
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… -
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 69 views 8 comments 0 points Most recent by Gunasagar Thimmapuram-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…Kelly Geldof 1.2K views 17 comments 3 points Most recent by Raghavendra Raghunath-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…
-
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…Mohab Ehab-Oracle 41 views 2 comments 0 points Most recent by Mohab Ehab-Oracle Human Capital Management
-
How to add Role in the Parameters in the Absence Workflow?Summary: Setup a Workflow in Absence wherein we need to check if the initiator of the Absence Entry is a User that has a Specific Role. Requestor's Role Details is not a… -
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 19 views 2 comments 0 points Most recent by Marius Neata Reporting and Analytics for HCM
-
How to Customize the sub-template for AbsenceApprovalNotificationTemplate?I want to change a couple of words in the content of "AbsenceApprovalNotificationTemplate" workflow notification. As the required place was not found in the AbsenceAppro… -
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 31 views 4 comments 0 points Most recent by GummadiNamrata Reporting and Analytics for HCM
-
Query to get the scheduled work hours of employee from shifts the employee has assignedContent I have a requirement to report the weekly work hours the employee is scheduled for. Employee will be assigned work schedule and work schedule will be liked with … -
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 2 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…
-
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 42 views 1 comment 0 points Most recent by Stephen Jones Reporting and Analytics for HCM
-
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 49 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 32 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 -
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 1 view 5 comments 0 points Most recent by Abhishek Jois 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 61 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 1 view 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 32 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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…Shannon Lackmeyer 47 views 3 comments 0 points Most recent by vijaya lakshmi 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 11 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 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM