Error 'APP-PAY-07220: The primary key specified is invalid' Processing the Open Life Event

(Doc ID 1388703.1)

Last updated on JUNE 05, 2017

Applies to:

Oracle Advanced Benefits - Version 12.0.6 and later
Information in this document applies to any platform.
*** Checked for relevance on 19-Mar-2015 ***


On 12.0.6 version in Oracle Advanced Benefits,

When attempting to process the Open life event, the following error occurs:

APP-PAY-07220: The primary key specified is invalid.

Cause: The primary key values specified are invalid and do not exist in the schema.
Action: Check the primary key values before attempting to carry out the operation again.

The issue can be reproduced at will with the following steps:
HRMS Manager>People>Benefit Service Center>
1. Go to responsibility US Super HRMS Manager and navigate to People > Benefits Service Center.
2. Date Track 01-Sep-14 and query an employee.
3. From the Desktop Activities drop down, select Process Open Enrollment and choose Assigned Life Event Occurred Date of 01-Jan-2015 > Continue.


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 hundreds of Community platforms