Hi, I need a sequence for emp_number with 6 digits.(i.e.,000001,000002 like...) in HRMS module. That number should come when we saved enter and maintance form(HRMS- people) in apps fnont end form.Thanks in advancevikky

Interview Candidate
Sep 28th, 2006
2
1403

Showing Answers 1 - 2 of 2 Answers

surendra

Feb 11th, 2007

hi vikky.. how r u.. this is surendra u can try the following syntax to solve the problem create sequence s1 start with 000001 increment by 1;

sudheer

Aug 23rd, 2007

hi
u can do it by setting up the hrms setup in business group where u have an option of manual or automatic for employee no generation.if u employee no generation as automatic and start the sequence with the no which u'r saying may solve u'r problem....