My Oracle Support Banner

Customer Statement Error: ORA-01422: exact fetch returns more than requested number of rows (Doc ID 2471492.1)

Last updated on DECEMBER 04, 2018

Applies to:

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

Symptoms

On : 11.13.18.05.0 version, Reports

Customer statement of accounts end in error



Execution of customer statement of accounts results in error for one customer


Other customer do not seem to be having this issue.

 

ERROR
-----------------------
arxsgp: Error in main.
4294965874 ORA-01422: exact fetch returns more than requested number of rows
ORA-
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
4294965874 ORA-01422: exact fetch returns more than requested number of rows
ORA-





STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run Create Customer Statements

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

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.