8.1.1.9 - Cursor Error When Running Territory Alignment (Doc ID 1923874.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Territory Management - Version 8.1.1.10 [23021] and later
Information in this document applies to any platform.

Symptoms

Siebel Version: 8.1.1.10 [23021] SIA

ACTUAL OR UNEXPECTED BEHAVIOR

In 8.1.1.9, the 'Activate Rules' for Major Alignment fails with the error.

Error


GenericLog GenericError 1 0000001251f10cd8:0 2013-07-25 18:31:43 Message:
Error: An ODBC error occurred,
Additional Message: Function: cachestmt_execute; ODBC operation: SQLExecute

SQLError Statement 0 0000001251f10cd8:0 2013-07-25 18:31:43 SQL Statement:
update SIEBEL.S_ACCNT_POSTN c

  set (c.ACCNT_LOC,

c.ACCNT_NAME,

c.ACCNT_TYPE_CD,

c.CLIENT_FLG,

c.FACILITY_FLG,

c.INVSTR_FLG,

c.ORG_REF_CUST_FLG,

c.SRV_PROVDR_FLG)

=

(select LOC,

NAME,

ACCNT_TYPE_CD,

CLIENT_FLG,

FACILITY_FLG,

INVSTR_FLG,

REFERENCE_CUST_FLG,

SRV_PROVDR_FLG

from SIEBEL.S_ORG_EXT p

where p.ROW_ID = c.OU_EXT_ID)


where (ROW_ID = ?) and exists (select 'x' from SIEBEL.S_ORG_EXT p where
p.ROW_ID = c.OU_EXT_ID)

SQLError Bind Variables 1 0000001251f10cd8:0 2013-07-25 18:31:43 01:1-68-1N1


DBCLog DBCLogError 1 0000001251f10cd8:0 2013-07-25 18:31:43 [tp][ODBC Oracle
driver][Oracle]ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded

8.1.1.7 works correctly without max cursor error.

Repro Steps

1.Set up data required: 1 hierarchy, 1 division, 2o positions in the
division, 1 territory.

2. create 109 accounts, just populate account record's Name field.

3. Create a major alignment in Territory Management > Alignments Administration:

Direct Account rule, Rules >Accounts, add 109 accounts for territory
Position rule, Rules > Positions, add 20 positions for the territory

4. Run Alignment, finished successfully, In Alignments Administration > Results > Accounts,
record count = 2180

5. Activate Rules, stopped at Status = 'Request Submitted', check the logs,
AsgnBatch log has the cursor error.


Cause

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