ERN Delete Process Bug Due To No Primary National Insurance Number
Last updated on AUGUST 02, 2017
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On : 9.2 version, Other
The ERN delete process fails if the employee has no primary national insurance number.
The Application Engine HR_EERCD_DEL fails while trying to update the SJT_PERSON security record with the following error in the underlying Application Package.
the following error occurs.
ORA-01407: cannot update ("SYSADM"."PS_SJT_PERSON"."NATIONAL_ID") to NULL
SQL error in Exec. (2,280) HR_PERSON_ERN_DELETE.ERNDelete.OnExecute
The issue can be reproduced at will with the following steps:
1. Find an employee that fits the following criteria
- No national insurance number
- Employee record 0
- Not future
2. Navigate to the ERN Delete Process, and submit a batch process to delete the selected employee /ERN. The process will error as shown.
Setup HCM > System Administration > Database Processes > ERN Delete Process > ERN Delete Process
3. The Application Engine log file is as follows showing the SQL update error
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms