Resetting of Sequence Raises "java.sql.SQLDataException: ORA-04009" Error

(Doc ID 2325800.1)

Last updated on NOVEMBER 07, 2017

Applies to:

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

Symptoms

Reset the sequence by navigating to Configuration and Administration > Process Management> Reset Sequences
select:

I_TRANSMISSION_ACK_SEQUENCE_NO,
I_TRANSMISSION_REPORT_SEQUENCE, and
I_TRANSMISSION_SEQUENCE

With radio knob set to now, click on submit

The resetting fails with the following error:

 

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