My Oracle Support Banner

Does the Primavera P6 Application Accepts Gaps in Sequence on 'LAST_NUMBER' Value in SYS.DBA_SEQUENCES? (Doc ID 2787974.1)

Last updated on MARCH 22, 2022

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.16.0 and later
Information in this document applies to any platform.

Goal

The LAST_NUMBER value of the ADMUSER sequence does not get reset during the data import process; therefore, it does not match the LAST_NUMBER value in PC_PROCESS_STAT_SEQ sequence from the source database.

Should LAST_NUMBER from sys.dba_sequences WHERE SEQUENCE_OWNER = 'ADMUSER' be updated in the target database (after database refresh or backup restore from one Oracle database instance to another) to match the source database?

 

Solution

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
Goal
Solution


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