ORA-30036 Tablespace Error When Enhanced Retro Pay
(Doc ID 1932010.1)
Last updated on SEPTEMBER 07, 2018
Applies to:Oracle HRMS (Netherlands) - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Netherlands Payroll
While performing a regular Enhanced Retropay run during our payroll cycle. Before the last payroll cycle, we have asked our DBAs to extend the table space from 60Gb to almost 90Gb, but the error happened again. To solve the issue, we have to retry several times the errored retropay process before we can get rid of all the errors, but this delays a lot our payroll cycle.
SQLERRMC ORA-01405: fetched column value is NULL
APP-PAY-06881: Error ORA-01405: fetched column value is NULL
has occurred in table get_ee_overlap_date at location 1572
Cause: an oracle error has occurred. The failure was reported on table get_ee_overlap_date at location 1572 with the error text ORA-01405: fetched column value is NULL
Action: Please contact your support representative.
ETNAME Flat Rate Taxation
APP-PAY-51119: Error was encountered when processing Element Type Flat Rate Taxation
APP-PAY-51120: Error was encountered when processing formula NL_CALC_FLAT_RATE_TAX
FORMULA_ERROR_TEXT ORA-30036 occurred at line 200 of formula NL_CALC_FLAT_RATE_T
Cause: Whilst executing PL/SQL, an Oracle error occurred. The line numbe
r and line position, are given where available"
Recently we have been able to replicate the ORA-30036 error with only 180 assignment in retropay that needed a recalculation only from last year, so we believe the issue is not caused by the mass of assignment that have to be reprocessed. Moreover, we can see that the error is raised almost always during the execution of Dutch Legislation fast formulae related to Taxation (see attachment). Most of the time, the error in the concurrent logs points to the Flat Rate Taxation formula (NL_CALC_FLAT_RATE_TAX), but what puzzles us the most is that we are not using such kind of taxation, so we do not expect that formula to be executed at all.
The issue can be reproduced at will with the following steps:
1. Run the Dutch Enhanced Retropay process.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document