Thursday, May 13, 2010

Issue: Not Able to create an employee with Employee Record '0'

Issue: Some times in Peoplesoft system we can not create a new employee with Employee Record zero. In 'Organizational Relationships' page 'Empl Rcd' will be defaulted to '1'. Even if we try to overwrite it with '0' it will through the error: 'This Empl_rcd is already in use for this person in PER_ORG_ASGN. Choose a diffrent EMPL_RCD.' as in the following screen shot.
This happens because there is a row in database with Employee ID :'NEW'. Peoplsoft system shoould not allow to create an Employee with Empl ID 'NEW', because of some descripancies in the system Empl ID 'NEW' will be created.
Even in the same instance this issue can not be replicated. We can not use 'ID Delete' component to delete this Empl ID, because we can not get emplid in prompt table.

We can not find Empl ID 'NEW' in ID Dlelete Component. It is because Empl ID 'NEW' is not there in 'PERS_SRCH_ALL' View and Undelying Tables.

Resolution: Insert dummy row with Empl ID with 'NEW' into all the underlying records of the View 'PERS_SRCH_ALL' which are 'PS_PERSON', 'PS_PERS_DATA_EFFDT' and 'PS_NAMES'. Then proceed to run ID Delete process with emplid 'NEW'.

No comments:

Post a Comment