How to set the customer number in Oracle apps / Customer Number Sequence updation in AR

Note: Refer Doc ID 265315.1)

Switch to the Application Developer responsibility,
In the Navigator window select Application, then Database, and finally Sequence.

To automatically assign a unique number to every new customer, check the Automatic Customer Numbering box. Do not check this box if you want to manually assign customer numbers. Oracle Applications system administrator or developer can specify the initial number to be used for Automatic Customer Numbering.

Switch to the Application Developer responsibility.

In the Navigator window select Application, then Database, and finally Sequence.

In the Name field of the Sequences window, query for HZ_ACCOUNT_NUM_S.

In the Start Value field of the Sequences window, enter the initial number to be used for Automatic Customer Numbering.

You were previously entering customer numbers manually. Now you want to generate the number automatically but you want to specify the value the sequence should start from. How can this be done? The database sequence that handles the creation of customer numbers is defined in HZ_ACCOUNT_NUM_S.

Care should be taken to ensure that you do not define a number which will cause duplicate customer numbers to exist in your system. you can run the following to identify the highest number currently in use within your system: Select max(account_number) from hz_cust_accounts_all; Then using the number returned above, define the sequence to start with a higher value. If for example the above returns 20000, then you can do the following to ensure the sequence will not create overlapping account numbers:

DROP SEQUENCE AR.HZ_ACCOUNT_NUM_S;

CREATE SEQUENCE AR.HZ_ACCOUNT_NUM_S START WITH 20000 INCREMENT BY 1 MAXVALUE 999999 CACHE 20;