Benefits
Discussion List
-
Employee self service page not displaying in mobileSummary: Employee self service page not displaying in mobile, this is mobile only issue. Content (please ensure you mask any confidential information): We are testing Op… -
Benefits Override Eligibility reportSummary: Is there a way to report on the employees and benefits that have been Overridden using the Override Eligibility in Benefits please. Content (please ensure you m…
-
Approach required for Benefits post election formulaSummary: Approach required for Benefits post election formula Content (please ensure you mask any confidential information): Requirement: If employee has enrolled in Emp…
-
Can we restrict Benefits/Compensation Specialist from accessing Element Entries?Summary: Element Entries in BI Publisher Reports Content (required): For a client, with different legal entities, in reports we are making use of secured views at assign…VDoolhur 21 views 2 comments 0 points Most recent by Ramona Popescu-Oracle Reporting and Analytics for HCM
-
Which table stores the data from plans and plan types tab?Hi Team, I am trying to fetch the data from plans and plan types tab which is under below navigation: Benefits Administration > Plan Configuration > Program Name > Basic…Saurabh_Mharolkar 21 views 2 comments 0 points Most recent by Thiru-Oracle Benefits-Oracle Reporting and Analytics for HCM
-
Benefits Report of Terminated EmployeeSummary: Hi All, Does any one have a Benefits report of terminated employees which Shows their enrollments with Dates parameter? Thanks Content (please ensure you mask a…Naveen setti 11 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Benefits arrears OTBI reportHi all, We are trying to develop a new OTBI report for benefits arrears , we have used the following 2 subject areas with effective date prompt. 1.workforce management -…yugandhar 101 views 11 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Tables to pull the data for the eligibility profiles under compensation profile usage.Hello Team, The requirement is to pull the data for the eligibility profiles under compensation profile usage which are assigned to grade ladder. Please suggest the tabl…Saurabh_Mharolkar 41 views 14 comments 0 points Most recent by PA-HCM Reporting and Analytics for HCM
-
query to get variable rate program for all employeesSummary: Content (please ensure you mask any confidential information): Hi all, I currently have a query where I am trying to get the variable profile name (under manage… -
Which tables stores the information about the benefits that are being used in an organizationSummary: Can some one help me in finding the table for finding benefits that are being used in an Organization Content (please ensure you mask any confidential informati…yugandhar 31 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Not enrolled in Waive but showing on OTBI report, along with standard enrollmentIn OTBI using Benefits - Enrollments Real Time, we are getting 2 records on some employees - 1 enrollment in Waive and 1 enrollment in Medical. They are only enrolled in…
-
SQL query for linking between life event and benefits plansSummary: Need sql query or back end table for the linking of add life event(BEN_LER_F) and benefits plans(BEN_PL_F) Content (please ensure you mask any confidential info…
-
Benefit Participant Eligibility Employment Assignment Category TableHi, We are trying to create a report to fetch Participant Eligibility information. But not able to figure out the Employment Assignment Category information. Can anybody…
-
Which tables stores the information for Manage Benefit ProvidersSummary: Which tables stores the information for Manage Benefits Provider Content (please ensure you mask any confidential information): Which tables stores the informat…
-
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records …
-
Query to get a data dump for a Benefit planSummary: We have a requirement to identify last updated by name and time stamp for Beneficiary related information on Life insurance plans. This is for legal reason we w…
-
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…
-
Report showing enrollments As Of Prompted DateSummary: Requirement is for an OTBI report showing enrollment detail as of a prompted date and plan(s). For example, what employees were enrolled in Voluntary Life as of…
-
Beneficiary missing some dataSummary: Hello! I am using subject area Benefits - Enrollment Real Time to pull out primary beneficiaries. I have a record in file that is missing some data. EMP Person …Sarah D 11 views 5 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Sample query required to get all the benefit certificates in pending actionSummary: Looking for the sample query to get the pending action certificates in HCM benefits . Content (please ensure you mask any confidential information): Version (in…
-
Query that retrieve Eligibility Profile from Benefit ProgramSummary: Hello! I need some help to finish some query, and it envolve Eligibility Profiles in benefit Program. Is there a table that I can get the Eligibility Profile th…Matheus Roberto 21 views 1 comment 1 point Most recent by Monica Vijayashanker -Oracle Reporting and Analytics for HCM -
Need a Sample SQL to fetch Benefits Enrollment Data using a Batch Name from HSDLSummary: I have loaded the Benefits Enrollment using HSDL where we provide Batch Name. My requirement is that using the Batch Name as a parameter, I need to fetch the lo…Sujeeth Chinta 33 views 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM
-
Details of employees who are having the access of respective modules.Hi Everyone, For audit reason We have received an requirement where our need to is to get details of employees who all are having an access for respective modules and al…Jebarsan Thangam John Durai Raj 11 views 0 comments 0 points Started by Jebarsan Thangam John Durai Raj Reporting and Analytics for HCM
-
Primary Beneficiary DetailsSummary: I need to create an OTBI analysis for to get details about one benefit plan including primary beneficiary details. I used the Benefit- Enrollment Real time subj…Ayesha Iroshani 32 views 4 comments 0 points Most recent by Mahesh Sharma Reporting and Analytics for HCM
-
Historical Benefits Enrollment DataHi I am looking to see if anyone has a report showing historical benefits data by employee (both active and inactive) . Something that will show me all plan election det… -
benefits cancelled before coverage start dateSummary: Hello Experts, I have to extract in BIP the employees that cancelled or changed a benefit plan before the coverage effective start date. Can you explain me how …Sebastian La Spina 21 views 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM
-
Is there a report or query to see changes for employees Loans status before payroll runsHello All, Is there a report or query to see changes to employees Loans status before payroll runs, for example if they refinance , new etc? Thanks, Version 23CGail Wilmoth 21 views 2 comments 0 points Most recent by Chai-Oracle Reporting and Analytics for HCM -
Reasons for invoking the Benefits waive optionSummary: There is the option to configure the Waive option for Benefits Plans but is there also an option to configure reasons for waiving Benefit Plans? Or does Oracle …Peter Bealls 11 views 2 comments 0 points Most recent by Peter Bealls Reporting and Analytics for HCM
-
Why do i lose virtually all records in a query dataset when I apply a filter using the analysis toolSummary: i am trying to pull a report listing all those who are on the Basic life insurance Benefits. When I apply a filter based on Participant Enrollment Status to omi…Robin Olsen 11 views 4 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM
-
fast formula to have the eligibility criteriaSummary: Eligibility Criteria to Assign Benefits Tasks through Journeys Content (please ensure you mask any confidential information): I have built a fast formula to hav…