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 22.214.171.124 [Release 11.5]
Information in this document applies to any platform.
On 11.5.10 in Production:
When reviewing HZ_CUST_ACCOUNTS_S, the following possible problem occurs.
Ther sequence qill reach the mazimum size.
Expect to have the sequence with higher value
The issue can be reproduced at will with the following steps:
1. Go to SQL*Plus as APPS user
select SEQUENCE_NAME, LAST_NUMBER,MAX_VALUE from dba_sequences
where sequence_name = 'HZ_CUST_ACCOUNTS_S';
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