AFTER PATCH 21033080, PAE PROCESS ERRORS:ORA-01841: (FULL) YEAR MUST BE BETWEEN
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.
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.
HR_6881_HRPROC_ORA_ERR SQLERRMC ORA-01841
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)
Patch 21033080 applied.
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