26451679 PSPENNLN:PSP: Create And Update Encumbrance Lines Error ORA-01086: Savepoint 'CEL_ARCHIVE' (Doc ID 2290542.1)

Last updated on JULY 26, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Encumbrance

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 invali
d

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
.

Action: Please contact your support representative.

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 7913
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 7913
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 7913
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PAY_ARCHIVE", line 1118
ORA-06512: at line 3
.
.
l_curr_conv_rate -1
2017/07/16 17:19:39p_element_type_id : 680p_encumbrance_date : 865p_dr_cr_flag : Dp_encumbrance_amount : 754000p_enc_line_type : Up_schedule_line_id : 16003p_org_schedule_id : p_assignment_id : 24285p_person_id : 40835p_gl_project_flag : Gl_output_curr_code : LBPl_input_curr_code : LBPl_conversion_type : Corporatel_curr_conv_rate : -1
2017/07/16 17:19:39p_encumbrance_amount converted : -754000
2017/07/16 17:19:39Multi: p_encumbrance_amount after conversion: -754000
2017/07/16 17:19:39Multi.Ins.Enc Converted Amount -754000
2017/07/16 17:19:39Multi.Ins.Enc Orig 754000
ORA-06512: at "APPS.PSP_ENC_CREATE_LINES", line 4081
ORA-06512: at "APPS.PSP_ENC_CREATE_LINES", line 8649
ORA-06512: at "APPS.PSP_ENC_CREATE_LINES", line 7501

The program failed with the following error :
ORA-01400: cannot insert NULL into ("PSP"."PSP_ENC_LINES"."ENCUMBRANCE_DATE") in Package PSP_ENC_CREATE_LINES Procedure INSERT_ENC_LINES_FROM_ARRAYS
User-Defined Exception in Package PSP_ENC_UPDATE_LINES Procedure VERIFY_CHANGES
User-Defined Exception in Package PSP_ENC_CREATE_LINES Procedure CEL_ARCHIVE: SQLCODE: 1 SQLERRM: User-Defined Exception
2017/07/16 17:19:40 Leaving CEL_ARCHIVE (payroll_action_id: 9071 chunk_number: 1)
2017/07/16 17:19:40 Entering CEL_DEINIT payroll_action_id: 9071
2017/07/16 17:19:40 Create and Update Encumbrance process has errors. Please review the Run Results Report for more details.
2017/07/16 17:19:40 Before submitting Encumbrance Run Results Report
+-----------------------------------------------------------------------

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. 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