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 JULY 12, 2016

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

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