My Oracle Support Banner

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.

Symptoms

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.

"ORA-30036: unable to extend segment by 8 in undo tablespace 'APPS_UNDOTS1' "
"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"



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.




STEPS
The issue can be reproduced at will with the following steps:

1. Run the Dutch Enhanced Retropay process.



Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.