"ORA-01400" "SBL-DAT-00235" errors while releasing products using Business Service
(Doc ID 531959.1)
Last updated on JULY 21, 2020
Applies to:Siebel Enterprise Integration Manager - Version 7.8.2  to 18.104.22.168  [Release V7]
Oracle Solaris on SPARC (64-bit)
Database: Oracle 22.214.171.124
Application Server OS: Sun Solaris 9
Database Server OS: Sun Solaris 9
This document was previously published as Siebel SR 38-2804154185. Previously Handled in SR 38-2327888101.
***Checked for relevance on 28-Jul-2014***
From Siebel Application version 7.8, EIM cannot be used to populate the tables S_VOD, S_VOD_VER, S_ISS_OBJ_ATTR as there are no EIM mappings for them.
Initially EIM is used to import simple products, then Business Service Simulator is used to execute the following BS to release products:
Some of the products are not being released. In order to debug, Enable thick client detail tracing when executing BS, there are 2 types of errors. Here are the errors:
Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00111);  ORA-01400: cannot insert NULL into ("SIEBEL"."S_VOD"."OBJECT_NUM") ; Data will be skipped; Post EAM Upgrade of Product Records:
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