My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.