My Oracle Support Banner

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

Last updated on JULY 03, 2023

Applies to:

Oracle iRecruitment - Version 11.5.10 HRMS FP.K RUP9 and later
Information in this document applies to any platform.

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.