My Oracle Support Banner

BEN110.sqr Snapshot Premium Report - Intermittent Zero Premium For Non-Zero Coverage Amount (Doc ID 2148861.1)

Last updated on JULY 29, 2022

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.


When an employee's coverage has only employer paid premiums and zero hours on pay period's pay sheet, no premiums are showing in the BEN110.sqr SNAPSHOT PREMIUM REPORT.

These premiums are required in order to pay the benefits carriers the correct amounts.


1.Test 1 - gross bi-weekly earnings 3802.43
 Test  2 - gross bi-weekly earnings 55.00 per hour - hours vary
2. Enrollment Snapshot Options:
Plan types Health and Life
Processing Options - Include payroll deduction and Calculation
Life/Disability Covg
Include Implied Terminations, Include Original Enrollment Date, Include
Implied Dependent Term
3. Create EDI Trading Partners page
4. Run the Ben100a.sqr, Refresh Benefit Snapshot As Of Date Apr 3/16 - completed successfully
5. Run the Ben110.sqr - Snapshot Premium Report Option.

Ben110.sqr picks up the date from the last Ben100a.sqr run.

Result when the process is run:

employer paid deductions only are NOT showing on the Ben110.sqr report.




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.