Benefits
Discussion List
-
How to get the termination action/reason for the report with benefit details?Summary: I have an OTBI report built with benefit details. I need to add employee's termination reason/action for that report. Content (required): I cannot find a benefi…Ayesha Iroshani 256 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Can anyone here post an HDL template for loading Benefits objects into the system?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):RithwikSivanand111111 31 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
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 11 views 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 21 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,…
-
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 31 views 1 comment 0 points Most recent by Raghavan p-Oracle 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 211 views 5 comments 0 points Most recent by BhaskarMukherjee-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 116 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 21 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 31 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…Scott Paulin 12 views 2 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM
-
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 21 views 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…User_2025-02-11-00-58-38-371 21 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 …User_2025-02-04-08-51-08-912 21 views 6 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
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 21 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…User_2025-02-11-20-55-10-551 21 views 7 comments 0 points Most recent by User_2025-02-11-20-55-10-551 Reporting and Analytics for HCM
-
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…User_2025-02-01-03-43-13-079 112 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…User_7836 31 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_2025-02-11-21-40-21-159 52 views 7 comments 0 points Most recent by MandeepGupta 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…User_2025-02-11-00-58-38-371 24 views 3 comments 1 point Most recent by User_2025-02-11-00-58-38-371 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 34 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…
-
Eligibility Profile Validation Report for BenefitsSummary A lot of time customer requests to validate Or have the Benefits Eligibility Matrix handy as to query for each plan and combinations using UI is a cumbersome pro… -
Benefits OTBI Analysis with Effective Date Parameter Not workingSummary Benefits OTBI Analysis with Effective Date Parameter Not workingContent Team, I have a Benefits enrollment details OTBI analysis which is working fine without pr…User_2025-02-01-03-43-13-079 51 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Report for Duplicate DependentsSummary Report for Duplicate DependentsContent Hi , Any one can help is their any report to find the duplicate dependents for each employee Regards, ReddykrishnaReddykrishna 62 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM