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

Last updated on AUGUST 17, 2017

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.

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