Cursors Are Getting Released (Doc ID 1526538.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

On : 8.1.1.5 [21229] version, Territory Management

Fail to update 2000 or more records in Territory Management >
  Territories Administration > drill down on the Territory > Geography

ERROR

  ========================screen1
  
  We detect an error which may have occurred for one or more of the following
  reasons:
  
  An error has occurred preparing a Sql statement. Please continue or ask
  your systems Administrator to check your application configuration if the
  problem persists.(SBL-DBC-00108)
  
  ========================screen2
  
  [1] An error has occurred preparing a Sql Statement.
  
  Please continue or ask your systems Administrator to check your application
  configuration if the problem persists.(SBL-DBC-00108)
  [2] ORA-00604: error occurred at recursive SQL level 1
  ORA-01000: maximum open cursors exceeded
  ORA-01000: maximum open cursors exceeded
  
  ==============================


Reproducible Steps

1. Login a SADMIN, In Territory Management > Territories Administration >
  drill down on the Territory > Geography, Menu > Record Count = 2070.
  The Effective Start Date, Value = 9/25/2012 8:35:15 PM for all 2070 records.
  
2. Select all records by clicking on Edit > Select All in top of the screen.


3. Click on Edit > Change Records, choose Field =Effective Start Date, Value = 10/5/2012 8:35:15 PM (update this field to today + 1, given today is 10/4, today + 1 is 10/5, and I keep the same time 8:35:15 PM).

4. Click on OK to update. It fails with the errors.

 


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