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 JULY 19, 2023
Applies to:
Siebel Loyalty Engine - Version 15.0 [IP2015] to 21.9 [Release V15 to V17]Information in this document applies to any platform.
Symptoms
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.
Changes
A column from extension Table S_LOY_TXN_X has been mapped to LOY Engine Transaction and LOY Transaction Business Components
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |