Error Running Domainman.Reset_sequence When Running CU5 Install (Doc ID 729646.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.5.05 to 5.5.05
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 5.5.05, When attempting to run the installation step, Execute domainman.reset_sequence, the following error occurs:

ERROR
Error resetting sequence Table: ACTIVITY_CALENDAR_OVERRIDE Sequence:
ACTIVITY_CALENDAR_OVERRIDE_SEQ
BEGIN domainman.reset_sequence; END;

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Try to install OTM afresh on CU5
2. Run the Execute domainman.reset_sequence installation step
3. see the error

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot complete CU5 installation


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