Cannot Read Oracle Sequence - Errors SBL-DBC-00111 and ORA-02289: sequence does not exist (Doc ID 1398892.1)

Last updated on FEBRUARY 27, 2017

Applies to:

Siebel CRM - Version 8.0.0.7 SIA [20426] and later
Information in this document applies to any platform.
""Checked for relevance on 05-Jan-2015""

Symptoms

We are trying to use an Oracle Sequence to set a BC field. The Sequence is specified in the 'Oracle Sequence Object' field property.

When we create a new record in the BC we get the following errors:
- - -
[1] An error has occurred writing to a record.
Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00111)
[2] ORA-06550: line 146, column 77:
PL/SQL: ORA-02289: sequence does not exist
ORA-06550: line 126, column 2:
PL/SQL: SQL Statement ignored
- - -

The Sequence object works correctly (as confirmed by issuing SELECT statements directly on the database).

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