My Oracle Support Banner

SBL-DBC-00111 And ORA-01400 Errors While Creating a Search Category (Doc ID 1992232.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Advanced Search - Version [IP2013] and later
Information in this document applies to any platform.


On : [IP2013] version, System Admin

When attempting to create a search category, the following error occurs.


[1] An error occurred writing a record
Please continue or ask your systems administrator to check your application configuration if the problem persist (SBL-DBC-00111)
[2] ORA-01400: cannot inset NULL into ("xxxxx"."S_SRCH_DRILLDN"."SEQ_NUM").

Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Siebel Search has been configured: Siebel and Oracle Secure Enterprise Search (OSES or SES) are integrated.
2. Navigate Administration - Search > Search Definition, select a search definition. i.e.: Call Center Definition and go to its 'Search Definition Categories' tab.
3. Create a new search category filling in the columns values: Name, Seq Num, BC Name and View Name.
4. When stepping off the record or trying to save it, the SBL-DBC-00111 and ORA-01400 errors are displayed; hence new search category cannot be saved.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.