ARZCAR_RECEIPT - Automatic Receipts Creation Program Finished With Error: Sql-02112

(Doc ID 466088.1)

Last updated on JUNE 05, 2018

Applies to:

Oracle Receivables - Version: 11.5.10.2 to 11.5.10.3 - Release: 11.5.10 to 11.5.10
Information in this document applies to any platform.
*** Checked for relevance on 09-Oct-2011 ***
ARZCAR_RECEIPT - Automatic Receipts Creation Program

Symptoms

When attempting to generate automatic receipts by executing concurrent ARZCAR_RECEIPT:: Automatic Receipts Creation Program
the following error occurs:

ERROR
arzira: Fetching SEL_INV cursor
arzira: -2112 SQL-02112: SELECT..INTO returns too many rows

arzarc: Error from arzira
main: Error in arzarc_Approve_Receipts

Changes

Upgrade to 11.5.10.2

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