FND_CSM_TBL_BACKUP
This table is used to determine the backup table for each base table used for CSM import. This table is used for internal purposes and contains only seeded data. This is used internally by CSM framework and not for external customer use.
Details
-
Schema: CSM
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
FND_CSM_TBL_BACKUP_PK |
BASE_TABLE_NAME |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| BASE_TABLE_NAME | VARCHAR2 | 30 | Yes | Base Table Name |
| BACKUP_TABLE_NAME | VARCHAR2 | 30 | Yes | Backup Table Name |
| ENABLED | VARCHAR2 | 1 | Enabled | |
| 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. | |
| BACKUP_MODE | VARCHAR2 | 32 | BACKUP_MODE | |
| 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. |
| MODULE_NAME | VARCHAR2 | 100 | Yes | Module Name |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_CSM_TBL_BACKUP_U1 | Unique | Default | BASE_TABLE_NAME, ORA_SEED_SET1 |
| FND_CSM_TBL_BACKUP_U11 | Unique | Default | BASE_TABLE_NAME, ORA_SEED_SET2 |