My Oracle Support Banner

Hz_cust_accounts_s Is Approaching Max_value For Sequence. (Doc ID 551643.1)

Last updated on JULY 13, 2020

Applies to:

Oracle Trading Community - Version 11.5.10 to 11.5.10.3 [Release 11.5]
Information in this document applies to any platform.

Symptoms

On 11.5.10 in Production:
When reviewing HZ_CUST_ACCOUNTS_S, the following possible problem occurs.

ERROR
Ther sequence qill reach the mazimum size.

EXPECTED BEHAVIOR
Expect to have the sequence with higher value

STEPS
The issue can be reproduced at will with the following steps:
1. Go to SQL*Plus as APPS user
2. Run
select SEQUENCE_NAME, LAST_NUMBER,MAX_VALUE from dba_sequences
where sequence_name = 'HZ_CUST_ACCOUNTS_S';

Changes

 

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


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