E-AE: Keep Getting 'Unable to obtain a unique Temporary Table Instance number error' When Running HRS_DUPE_PRC After Upgrade (Doc ID 2215151.1)

Last updated on DECEMBER 16, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.

Symptoms

ISSUE CLARIFICATION

ISSUE STATEMENT
---------------
When trying to run delivered program HRS_DUPE_PRC, we got an error message in the log file.

ENVIRONMENT
---------------

Database: Oracle 12C
PeopleSoft: HCM 9.2
PeopleTools: 8.54.17



STEPS
---------------
The issue can be reproduced with : Navigate to Recruiting > Administration > Process Duplicate Applicants, then click on the "Create New Search", then select Last name, First name and middle name. Click run. The process was executing and then abend immediately after.

ERROR
---------------
Unable to obtain a unique Temporary Table Instance number. (108,529)

Temporary Table processing failure during allocation phase. (108,530)

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