EAP: Automatic Reconciliation Process Goes To No Success At BNK_RECON_PY.625-ONE.STEP01 For Specific AR Payments

(Doc ID 2267499.1)

Last updated on MAY 18, 2017

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue Statement:
BNK_RECON Automatic Bank Reconciliation process fails with error

Steps:
  1: Run Automatic Bank Reconciliation process
  
Error:
 -- 16:00:28.488 Process 13007852 ABENDED at Step BNK_RECON_PY.625-ONE.Step01 (Action SQL) -- RC = 1427
ROLLBACK
/
-- 16:00:28.522 SQL Error: ORA-01427: single-row subquery returns more than one row

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