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 JULY 19, 2016

Applies to:

Oracle Human Resources - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms


On Dev:  11.5.10.2 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
-----------------------
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.


STEPS
-----------------------
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.


Cause

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