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.
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
Navigation: Setup > System Options
ORA-01422: Exact Fetch Returns More Than Requested Number of Rows
Possible Recent upgrade to release 12.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!