How to Set Custom Customer number Sequence in Oracle Apps r12

How to Set custom Customer number Sequence in Oracle Apps r12

In this post , We will be discuss about , how to Set Customer number Sequence as per Your Requirement in Oracle Apps r12. When we do create the customers in oracle apps , system automatically create the customer number for that customer in oracle apps. Customer number is the unique number assigned for each customer. We can also set our custom sequence for the customer number in oracle apps. Here below i will share the details steps to set the custom Customer number Sequence in Oracle Apps r12.

Steps to Set Custom Customer number Sequence in Oracle Apps r12

To Set Customer number Sequence as per the Your Requirement , do the
following:

STEP:

1) select HZ_ACCOUNT_NUM_S.nextval from dual; -- compare this value with the
customer number in your table to ensure there is no overlap

2) drop sequence ar.hz_account_num_s;

3) Run the following to recreate, replacing the start value with what you
retrieved in step 1.

CREATE SEQUENCE ar.HZ_ACCOUNT_NUM_S
INCREMENT BY 1
START WITH <<VALUE FROM STEP 1>>
NOMAXVALUE
NOMINVALUE
NOCYCLE
NOCACHE
NOORDER
/
4) select hz_account_num_s.nextval from dual; -- verify the start value is
correct

5) test in the application and verify the data in the table