Error Resetting Sequence When Running domainman.reset_sequence Procedure (Doc ID 1531719.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 5.5 and later
Information in this document applies to any platform.

Symptoms

When running the following command to reset the sequence:

exec domainman.reset_sequence('ACTIVITY_CALENDAR_SEQUENCE')

The following error is encountered:

Error caused during execution of the following statement:
alter SEQUENCE ACTIVITY_CALENDAR_SEQUENCE INCREMENT BY 6774 NOCACHE;
Error resetting sequence Table: ACTIVITY_CALENDAR Sequence:
ACTIVITY_CALENDAR_SEQUENCE

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