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.

Symptoms

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

Steps:

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

Changes

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

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