My Oracle Support Banner

Many EBS applications forms error with APP-AR-96575: SET OF BOOKS NOT FOUND or System Options errors with ORA-01422: Exact Fetch Returns More Than Requested Number of Rows (Doc ID 1955493.1)

Last updated on MAY 15, 2018

Applies to:

Oracle Order Management - Version 12.0 to 12.2 [Release 12.0 to 12.2]
Oracle Receivables - Version 12 to 12.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.0.6 version, 

You are attempting to go to Transaction booking in Order Management, or open many other EBS Application forms and receive the following error:

APP-AR-96575: SET OF BOOKS NOT FOUND.

Steps to Reproduce:
Responsibility:  Order Management
Navigation:  Transaction Booking
Unable to open any sales order

Responsibility:  Receivables
Navigation:  Setup > System Options

ORA-01422: Exact Fetch Returns More Than Requested Number of Rows

Changes

Possible Recent upgrade to release 12.

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!


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