My Oracle Support Banner

ARDLGP: Dunning Letter Generate Errors with ORA-01427 (Doc ID 561275.1)

Last updated on MAY 01, 2019

Applies to:

Oracle Receivables - Version 11.5.10.2 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
EXECUTABLE:ARDLGP - Dunning Letter Generate

Symptoms

On 11.5.10.2 in Production:

When trying to send dunning letters to customers, the Dunning Letter Generate program runs on error - ORA-01427

ERROR

sequenced_letter: ORA-01427: single-row subquery returns more than one row

STEPS
AR - Print Documents - Dunning letters - Single request - Dunning Letter Generate

BUSINESS IMPACT
Due to this issue, users cannot generate dunning letters

.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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