XLAPEXRPT Subledger Period Close Exception Report Fails With Error: ORA-01427 single-row subquery returns more than one row (Doc ID 1340480.1)

Last updated on JULY 07, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
Report: XLAPEXRPT.RDF - Subledger Period Close Exception Report


Symptoms

Subledger Period Close Exceptions Report (XLAPEXRPT) ends up with 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