ACA_EXTRACT Process TEMP Tables Issues
Last updated on MAY 03, 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 ACA Data Extract for Extract ACA Employee Data, the process could fail with the following errors:
1.ORA-00942: table or view does not exist
Failed SQL stmt: TRUNCATE TABLE SYSADM.PS_ACA_EXT_INT1
2. ACA_EXT_INT TEMP TABLE NOT CREATED - RECORD SKIPPED
3. The stats section in the App Engine ACA_BAS_EXTR.Steo060 never executes for the temp tables that are loaded the Data Extract.
There is no commit being processed, so the stats never generate.
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