After 11i FP_K Rup5 upgrade, ADP Connection Integration Agent Errors ORA-01652: unable to extend temp segment
(Doc ID 1254368.1)
Last updated on NOVEMBER 23, 2020
Applies to:Oracle Human Resources - Version 220.127.116.11 and later
Information in this document applies to any platform.
On Dev: 18.104.22.168 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document