My Oracle Support Banner

BEE Error: "Cannot Update as More Than one Entry for this Element Exists at the Effective Date" (Doc ID 1417596.1)

Last updated on JANUARY 03, 2017

Applies to:

Oracle Payroll - Version 12.0.6 to 12.1 HRMS RUP4 [Release 12.0 to 12.1]
Information in this document applies to any platform.

This note provides a brief overview of


Problem Statement:

When attempting to correct three Non Recurring element entries via BEE the following error occurs.

"Cannot update as more than one entry for this element exists at the effective date"

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1. Create 2 element entries for same element "Test"
    • Element1: date earned 01-DEC-20XX
    • Element2: date earned 02-DEC-20XX
    • Element3: date earned 03-DEC-20XX
  2. Create BEE batch with three lines for this element, each with date earned matching
  3. Set on BEE header Date Effective Changes set CORRECTION


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

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

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