Monday 22 January 2018

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.

How to Set 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

How to Set Custom Customer number Sequence in Oracle Apps r12

4 comments:

arif said...

Thanks and Regards. Oracle Apps R12 & Fusion Training Videos at affordable cost.
please check oracleappstechnical.com for details.

Anonymous said...

Nice blog, I really like what you write in this blog, I also have some relevant Information about Best HR Training In Hyderabad | Hr training institute in Hyderabad! if you want more information.
Oracle Fusion HCM Online Training

Anonymous said...

Thanks for Sharing This informative article. It would be helpful if you write a all.
Oracle Fusion HCM Online Training

shaik shah said...

Excellent blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
Oracle Fusion HCM Online Training

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *