My Oracle Support Banner

Affordable Care Act (ACA) Part Time Employees Error: ORA-02289 Sequence Does Not Exist (Doc ID 2112120.1)

Last updated on MARCH 03, 2017

Applies to:

Oracle Advanced Benefits - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Affordable Care Act (ACA)

When attempting to process part time employees with dependents, the Benefits ACA Archive Process results in the following error:

ORA-02289: sequence does not exist
Errored LASTNAME, FIRSTNAME Person_id XXXXX




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

1. US HRMS Navigator responsibility
2. Navigate to Processes and Reports
3. Run the Benefits ACA 1095C Print Report


Cause

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.