ACA Data Extract Error after Application of 2016 Patches: Temporary Table processing failure during allocation phase. (108,530)
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.
When running the Affordable Care Act (ACA) Data Extract for Extract ACA Employee Data, the process fails with the following 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)
1. Run the ACA Data Extract for Extract ACA Employee Data (Navigation: 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
Million Knowledge Articles and hundreds of Community platforms