Dbchck errors - Mismatch between Physical and Dictionary schema (Doc ID 1332810.1)

Last updated on MAY 09, 2013

Applies to:

Siebel Automotive - Version 8.1.1.4 [21225] and later
Information in this document applies to any platform.
Checked for relevant date : 09/05/2013

Symptoms


Customer Environment:   8.1.1.4 [21225] version, System Admin

When attempting to use tables in mappings or applying schema changes mismatch issue notified.

ERROR
-----------------------
Error: Dictionary for S_ACT_EMP different from physical schema1    Dictionary different from physical schema for index

Note: Both dictionary columns are modified to SYS_NC00030$ and SYS_NC00031$ when querying DBA_IND_COLUMNS at database level.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run  DBchck utility, Dbchck log contains failed errors

dbchck: S_ACT_EMP checking completed: 2 checks failed.
dbchck: S_ADDR_ORG checking completed: 1 check failed.
dbchck: S_ASSET_WRNTY checking completed: 1 check failed.
dbchck: S_CONTACT checking completed: 1 check failed.
dbchck: S_EVT_ACT checking completed: 7 checks failed.
dbchck: S_ORG_EXT checking completed: 1 check failed.
dbchck: S_ORG_PROD checking completed: 1 check failed.
dbchck: S_PAY_METHOD checking completed: 1 check failed.
dbchck: S_PAY_PLAN checking completed: 2 checks failed.
dbchck: S_PROD_INT checking completed: 2 checks failed.
dbchck: S_PRSP_CONTACT checking completed: 1 check failed.
dbchck: S_SRC_PAYMENT checking completed: 2 checks failed.
dbchck: Checking completed: 22 checks failed in 12 tables.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms