My Oracle Support Banner

Error SBL-DAT-00376: There Is No Field For Denormalized Column 'XXXX' From Table Definition 'S_YYY' After IRR Performed With Schema Changes (Doc ID 2723439.1)

Last updated on AUGUST 19, 2022

Applies to:

Siebel CRM - Version 17.0 [IP2017] and later
Information in this document applies to any platform.


After running the IRR migration with schema change, the following error occurs in SIT environment application while trying to add a new literature inside a catalog:

Error displaying in the application UI as well as application Object Manager log file.

SBL-DAT-00376: There is no field for denormalized column '<?>' from table definition '<?>' defined in business component '<?>'.


  1. Made some schema changes into the Table in DR environment.
  2. Execute an IRR Migration to SIT environment.


 Performed some schema change in to Siebel table in Dev environment and migrate the same to the SIT environment via IRR migration.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.