"ORA-01400" "SBL-DAT-00235" errors while releasing products using Business Service
Last updated on MARCH 02, 2017
Applies to:Siebel Enterprise Integration Manager - Version 7.8.2  to 188.8.131.52  [Release V7]
Oracle Solaris on SPARC (64-bit)
Database: Oracle 184.108.40.206
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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms