ACA_EXTRACT Process TEMP Tables Issues
(Doc ID 2241518.1)
Last updated on JUNE 18, 2018
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!