Error Publishing / Unpublishing Work Schedule: ORA-08004: sequence CAC_SR_SCHDL_DETAILS_S.NEXTVAL (Doc ID 2110983.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

When Publishing/Unpublishing a Schedule pattern to an assignment  the following error occurs:

ERROR

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-08004:
sequence CAC_SR_SCHDL_DETAILS_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
ORA-06512: at "APPS.CAC_AVLBLTY_PVT", line 1303
ORA-06512: at "APPS.CAC_AVLBLTY_PVT", line 2212
ORA-06512: at line 1
....
## Detail 0 ##
java.sql.SQLException: ORA-08004: sequence CAC_SR_SCHDL_DETAILS_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
ORA-06512: at "APPS.CAC_AVLBLTY_PVT", line 1303
ORA-06512: at "APPS.CAC_AVLBLTY_PVT", line 2100
ORA-06512: at "APPS.CAC_AVLBLTY_PVT", line 2337
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)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

STEPS
The issue can be reproduced at will with the following steps:
1.Navigate to UK HRMS Manager>Work Structures>Work Schedules>Maintain Schedules>Schedules
2.Select Update
3.Uncheck the Publish Schedule check-box.
4.Apply: error occurs


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