2016 ACA extract getting an error (Doc ID 2229014.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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


On : 9.2 version, Affordable Care Act

When running the 2016 ACA extract getting the following error

-- 09:55:41.016 Process 337365 ABENDED at Step ACA_EXTRACT.P110-AMT.Step010 (Action SQL) -- RC = 8601
-- 09:55:41.598 SQL Error: [IBM][CLI Driver][DB2] SQL0406N A numeric value in the UPDATE or INSERT statement is not within the range of its target column. SQLSTATE=22003

The issue can be reproduced at will with the following steps:
ACA Data Extract
Benefits / ACA Annual Processing / Create ACA Form Data / ACA Data Extract


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