"ORA-01000: Maximum Open Cursors Exceeded" Error Received Processing MultiBuyPromoCre Message
Last updated on JANUARY 08, 2018
Applies to:Oracle Retail Store Inventory Management - Version 14.1 and later
Information in this document applies to any platform.
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.
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