PSP: Create And Update Encumbrance Lines Erros With ORA-06512 APPS.PSP_ENC_CREATE_LINES

(Doc ID 2422631.1)

Last updated on JULY 13, 2018

Applies to:

Oracle Labor Distribution - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to run PSP: Create and Update Encumbrance Lines the following error occurs.

Error

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01086: savepoint 'A' never established in this session or is invalid

SQL_NO 1608
TABLE_NAME pyarpchk
APP-PAY-06881: Error ORA-01086: savepoint 'A' never established in this session or is invalid
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 in this session or is invalid

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01086: savepoint 'CEL_ARCHIVE' never established in this session or
is invalid
ORA-06512: at "APPS.PSP_ENC_CREATE_LINES", line 7726
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PAY_ARCHIVE", line 1118
ORA-06512: at line 3

SQL_NO 1609
TABLE_NAME pay_archive.process_chunk
APP-PAY-06881: Error ORA-01086: savepoint 'CEL_ARCHIVE' never established in this session or is invalid
ORA-06512: at "APPS.PSP_ENC_CREATE_LINES", line 7726
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PAY_ARCHIVE", line 1118
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-01086: savepoint 'CEL_ARCHIVE' never established in this session or is invalid
ORA-06512: at "APPS.PSP_ENC_CREATE_LINES", line 7726
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PAY_ARCHIVE", line 1118
ORA-06512: at line 3

The second error is as follows:


Project: xxxxx, Task: xxx, Award: xxxxx, Expenditure Organization: xxxxx and Expenditure Type: xxxx is invalid between 24-DEC-18 and 06-JAN-19 as it has ended on 23-DEC-18.
ORA-06512: at "APPS.PSP_ENC_CREATE_LINES", line 2185
ORA-06512: at "APPS.PSP_ENC_CREATE_LINES", line 3294

70.00025: CREATE_LINES
2018/07/05 14:40:26 Leaving CREATE_LINES
ORA-06512: at "APPS.PSP_ENC_CREATE_LINES", line 7314



Steps to Reproduce

The issue can be reproduced at will with the following steps:
1. Go into the responsibility:LD superUser
2. Run PSP: Create and Update Encumbrance Lines



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