Patch Issues

Some of the Patches fail with below issue

ERROR
The sequence HZ_PARTY_NUMBER_S in the database is defined as:
MINVALUE = 1 MAXVALUE = 99999999999999999999 INCREMENT BY = 1
CYCLE = NO ORDER = NO CACHE = 20

which should be defined as:
MINVALUE = 1 MAXVALUE = 2147483647 INCREMENT BY = 1
CYCLE = NO ORDER = NO CACHE = 20

Alter the sequence with :

ALTER SEQUENCE AR.HZ_PARTY_NUMBER_S MAXVALUE 2147483647

AD Worker error:
The following ORACLE error:

ORA-04009: MAXVALUE cannot be made to be less than the current value


occurred while executing the SQL statement:

ALTER SEQUENCE AR.HZ_PARTY_NUMBER_S MAXVALUE 2147483647

AD Worker error:
Unable to compare or correct sequences
because of the error above

Cause

The issue is caused because the patch is comparing the current sequence with the standard definition

The arhz.odf file has


....
2%START_OF_SEQUENCE
# Sequence Name
HZ_PARTY_NUMBER_S
# Application Id, Sequence Id
222 5907
# Sequence Sequence
520
# Min Value, Max Value, Increment By
1 2147483647 1
# Cycle Flag, Order Flag
N N
# Cache Size, Start Value
20 1000
2%END_OF_SEQUENCE
...
..

and the sequence was changed to :

The sequence HZ_PARTY_NUMBER_S in the database is defined as:
MINVALUE = 1 MAXVALUE = 99999999999999999999 INCREMENT BY = 1
CYCLE = NO ORDER = NO CACHE = 20


Solution

To implement the solution, please execute the following workaround:

1. Make a copy of file upatchnumber.drv. File located where the patch was downloaded:
Patch Dir/patchname
2. Update the upatchnumber.drv  from

# file-version-parsed ar patch/115/odf arhz.odf 115.227
exec ar patch/115/odf arhz.odf odf &phase=seq
checkfile:ar:patch/115/odf:arhz.odf:seq_sequences mode=sequences

to

# file-version-parsed ar patch/115/odf arhz.odf 115.227
# exec ar patch/115/odf arhz.odf odf &phase=seq
checkfile:ar:patch/115/odf:arhz.odf:seq_sequences mode=sequences


3. Re-apply the patch from the top