My Oracle Support Banner

MCO Number Reset Itself After Database Upgrade From 12c To 19c (Doc ID 2817328.1)

Last updated on NOVEMBER 16, 2021

Applies to:

Oracle Agile Product Collaboration - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

Found that the MCO number reset itself after the database upgrade from 12c to 19c. The starting number way back in 2004 was RFC10001. The number of characters was updated from 5 to 6 in 2018.  The numeration was moving forward as expected.  Upgraded the database in 2020 and the users reported after the upgrade that the first MCO number was RFC000002. The expected number after the upgrade would have been RFC112522. 

 

The issue can be reproduced at will with the following steps:

Before 19c database upgrade: 2004

1. Logon to Java Client as admin user (Navigate to AutoNumbers & update)

2. Admin Tab > Data Settings > AutoNumbers

3. RFC Number

4. Prefix RFC, Character Set 0123456789, Number of Characters 5, Starting

Number 00001, Next Number RFC0002

 

The number of characters was updated from 5 to 6 characters: 2018

1. Logon to Java Client as admin user (Navigate to AutoNumbers & update)

2. Admin Tab > Data Settings > AutoNumbers

3. RFC Number

4. Prefix RFC, Character Set 0123456789, Number of Characters 6, Starting

Number 000001, Next Number RFC000002

 

After 19c database upgrade: 2020

1. Logon to Java Client as admin user (Navigate to AutoNumbers configuration to check settings after 19c database upgrade)

2. Admin Tab > Data Settings > AutoNumbers

3. RFC Number

4. Prefix RFC, Character Set 0123456789, Number of Characters 6, Starting

Number 000001, Next Number RFC000002

5. Search for the RFC*

6. The current next number is now RFC000002  ---> Expecting the next number to be RFC112522

 

Changes

Database upgrade from 12c to 19c

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.