ACA Data Extract Error after Application of 2016 Patches: Temporary Table processing failure during allocation phase. (108,530) (Doc ID 2229526.1)

Last updated on FEBRUARY 01, 2017

Applies to:

PeopleSoft Enterprise HCM Benefits Administration - Version 9.1 to 9.2 [Release 9.0 to 9]
Information in this document applies to any platform.

Symptoms

When running the Affordable Care Act (ACA) Data Extract for Extract ACA Employee Data, the process fails with the following error:

ERROR
-----------------------
File: E:\pt85310c-retail\peopletools\src\psappeng\psaesql.cppSQL error. Stmt #: 2955 Error Position: 0 Return: 601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find the object "PS_ACA_EXT_INT1" because it does not exist or you do not have permissions.
Failed SQL stmt: TRUNCATE TABLE PS_ACA_EXT_INT1

Temporary Table processing failure during allocation phase. (108,530)

STEPS
-----------------------
1. Run the ACA Data Extract for Extract ACA Employee Data (Navigation: Benefits > ACA Annual Processing > Create ACA Form Data > ACA Data Extract).

Cause

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