R12:Mask External Bank Account Data Error: Oracle Error 17008

(Doc ID 2035024.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle Payments - Version 12.2 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

IBY's Mask External Bank Account Data' concurrent program runs fine in standalone request submissions.

Running it in a REQUEST SET suddenly results in the following connection error after a series of "security" patches got applied:

Oracle error 17008: java.sql.SQLRecoverableException: Closed Connection has been detected in FND_CONCURRENT.SET_INTERIM_STATUS.Oracle error 17008:
java.sql.SQLRecoverableException: Closed Connection has been detected in CpContext.requestEnd.

The request set that gets kicked off:
Mask Sensitive Data Request Set (Report Set)

sub request:
Mask External Bank Account Data

+---------------------------------------------------------------------------+
Payments: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

IBY_EXT_BANKACCT_MASKING module: Mask External Bank Account Data
+---------------------------------------------------------------------------+

Current system time is 20-MAR-2013 20:43:35

+---------------------------------------------------------------------------+

Oracle error 17008: java.sql.SQLRecoverableException: Closed Connection has been detected in FND_CONCURRENT.SET_INTERIM_STATUS.Oracle error 17008: java.sql.SQLRecoverableException: Closed Connection has been detected in CpContext.requestEnd.+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

 

 

 

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