NACHA Errors: ORA-01693: max # extents (505) reached in lob segment HR.SYS_LOB0000705 (Doc ID 351123.1)

Last updated on OCTOBER 23, 2014

Applies to:

Oracle HRMS (US) - Version 11.5.10.2 and later
Information in this document applies to any platform.
ConcurrentProgram:NACHA - NACHA

***Checked for relevance on 23-OCT-2014***

Symptoms

Problem Statement:

NACHA Process fails with the following error:


SQLERRMC ORA-01693: max # extents (505) reached in lob segment HR.SYS_LOB0000705
396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1

SQL_NO 1617
TABLE_NAME pay_core_files.write_to_file
APP-PAY-06881: Error ORA-01693: max # extents (505) reached in lob segment
HR.SYS_LOB0000705396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1
has occurred in table pay_core_files.write_to_file at location 1617

Cause: an oracle error has occurred. The failure was reported on table
pay_core_files.write_to_file at location 1617 with the error text ORA-01693: max # extents (505)
reached in lob segment HR.SYS_LOB0000705396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1
.

Action: Please contact your support representative.

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01693: max # extents (505) reached in lob segment HR.SYS_LOB0000705
396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1

SQL_NO 1617
TABLE_NAME pay_core_files.write_to_file
APP-PAY-06881: Error ORA-01693: max # extents (505) reached in lob segment
HR.SYS_LOB0000705396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1
has occurred in table pay_core_files.write_to_file at location 1617

Cause: an oracle error has occurred. The failure was reported on table
pay_core_files.write_to_file at location 1617 with the error text ORA-01693: max # extents (505)
reached in lob segment HR.SYS_LOB0000705396C00006$$
ORA-06512: at "SYS.DBMS_LOB", line 775
ORA-06512: at "APPS.PAY_CORE_FILES", line 276
ORA-06512: at line 1


.








.

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