ERN Delete Process Bug Due To No Primary National Insurance Number (Doc ID 2293240.1)

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.

Symptoms

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.

ERROR
-----------------------
ORA-01407: cannot update ("SYSADM"."PS_SJT_PERSON"."NATIONAL_ID") to NULL
.
.
SQL error in Exec. (2,280) HR_PERSON_ERN_DELETE.ERNDelete.OnExecute
Name:DeleteTable
PCPC:14935 Statement:186

STEPS
-----------------------
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

Cause

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