Penserver: After Rup9 PenServer Periodic Changes Interface - Service History Went in Error (Doc ID 2208503.1)

Last updated on NOVEMBER 29, 2016

Applies to:

Oracle HRMS (UK) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After R12.HR_PF.B.delta.9 (Patch 21980909 ) applied, Penserver Interface Process -Service History is ending with the following:

ERROR

ORA-01086: savepoint 'CUR_TRANSACTION' never established in this session or is invalid
ORA-06512: at "APPS.BEN_EXT_PERSON", line 4650
ORA-20001: An error has occurred in a user defined function at line 25 of the formula PQP_GB_PENSERVER_SERVICE_HISTORY_CRITERIA. The error text associated with the function call is: 'PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions{10}: User-Defined Exception'.
Please correct the problem with the function call, or contact your system administrator or support representative.


STEPS
The issue can be reproduced at will with the following steps:
1. Run PenServer Interface Process-Service History

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