My Oracle Support Banner

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

Last updated on APRIL 30, 2018

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

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