Benefits
Discussion List
-
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…User_2025-02-04-08-51-08-912 60 views 10 comments 0 points Most recent by MarleneRay Reporting and Analytics for HCM -
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 31 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 53 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 566 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 31 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… -
Colorado state employee retirement benefits year end reportingWorking with a school district in Colorado whose employees are participants of PERA. PERA has a very specific requirement for reporting year end data in the exact EFW2 S…Muriel Sindyla 11 views 1 comment 0 points Most recent by Rajesh Tota Reporting and Analytics for HCM -
I Need a report showing pension contribution by employees and employersSummary: Does anyone know which subject areas I should use to get the pension contribution from employees and employers? Content (please ensure you mask any confidential…Isabela Radivoi 81 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
How to link Dependent Care Physician to DependentSummary How to link a Dependent with their Dependent Care PhysicianContent I am trying to pull a report of employee and dependent care physician after Open Enrollment. I…User_2025-01-30-03-28-08-030 41 views 9 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Direct join between Benefit and Element tables issueSummary: Hi, I am building a report where I need to show the CONTRIBUTION_PERCENTAGE (BEN_PRTT_RT_VAL.ANN_RT_VAL) from Benefit and CONTRIBUTION_AMOUNT (pay_element_entry…Ranjubala Pradhan 61 views 3 comments 0 points Most recent by Ranjubala Pradhan Reporting and Analytics for HCM
-
subject area (affiliation)Hello, I want to create a report on movements and in this report I would like to have the following information: - Affiliation (social security in a French context) -Soc…Hiba Ghoualmia 1 view 2 comments 0 points Most recent by Hiba Ghoualmia Reporting and Analytics for HCM -
How do I download Diagnostic Test Reports?I have run several diagnostic tests regarding an issue we are experiencing. I can view the report, but am also needing to download the tests/reports in HTML. Does anyone…Alicia Martens 163 views 2 comments 0 points Most recent by Alicia Martens Reporting and Analytics for HCM -
How to restrict based on previous Backout statusSummary: Hello All, I'm currently working on restricting the custom BIP notification based on below scenario. If an employee benefits is backed out and reprocessed again…
-
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 …
-
OTBI Analysis for Benefit Dependents over 21Summary: I need an OTBI analysis get information for dependents who are 21 years of age in every year. Content (required): I created an analysis based on Benefit Enrollm…Ayesha Iroshani 51 views 4 comments 0 points Most recent by User_FG152 Reporting and Analytics for HCM
-
Benefit OTBI report with correct option namesI need to create an OTBI report to capture benefit details for a specific benefit program. I need to get the information of employees who are elected and declined that b…Ayesha Iroshani 21 views 6 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
How to make BI report output file (RTF template with Excel op) as non editable once it's downloadedSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
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 2.5K views 3 comments 1 point Most recent by SachinP21 Reporting and Analytics for HCM -
Is there any way to fetch real updated absence records via BIP Report?Summary: - Content (required): Background: Absence Management Module We currently need to capture the real updated absence records, distinguish which records are newly c…
-
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 51 views 5 comments 2 points Most recent by Viral Abotiyawala-Oracle Reporting and Analytics for HCM -
Dependent ReportSummary BIP that provides Dependent info (Name, Person Number, Age, SSN, etc)Content This a BIP that includes Dependent data (sorry, couldn't do an Answers report)Rick P Klassen 193 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Payroll Deductions by Benefit PlansSummary: Looking to report on employee benefit deductions and their respective plan by pay period. Content (required): We have been tasked to report on employee pre-tax …