ORA-30036 Tablespace Error When Enhanced Re (Doc ID 1932010.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle HRMS (Netherlands) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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.

ERROR
-----------------------
"ORA-30036: unable to extend segment by 8 in undo tablespace 'APPS_UNDOTS1' "

and

"HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01405: fetched column value is NULL

SQL_NO 1572
TABLE_NAME get_ee_overlap_date
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.

HR_51119_HRPROC_ERR_OCC_ON_ET
ETNAME Flat Rate Taxation
APP-PAY-51119: Error was encountered when processing Element Type Flat Rate Taxation
HR_51120_HRPROC_ERR_OCC_ON_FML
FMLANAME NL_CALC_FLAT_RATE_TAX
APP-PAY-51120: Error was encountered when processing formula NL_CALC_FLAT_RATE_TAX
HR_6867_HRPROC_FMLA_ORA_ERR
ORACLE_ERROR_TEXT
FORMULA_ERROR_TEXT ORA-30036 occurred at line 200 of formula NL_CALC_FLAT_RATE_T
AX

Cause: Whilst executing PL/SQL, an Oracle error occurred. The line numbe
r and line position, are given where available"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the Dutch Enhanced Retropay process.

BUSINESS IMPACT
-----------------------
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.

Cause

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