My Oracle Support Banner

Attempting To Export Lines Via Order Organizer Errors With ORA-01000: Maximum Open Cursors Exceeded After Release 12.2.9 Upgrade (Doc ID 2733720.1)

Last updated on MARCH 09, 2022

Applies to:

Oracle Order Management - Version 12.2.9 and later
Information in this document applies to any platform.


Attempting to export order lines from the Order Organizer errors with the following:


APP-FND-00706: Routine FDFADF: Detected a data error.
Cause: audfrm failed due to ORA-01000: maximum open cursors exceeded

The issue can be reproduced at will with the following steps:

1. Responsibility: Order Management Super User
2. Navigate: Orders Workbench, Order Organizer > query
3. Click Continue after message of more than 100 records retrieved.
4. Receive error.


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

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