Create Customer Statement Process Ends in Error: ORA-01427 (Doc ID 2220803.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Reports

Create Customer Statement Process ends in error

Create Customer Statement Process completing with warning and Create Customer Statements: Subprocess is ERROING look at the below ERROR codes
arxsgp: Gather stats is set to Yes, gathering stats2
arxsgp: Error in main.
4294965869 ORA-01427: single-row subquery returns more than one row
 
arxsgp(errexit): Delete Rows from interim table - AR_STATEMENT_HEADERS
arxsgp(errexit): Delete Rows from interim table - AR_STATEMENT_LINE_CLUSTERS
arxsgp(errexit): Deleted work successfully
4294965869 ORA-01427: single-row subquery returns more than one row
 

ERROR
-----------------------
arxsgp: Error in main. 4294965869 ORA-01427: single-row subquery returns more than one row


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Scheduled Processes > run Create Customer Statement Process


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot send statements to customers.

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