OEOEORD-Book Order With Many Lines Errors With ORA-4030: Out Of Process Memory (Doc ID 736280.1)

Last updated on MARCH 21, 2017

Applies to:

Oracle Order Management - Version 11.5.1 to 12.1 [Release 11.5.1 to 12.1]
Information in this document applies to any platform.

FORM:OEXOEORD.FMB - Sales Orders


Symptoms

When attempting to book a sales order with more than 3000 order lines, the following error occurs:
"The Booking Activity has errored out, please contact system administrator".
When Tools > Workflow Status menu is selected for the order , it shows following errors,

ERROR
Failed Activity : Book
ORA-01001: invalid cursor ORA-06512: at APPS.OE_STANDARD_WF: ORA-06512 at APPS.OE_BOOK_WF
ORA-4030: out of process memory when trying to allocate 248 bytes
(Typecheck,qsmksol : qsmg_alloc_sol)

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. OM Superuser > Enter Order
2. Press <Book>
3. Tools > Workflow Status

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