AFTER PATCH 21033080, PAE PROCESS ERRORS:ORA-01841: (FULL) YEAR MUST BE BETWEEN
(Doc ID 2080812.1)
Last updated on FEBRUARY 06, 2018
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!