Last updated on JANUARY 10, 2017
Applies to:Oracle HRMS (UK) - Version 12.1.2 and later
Information in this document applies to any platform.
On : 12.1.2 version, UK Payroll
<Patch 18426236>:R12.PAY.B - EYU ERRORS: ORA-20001: ERRORS FOUND WHILE ARCHIVING DATA,ORA-06512: AT has been applied.
While testing the EYU, the following wore found:
- The two records that are left, as completed, on the process, are the two that are expected, as they have had the earlier year updates.My concern is that the process shows over 15,000 records as being complete one minute and then it goes down to the 2. To my mind currently all Oracle processes show the number of records that have been processed even if there are no results being pulled through. For example the Prepayments process will show all employee's on the Payroll as being completed even if there is no payment being brought through, this is the same for the Expenses Payroll which shows the full 15,000 as being completed, but only 1-2,000 have actually been paid. Neither of these processes change the number of records completed after it has completed. Therefore, if you are saying that this is the way it is meant to work now, on the EYU (the records processed disappear), it is totally different from the way that the system works for all the other processes.
-Have had the patch applied to the other organization that we support the Payroll for. I am not aware how many other EYU changes were already in this Payroll, so I did add one. I then ran the EYU process. It behaved in exactly the same way as it did for SSE. It ran through the 4,000 + records that are on the organisation and then went straight back to 25 as having been processed. The one record that I was expecting was in the list of 25. As before, I will upload the screen shots of the process at varies stages.
All the records to be present
The issue can be reproduced at will with the following steps:
1. Apply <Patch 18426236>:R12.PAY.B - EYU ERRORS: ORA-20001: ERRORS FOUND WHILE ARCHIVING DATA,ORA-06512: AT
2. Run EYU
The issue has the following business impact:
Unable to trust the EYU
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms