My Oracle Support Banner

Benefits Visualization Plan Migration as of January 1 Results Do Not Match Query of HEALTH_BENEFIT Table (Doc ID 2828747.1)

Last updated on FEBRUARY 02, 2023

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


The Benefits Visualization graph for Plan Migration as of January 1 shows how many employees have enrolled for a specific plan each year (as of January 1), however, the numbers do not match a query of the HEALTH_BENEFIT table for all employees newly enrolled each year on the 1st of the year.

Steps to Replicate:

  1. Review the Benefits Visualization graph for Plan Migration as of January 1 and select to open one of the benefit plans to review the numbers each year.  Navigation:  Workforce Administrator Menu > Benefits Visualization tile.
  2. Query the HEALTH_BENEFIT table for the benefit plan example to see the number of employees enrolling in the plan each 1/1/xx.  Navigation:  Reporting Tools > Query > Query Manager.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.