After 11i FP_K Rup5 upgrade, ADP Connection Integration Agent Errors ORA-01652: unable to extend temp segment
Last updated on NOVEMBER 15, 2017
Applies to:Oracle Human Resources - Version 126.96.36.199 and later
Information in this document applies to any platform.
On Dev: 188.8.131.52 version, 3rd Party Interfaces
When attempting to implement ADP Connection to process payroll via ADP, the Integration Agent does not work and the following error occurs in log file:
ERROR [Run Queue #1 - 12] com.hr.dataextract.OracleDataExtractor$ViewSelectionRunnable - java.sql.SQLException: [adp.datadirect][Oracle JDBC Driver][Oracle]ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
java.sql.SQLException: [adp.datadirect][Oracle JDBC Driver][Oracle]ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
at com.adp.drivers.dd.jdbc.base.BaseExceptions.createException(Unknown Source)
ERROR [Run Queue #1 - 12] System Logger - ----Exception Report for ----com.adp.exceptions.ApplicationRuntimeException: The extractor incurred an error creating a statement for the HR_ADP_WORK_STATE_TAX_V view.
The issue can be reproduced at will with the following steps:
1. Run ADP Integration agent to connect to ADP
2. Applied Patch 5957901
Note: Checked the performance of HR_ADP_WORK_STATE_TAX_V view separately and it is very bad. The view hr_adp_resident_state_tax_v also has performance issue.
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