ORA-30036 Tablespace Error When Enhanced Re
(Doc ID 1932010.1)
Last updated on JUNE 11, 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
With worrying regularity we are getting the error "ORA-30036: unable to extend segment by 8 in undo tablespace 'APPS_UNDOTS1' " 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.
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 error is raise only for Enhanced Retropay - not for other payroll processes.
"ORA-30036: unable to extend segment by 8 in undo tablespace 'APPS_UNDOTS1' "
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"
The issue can be reproduced at will with the following steps:
1. Run the Dutch Enhanced Retropay process.
The issue has the following business impact:
The retropay process takes already long time to finish, but since we run it overnight or over the weekend we have to constantly check if the process went in error to restart it.
If the process goes in error several times, we have to lose a lot of time to complete the payroll cycle and for this reason the eBS environment will not be available for the end users to perform their data entry transactions.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!