FND_SYNONYMS_B

The primary table for storing Fusion Synonyms.

Details

  • Schema: SEARCH

  • Object owner: FND

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

FND_SYNONYMS_B_PK

SYNONYM_ID

Columns

Name Datatype Length Precision Not-null Comments
SYNONYM_ID NUMBER 18 Yes SYNONYM_ID - Unique internal id for primary key.
SYNONYM_CODE VARCHAR2 30 Yes SYNONYM_CODE - A Unique code for the synonyms.
SYNONYM_TYPE VARCHAR2 30 Yes SYNONYM_TYPE: The use the synonym will be given.
CONTEXT_CODE VARCHAR2 30 CONTEXT_CODE - Optional code for striping synonyms.
OBJECT_TYPE VARCHAR2 30 OBJECT_TYPE - a sub classification of CONTEXT_CODE for striping synonyms.
ALL_COMBINATIONS_FLAG VARCHAR2 1 Yes ALL_COMBINATIONS_FLAG - Are all combinations of word and synonym to be considered (Y/N)?
ENABLED_FLAG VARCHAR2 1 Yes ENABLED_FLAG - Are these synonyms enabled (Y/N).
MODULE_ID VARCHAR2 32 Yes Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
SEED_DATA_SOURCE VARCHAR2 512 Seed data file from which the row originates.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table Foreign Table Foreign Key Column
fnd_synonyms_tl fnd_synonyms_b SYNONYM_ID

Indexes

Index Uniqueness Tablespace Columns
FND_SYNONYMS_B_U1 Unique Default SYNONYM_ID, ORA_SEED_SET1
FND_SYNONYMS_B_U11 Unique Default SYNONYM_ID, ORA_SEED_SET2
FND_SYNONYMS_B_U2 Unique Default SYNONYM_CODE, ORA_SEED_SET1
FND_SYNONYMS_B_U21 Unique Default SYNONYM_CODE, ORA_SEED_SET2