Create Settlement Batches ESS Job Ends In Error (Doc ID 2716630.1)

Last updated on APRIL 25, 2023

Applies to:

Symptoms

On : 11.13.20.07.0 version, Customer Payments (Receipts)

When attempting to create settlement batch the ESS job ends in error in production

ERROR
-----------------------
by.fundsCapture.transactions.ess.program.FCBatchProgram.executeImpl::JBO-IBY:::IBY_40000: IBY-825214L_exception SQL : IO Error: Socket read timed out.
iby.fundsCapture.transactions.ess.program.FCBatchProgram.executeImpl::oracle.apps.fnd.applcore.messages.ApplcoreException: JBO-IBY:::IBY_40000: IBY-825214L'exception SQL : IO Error: Socket read timed out.
iby.fundsCapture.transactions.ess.program.FCBatchProgram.executeImpl::Error code is IBY:::IBY_40000
iby.fundsCapture.transactions.ess.program.FCBatchProgram.executeImpl::In exception block of executeimpl
iby.fundsCapture.transactions.ess.program.FCBatchProgram.executeImpl::error true invalidfcpp falsebatchcreated falsenobatchesfalse
iby.fundsCapture.transactions.ess.program.FCBatchProgram.executeImpl::Final return status in executeImpl is 3
iby.fundsCapture.transactions.ess.program.FCBatchProgram.execute::oracle.as.scheduler.ExecutionBizErrorException: oracle.apps.fnd.applcore.messages.ApplcoreException: JBO-IBY:::IBY_10002: IBY-825224
iby.fundsCapture.transactions.ess.program.FCBatchProgram._term::releasing session objects

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run create settlement batch
2. Verify failure in log file

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create settlement batch

Cause

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