PAY_ASSIGNMENT_LINK_USAGES_S Sequence Is Displayed in the Script Output Having LAST_NUMBER Value Greater than DEV_MAX Value After Running ADCHECKSEQMAX.SQL Script (Doc ID 3027646.1)

Last updated on JUNE 17, 2024

Applies to:

Symptoms

After running ADCHECKSEQMAX.sql script it has been observed the PAY_ASSIGNMENT_LINK_USAGES_S sequence is returned in the script output having LAST_NUMBER value greater than DEV_MAX value:

NOTE: LAST_NUMBER value can be any other number above DEV_MAX value. The above is a simple example of the script output.


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

1. Run the script using the following command:

Reference: Doc ID 2989870.1 Managing Sequences in Oracle E-Business Suite Release 12.2 > Section 3: Monitor Sequence Status.

2. Review script output and observe that LAST_NUMBER value is greater than DEV_MAX value.

Changes

Cause

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