My Oracle Support Banner

ORA-01000: "Maximum Open Cursors Exceeded" Error When Updating Extension Transaction Table S_LOY_TXN_X Attribute by LoyEngineBatch (Doc ID 2787180.1)

Last updated on JANUARY 26, 2022

Applies to:

Siebel Loyalty Engine - Version 15.0 [IP2015] to 21.9 [Release V15 to V17]
Information in this document applies to any platform.


If a Loyalty Promotion is configured with an Action to have a custom Transaction Attribute that maps to S_LOY_TXN_X table, DB session cursors are not closed when the process completed.

As a result depending on the number of Transactions being processed the LoyEngineBatch will fail with the following error:


Cursors are not being closed.



 A column from extension Table S_LOY_TXN_X has been mapped to LOY Engine Transaction and LOY Transaction Business Components


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.