Oracle Receivables (AR) Set the Party Number Next Number

Mar 7, 2020 | AR, Oracle

The database sequence that handles the creation of customer numbers is defined in HZ_PARTY_NUMBER_S.
select max(party_number) from ar.hz_parties;
Then using the number returned above, define the sequence to start with a higher value.

If for example the above returns 10001, then you can do the following to ensure the sequence will not create overlapping Party numbers:
DROP SEQUENCE AR.HZ_PARTY_NUMBER_S;10002 INCREMENT BY 1 MAXVALUE 999999 CACHE 20;

Let's set up a call?

Send over your name and email and we can coordinate to do call over coffee!

We'll get in touch

Let's set up a call

Send over your name and email and we can coordinate to do call over coffee!

We'll get in touch

Let's get on a call!

Send over your name and email and we can coordinate to do call over coffee!

We'll get in touch

Subscribe To Keep Up To Date

Subscribe To Keep Up To Date

Join our mailing list to receive the latest news and updates.

You have Successfully Subscribed!

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close