Benefits
Discussion List
-
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 21 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 25 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 1 view 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
-
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…Pjs105 1 view 1 comment 1 point 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 2 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 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 1 view 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 1 view 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 73 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 12 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 14 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…
-
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… -
Report to show when a spouse works for the same companySummary Benefits for spouses that work for the same companyContent Hi All, I am hoping someone can help me out. We have a request to generate a report that shows when th…
-
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…Murali Peddini 21 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 22 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Fusion HCM OTBI/BI report usage analytics?Summary How to get OTBI/BI report usage analytics?Content Is it possible to get OTBI or BI report usage analytics? VIZ., input - Report Name Output - list of users who r…
-
What table holds the query associated with an User EntityContent Look for information where in the Fusion Database where the User Entity is stored? Trying to build an extract/report to generate details about a specific user en…Joe Roberts-Oracle 23 views 1 comment 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
BIP Layout Data Formatting issueSummary When I use the Data Formatting option for BIP layouts the dates are wrongContent When I use the Data Formatting option for BIP layouts the dates never come out c…Shawn McDonald 19 views 6 comments 0 points Most recent by Shawn McDonald Reporting and Analytics for HCM -
Need inputs to hold the Received Date (Benefits)Content Hi All, In which Subject area/Table holds "Received date" value. Navigation: Benefit Administration-->Enrollment-->Query an employee-->Pending action Items-->sel…