Create Distribution Lines Fails With SQLERRMC ORA-01086: Savepoint 'A' Never Established (Doc ID 459329.1)

Last updated on JULY 31, 2023

Applies to:

Symptoms

Create Distribution Lines fails with:

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01086: savepoint 'A' never established

SQL_NO 1608
TABLE_NAME pyarpchk
APP-PAY-06881: Error ORA-01086: savepoint 'A' never established
has occurred in table pyarpchk at location 1608

Cause: an oracle error has occurred. The failure was reported on table pyarpchk at location 1608 with the error text ORA-01086: savepoint 'A' never established

Action: Please contact your support representative.

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PAY_ARCHIVE", line 1114
ORA-06512: at line 3

SQL_NO 1609
TABLE_NAME pay_archive.process_chunk
APP-PAY-06881: Error ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PAY_ARCHIVE", line 1114
ORA-06512: at line 3
has occurred in table pay_archive.process_chunk at location 1609

Cause: an oracle error has occurred. The failure was reported on table pay_archive.process_chunk at location 1609 with the error text ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PAY_ARCHIVE", line 1114
ORA-06512: at line 3


Action: Please contact your support representative.

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
The program failed with the following error(s) :
FATAL ERROR : The total scheduled % on 01-AUG-07 for Assignment &ASSIGNMENT_ID is greater than 100
(ASSIGNMENT_NUMBER=130126) (EMPLOYEE_NUMBER=33593)
0 batches successfully distributed
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

Cause

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