ACA_ATTACH_MIGRATE_LOG

This table is used to store the logs of attachment migration done by the ESS Job.

Details

  • Schema: FUSION

  • Object owner: ACA

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ACA_ATTACH_MIGRATE_LOG_PK

MIGRATE_LOG_ID

Columns

Name Datatype Length Precision Not-null Comments
MIGRATE_LOG_ID NUMBER 18 Yes Primary key of table ACA_ATTACHM_MIGRATE_LOG.
MIGRATION_TYPE VARCHAR2 30 Yes MIGRATION_TYPE 1. REVISION_TO_VERSION
PK1_VALUE NUMBER 18 PK1_VALUE stores the Primary key value of the business entity.
PK2_VALUE NUMBER 18 PK2_VALUE stores the Primary key value of the business entity.
PK3_VALUE NUMBER 18 PK3_VALUE stores the Primary key value of the business entity.
MIGRATION_STATUS VARCHAR2 1 Yes Status of migration. S - Success E - Error
JOB_ID NUMBER 18 Yes Stores the ID of the ESS job which performed the attachment migration.
MESSAGE VARCHAR2 1024 Migration message. Stores error message in case of failure.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
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.

Indexes

Index Uniqueness Tablespace Columns
ACA_ATTACH_MIGRATE_LOG_N1 Non Unique Default PK1_VALUE, PK2_VALUE, PK3_VALUE, MIGRATION_STATUS, MIGRATION_TYPE
ACA_ATTACH_MIGRATE_LOG_U1 Unique Default MIGRATE_LOG_ID