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;

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.

Your Title Goes Here

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.

Your Title Goes Here

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.

Your Title Goes Here

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.

Oracle Receivables (AR) Set the Party Number Next Number

Your Title Goes Here

Your Title Goes Here

Your Title Goes Here

Let's set up a call?

We'll get in touch

Let's set up a call

We'll get in touch

Let's get on a call!

We'll get in touch

Subscribe To Keep Up To Date

You have Successfully Subscribed!