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 OCTOBER 05, 2021
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