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 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.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.