Absence and Accrual
Discussion List
-
Dynamic Pivot in excel templateSummary: Content (required): I have 2 sheets on my excel template output. the second has all the output columns and their data. Based on second sheet I need to create a …Jaeyshree Kumaran 31 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Absence Management | Hours Worked Year to DateContent Hi all, I have a request to create a report that shows hours worked year to date. Is there a specific subject area that I should be referencing? We do have the A…Tristan Aquino 20 views 2 comments 0 points Most recent by Tristan Aquino Reporting and Analytics for HCM -
Issue with "Workforce Management - Absence Real Time"Content Hi Team, We have designed a specific report using the OTBI "Issue with Workforce Management - Absence Real Time". This was working fine till last month and now w…Kiran Kancherla 23 views 3 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
Additional Information from Accrual Plan BalanceSummary Require Table and column name for additional information fieldContent Hi Team, I need to extract the additional information field description for the Absence Pla…Darius Sunder 124 views 4 comments 0 points Most recent by Darius Sunder Reporting and Analytics for HCM
-
Ability to find out the Work Schedule based on ShiftSummary Ability to find out the Work Schedule based on ShiftContent Dear Team, Basic Requirement is to develop the custom BI report based on Shift Details to find out th…Hussainaiah Bodisetty 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI report to extract Status information for Absence ManagementSummary Any pre build report to extract absence type and status information for Absence Management?Content Hello, If anyone has any pre build report/query to fetch the d…
-
Subject Area which includes Maternity Weekly Average EarningsContent Can any one help me to identify subject area which contains below highlighted field in the attachment? Absence Administration (Maternity Leave) -> Override Avera…
-
Override Average weekly earning field in OTBIContent Does anyone know if the Override Average weekly earning field that can be found in Absence Records under legislative information is available in OTBI?Tasha 25 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Absence related OTBI analysis returning no resultsContent Hello, I have a couple of absence related analyses which are no longer returning any results. They worked fine last month. We just had our quarterly update this …Susan Anderson 42 views 10 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
New Absence within 3 days of old AbsenceSummary We require a report that would show any colleague who had an absence closed, and a new absence opened within 3 days.Content Hi, I am currently working on an abse…Mitch_123456 22 views 1 comment 0 points Most recent by Venkata Sumanam Reporting and Analytics for HCM
-
OTBI > Ability to Capture Name of Employee Performing Adjust Balance on Employee BalanceContent Hello All, I will appreciate your support on the following issue: Our customer wants to capture the name of the employee who performs Adjust Balance on Employee …Bernard T 16 views 6 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Accrual Balance Report is showing double the actual valueSummary Accrual Report is showing the balance as double what it should beContent Hi, I have created a accrual balance report in OTBI using the Accrual Real Time subject …
-
How to navigate from OTBI report to Absence Record Entry page in Edit modeSummary There is no Deep Link available to navigate to Absence Record page in Edit Mode using Absence Entry ID. Want to know if there is any way to open the Absence Reco…User_UM4C6 52 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI > Subject Area for Employees Assigned Work ScheduleContent Hello All, I will appreciate your support in the following issue: We have defined different Work Schedules which are assigned to different population based on sp…
-
Help required to find the User Entity for the table ANC_PER_ACRL_ENTRY_DTLS to use in extractContent Can anyone please tell me what is the User Entity for the table ANC_PER_ACRL_ENTRY_DTLS so that i could use the columns in extracts. Version Oracle Cloud Applica…Amrish Kumar-210718 44 views 3 comments 1 point Most recent by Amrish Kumar-210718 Reporting and Analytics for HCM
-
Absence Calendar Details Real Time - Incorrect Data in ReportContent Hi Experts, We have created a OTBI report in which we are getting the results as per leave type and for one specific leave type, we are getting very small (Incor…Kiran Kancherla 22 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Extract Projected Accrual Absence Balance in HCM/BIP reportSummary Extract Projected Accrual Absence Balance in HCM/BIP reportContent Hi Experts,We have a requirement to fetched projected Absence balance of employee in extract t…Rajeev Nayan 489 views 6 comments 3 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Need Employee Leave Balance Report ?Summary Need any pointers/hints for building Employee Leave Balance ReportContent Expected Layout Parameters Effective Date : 06-Jul-2015 Employee Leave Balance Report P…AshishERPCloud 657 views 10 comments 5 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Absence cases and Details linked to absenceContent I am looking to build a report that includes the absence cases and the associated absence and details from the documents that have been attached in order to prov…Sharon Harper 28 views 2 comments 1 point Most recent by Sharon Harper Reporting and Analytics for HCM
-
How to Report available working hours of all Employees in a department excluding Absence HoursSummary OTBI Report for Available Working Hours of All Employees using either FTE or Normal Working Hours from Employee Assignment by excluding the Absence Hours during …
-
Effective date for OTL Absences issueSummary Although an effective date is set via presentation variable values are counted by a different dateContent Hi everybody, I'm struggling with the following report …Stefan Orac 86 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Scheduled Absences FieldSummary How do I get scheduled absences for this plan year only?Content Hi I need to run an accrual report for Finance and they need the absences booked but not taken in… -
Not able to fetch the absenec plan balance adjustment date ( i.e ProcdDate in PersonAccrualDetail.daSummary Need to Fetch Balance Adjustment details for different plans . Not able to fetch Balance adjustment date ( i.e ProcdDate in PersonAccrualDetail.dat file)Content …chaitanya voleti 34 views 4 comments 0 points Most recent by chaitanya voleti Reporting and Analytics for HCM -
Error with Month as a Presentation Variable PromptSummary ORA-01722: invalid number at OCI call error when calling the report through prompt but works fine when hard-codedContent OTBI Report runs fine in Edit mode and s…
-
Query Absence Pending TransactionsContent Hello experts. I'm trying without success to create a report that gives me the history of transactions. Category - Status - to whom - initiated at - Approver (As…Pedro Teixeira 219 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Which table to get the Plan Period Start DateSummary Plan Period Start DateContent Dear Expert, Which table to can we get the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached …Vasanthakumar Ravi 117 views 6 comments 0 points Most recent by User_D33E2 Reporting and Analytics for HCM -
Identify retro changes on absence entriesSummary Identify retro changes on absence entriesContent How do we identify retro changes on absence entries? For example. employee A applies for leave from 10/1/2020 to…Sowdha Murugan 29 views 3 comments 1 point Most recent by Matthew Voss Reporting and Analytics for HCM -
Workforce Management - Accrual Real Time/Worker Assignment Event Real TimeSummary Issue when combining subject areasContent Hi! Really hoping someone can help with my query. I would like to show the annual leave absences taken by month for a p…
-
Report on Absence approved dateSummary Report on Absence approved date in OTBIContent Please share the steps to capture Absence approved date when reporting on other absence details in OTBI. I have se…
-
Absence Booked in future date with complete detailsSummary Absence Booked in future date with complete detailsContent Hi Team, We wanted to fetch all the employees who booked their absences in future-date (for example be…