ERPstuff - Oracle EBS Community

Posted: **Sun Apr 20, 2008 4:23 am**

Hi ,

Is it Possible to Generate employee no automatically with some Prefix for Example "EMP-100"

Thanks and Regards,
Prabhu.D

Posted: **Sun Apr 20, 2008 9:50 pm**

you can do it by 2 way

1- fast formula + funcation + sequence
PERSON_GENERATION_NUMBER\

FUCATION USEING CONCAT EMP -!! SEQUECE +1
2- custom pll + funcation + sequence

khalid seif
Satyam computer
HRMS CONSULTANT

Posted: **Tue Apr 22, 2008 12:49 pm**

Hi,
Can you plz explain the 2 ways. (khalid seif).

Expecting your feedback.
Thanks & regards,
MOHAN.

ERPstuff - Oracle EBS Community

Employee No Automatic Generation with some Prefix

Employee No Automatic Generation with some Prefix