ORA-01653: Unable to Extend Table APPLSYS.WF_DEFERRED Error when Trying to Refer Applicant (Doc ID 1449649.1)

Last updated on AUGUST 10, 2017

Applies to:

Oracle iRecruitment - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 16-Sep-2013***

Symptoms

When attempting to refer an applicant, the following error occurs:

ERROR
-----------------------
Error Page
You have encountered an unexpected error. Please contact your System Administrator for assistance. Click here for exception details.

Exception Details:

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table APPLSYS.WF_DEFERRED by 16 in tablespace APPS_TS_QUEUES
ORA-06512: at "APPS.WF_NOTIFICATION", line 4054
ORA-06512: at "APPS.IRC_NOTIFICATION_HELPER_PKG", line 155
ORA-06512: at "APPS.IRC_NOTIFICATION_HELPER_PKG", line 302
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
(..)

## Detail 0 ##
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table APPLSYS.WF_DEFERRED by 16 in tablespace APPS_TS_QUEUES
ORA-06512: at "APPS.WF_NOTIFICATION", line 4054
ORA-06512: at "APPS.IRC_NOTIFICATION_HELPER_PKG", line 155
ORA-06512: at "APPS.IRC_NOTIFICATION_HELPER_PKG", line 302
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
(..)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: iRecruitment Recruiter.
2. Navigation: iRecruitment Home - Vacancies tab.
3. Search for vacancy.
4. Select vacancy.
5. Press View Applicants button.
6. Select applicant.
7. Press Refer button.
8. Fill in details.
9. Press Send button.
10. Get error message.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot refer applicants to other recruiters or managers.

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