R12:CE: Error "ORA-01427: single-row subquery returns more than one row" When Attempting to Make a Bank Account Transfer (Doc ID 1995108.1)

Last updated on OCTOBER 23, 2015

Applies to:

Oracle Cash Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Bank Account Transfer

When attempting to make a bank account transfer,
the following error occurs.

Exception occured when building payments. Payment creation will be aborted and no payments will
be committed for payment request 21334
SQLCODE: -1427
SQLERRM: ORA-01427: single-row subquery returns more than one row
Build program error: Exception occured when attempting to create payments from the documents
payable of the provided payment service request.

The issue can be reproduced at will with the following steps:

1. Responsibility: Cash Manager
2. Path: Bank Transfer
3. Try to make a bank transfer

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