AFTER PATCH 21033080, PAE PROCESS ERRORS:ORA-01841: (FULL) YEAR MUST BE BETWEEN (Doc ID 2080812.1)

Last updated on JUNE 20, 2017

Applies to:

Oracle HRMS (UK) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, UK Payroll
 
GB Pensions Automatic Enrolment Process errors with HR_6881_HRPROC_ORA_ERR SQLERRMC ORA-01841, Test
 
Following the application of RUP8 and other recommended patches to a test environment (designated EBSSP3), the GB Pensions Automatic Enrolment Process has errored on running in 'Validate' mode.
The assignments affected appear to be restricted to members of the final salary pension scheme although since the process stopped after 20 assignments (due to too many errors), it is not clear whether this is actually the case. These individuals are all long-serving employees so will have early person and assignment ids.
This process has been run on a copy of the production environment to which patches have been applied. When the equivalent run was carried out on the production environment, it completed normally.

ERROR
-----------------------
HR_6881_HRPROC_ORA_ERR SQLERRMC ORA-01841


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply RUP8 and other mandatory patches.
2. Run "GB Pensions Automatic Enrollment Process" in validate mode
3. Process errors: the assignments affected appear to be restricted to members of the final salary pension scheme although since the process stopped after 20 assignments (due to too many errors)

Changes

 Patch 21033080 applied.

 

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