Monday, 22 January 2018

How to Set Customer number Sequence as per Your Requirement in Oracle Apps r12


How to Set Customer number Sequence as per Your Requirement 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

0 comments:

Post a Comment