ORA-30036 Tablespace Error When Enhanced Retro Pay
(Doc ID 1932010.1)
Last updated on JANUARY 04, 2024
Applies to:
Oracle HRMS (Netherlands) - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 version, Netherlands Payroll
While performing a regular Enhanced Retropay run.
Before the last payroll cycle, extended the table space from 60Gb to almost 90Gb. To solve the issue, need to retry several times the errored retropay process before can get rid of all the errors, but this delays a lot our payroll cycle.
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_TAX
Cause: Whilst executing PL/SQL, an Oracle error occurred. The line number and line position, are given where available"
Recently 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 |