Hi All

Here's a funkie overstepping the mark again!! I need to set the first employee number in prod to be 1010 before conversion - I do not have an experienced HRMS techie on site - can anyone PLEASE tell me how to do this??

I'm guessing it's not as easy as setting the next value column in per_number_generation_controls??

Thanks kindly

Hello Joules, hope you are well as I am, thank you for asking...

First off, do I take it that in conversion you are retaining legacy employee numbers? If so, the emp number generation method needs to be (M)anual. I think by default it's Auto, but you can change from Auto to Manual via the form - the other way round is slightly trickier, but let's not go there just yet.

If on the other hand it's already automatic, and you are allowing for emp numbers to be generated for legacy data then to set the number sequence:

UPDATE PER_NUMBER_GENERATION_CONTROLS
SET next_value = <some number or function of the current number>
WHERE TYPE = 'EMP' -- for emps of course
AND BUSINESS_GROUP_ID = <whatever>;
--
COMMIT;

Caution: You MUST ensure that the highest value for EMPLOYEE_NUMBER on PER_ALL_PEOPLE_F is not higher than what you're intending to set NEXT_VALUE to.

Hope this helps

A 'safer' way of doing this is via fastformula...please check Doc ID: Note:279458.1 on Metalink: 'How To Implement Custom Person Numbering Using FastFormula'
Regards,
Jairo

Where's your sense of adventure?

OK, fair cop!

*pokes tongue out at screen*

My 'sense of adventure' disappeared when I left Colin's Team...there is no back up here when something goes wrong and therefore 'killer scripts' are not allowed anymore...So now it's "do it by the book or you are not supported by Oracle"...

Jairo

Hey, I've only just seen this!!!

What a sweetie you are! Big kisses right at ya!!

I asked 15 - yes 15 people this question and only Brits knew the answer - oh yeah!! We kick butt over here I can tell you!