Benefits
Discussion List
-
SQL query to see the dependents for an employee who have pending action items in benefitsHi Experts, Can anyone please share an SQL that can show me the list of all dependents for an employee who have a pending action in the benefit plans? Say for a dependen…Aloka Bhattacharya 26 views 2 comments 0 points Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Pending Action Items ReportSummary: I am attempting to create a report of all current pending action items in our system in OTBI. However, I seem to only be receiving completed action items and no… -
To pull Open Enrollment Benefit data if life event closed and Employee Enrollment not yet submittedSummary: To pull Open Enrollment Benefit data if life event closed and Employee enrollment not yet submitted Content (required): We are looking SQL query/OTBI report to …
-
Benefits | Added or Removed Dependents ReportSummary: Hi All! Does anyone have an example report that shows added or removed dependents? Content (required): We would like to audit our benefits to see if employees h…Tristan Aquino 1 view 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
OTBI report to sum element Medical ER rate for calendar year where payroll isn't processed in OracleSummary: Looking for OTBI report to sum element Medical ER rate for calendar year per employee where payroll isn't processed within Oracle for W2. Or if someone has a da…Becki Willard 13 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Benefits Change ReportSummary: Hello, Looking for a report that shows a before/after comparison of benefits. In one line it should report: Name, Current Plan, Current Option, Current EE Rate,…
-
How to make HCM Extract bursting reach child nodes in XML?Hi Experts, We have a benefits extract , that pulls employees (they belong to different legal employers) and their dependents. We now have to burst this file by Legal em…
-
Data is not populated in HWR_WLNS_POINTS_REPORT tableSummary: Data is not populated in HWR_WLNS_POINTS_REPORT table Content (required): We have configured the Wellness activities and tasks and, employees have completed the…Jhansi K 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Benefit Certifications tableSummary: We have a requirement to fetch "Certifications" tab related data in the BIP report. May I know in which tables holds the information on certification? Content (…Satyabrata Nanda 11 views 2 comments 0 points Most recent by Satyabrata Nanda 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…BhaskarM-Oracle 23 views 5 comments 0 points Most recent by BhaskarM-Oracle Reporting and Analytics for HCM
-
Printing details on a single row using a EText Fixed Position TemplateSummary Need help in printing both parent and child XML details in the same rowContent Hi All, Need your suggestions on how to solve the below requirement: 1. Applicatio…Brendon Charles-24581 28 views 8 comments 2 points Most recent by Bhupendra Singh Rawat-Oracle Reporting and Analytics for HCM -
Waived Benefits fields in OTBISummary: I have a report that HR has requested to add if the have waived their benefits elections. Is their a field/ subject area that will store this information? I'm c…RJ Blankenship 3 views 3 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
1095cSummary: How to modify or update 1095c form? Content (required): Version (include the version you are using, if applicable): 21D Code Snippet (add any code snippets that…Saksham S 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Loss of benefit eligibilitySummary: Content (required): I am trying to report on employees who are losing eligibility to benefits based on recent life events processing. Can anyone help me with th…
-
How can we fetch "Non-Union Benefit Eligibility Dates" in OTBI ?Summary: From the attached screenshot we can fetch all the fields under Extra Information in Workforce Management - Person Real Time subject area except Non-Union Benefi…AaronJai 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need a report that shows everyone is a Closed Life Event StatusSummary: Could someone provide me with the correct criteria that shows everyone who is in a closed Life Event Status. I am using the subject area "Benefits Enrollments R…Jennifer Ritcey 11 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
HCM reporting on hours and average hours workedSummary HCM reporting on hours and average hours workedContent Hello Does anyone have any ideas about tracking average hours worked for hourly associates, as it relates … -
SQL Help for Dates crossing into New YearSummary: HI All, I have a requirement to pull a list of dependents that will be turning 21 within 6 weeks (ie. If I run the report today, I should be pulling into those …
-
Does anyone know which process populates this Benefits table?Summary: Content (required): I'm looking at table BEN_PRTT_RT_VAL and wondering if this is getting updated by a Benefits process vs. Payroll process? We see mismatches w…Scott Paulin 2 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
How to use the Min aggregate function along with group by clause in OTBI analysisSummary: I have a requirement to build analysis to fetch all the benefit enrollment data for a participant as well as dependent. I need to fetch the actual enrollment da…
-
Pending Action Items ReportSummary: I am attempting to create a report of all current pending action items in our system in OTBI. However, I seem to only be receiving completed action items and no…
-
Seeded Data Model and Report For Grade Step ProgressionSummary Seeded Data Model and Report For Grade Step ProgressionContent Hi Team, Where do get the Seeded Data Model and Report for activity 'Grade Step Progression' scree…Murali Peddini 72 views 13 comments 0 points Most recent by Vijay Gorania Reporting and Analytics for HCM
-
Reg OTBI CountHi we are have OTBI report which gives the count of enrollment for each plan , for some of the plan no emp is enrolled ,in the report we are not getting this plan detail…Razesh 11 views 10 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Merged: We invite you to attend a ⭐️ LIVE ⭐️ webinar to deeply understand your Oracle Cloud Applica…This discussion has been merged.Bethany Hubbell 1 view 0 comments 0 points Started by Bethany Hubbell Reporting and Analytics for HCM -
Unable to edit delivered RTF report templateSummary: Unable to edit delivered RTF report template Content (required): Hi, I'm attempting to edit the benefits summary delivered RTF template. The issue I'm running i…User_IO0OQ 11 views 7 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
Report for Eligible Benefit plan details for EmpHi We have process Open enrollment and life event is in started state, and emp can enroll into the benefit plans , but we need to created a report which display emp deta…
-
Creating a ReportSummary I am looking to create a report in OTBI for when a Domestic Partner and/or Domestic Partner Child is added to the following coverages: -Medical -Dental -VisionCo…Jennifer Ritcey 16 views 3 comments 1 point Most recent by Jennifer Ritcey Reporting and Analytics for HCM
-
Allow employees to access BI ReportContent Hello, I have a BI report that generates a benefits related letter. I would like to make this available to employees to access via self-service somehow. Does any…Susan Anderson 24 views 2 comments 2 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Hours worked counted by Calendar Weeks LogicSummary Need help with logic to count hours worked based on calendar weeks worked for 401K vendorContent Hi Friends, We have a requirement where our 401K plan requires h… -
Benefit Eligibility CriteriaContent Hi All, When we click on the Eligibility profile able to see View hierarchy and Eligibility criteria. Can you please share inputs in which Table/OTBi subjetc are…