My Oracle Support Banner

"ORA-01000: Maximum Open Cursors Exceeded" Error Received Processing MultiBuyPromoCre Message (Doc ID 2296394.1)

Last updated on MAY 27, 2020

Applies to:

Oracle Retail Store Inventory Management - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

When Store Inventory Management (SIM) tries to process a MultiBuyPromoCre message from Oracle Retail Price Management (RPM) containing more than 4,000 items, user receives error "ORA-01000: maximum open cursors exceeded" :


Steps to Recreate:

1. Create a large price change in RPM containing at least 4,000 items.
2. Wait for SIM to process the outbound MultiBuyPromoCre message.
3. Check SIM logs as the message is processed and observe the above mentioned error.

Changes

 

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.