1. Tables and Views for Financials
  2. XLA_MIGRATION_CLEANUP_GT

XLA_MIGRATION_CLEANUP_GT

This table temporarily stores relationships between parent setup objects and their child setup objects. Oracle Fusion Subledger Accounting uses this data for cleanup of extraneous setup data during migration.

Details

  • Schema: FUSION

  • Object owner: XLA

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

XLA_MIGRATION_CLEANUP_GT_PK

RELATIONSHIP_CODE, CHILD_KEY_1, CHILD_KEY_2, CHILD_KEY_3, CHILD_KEY_4, CHILD_KEY_5, CHILD_KEY_6, CHILD_KEY_7, CHILD_KEY_8, CHILD_KEY_9, CHILD_KEY_10, CHILD_KEY_11, CHILD_KEY_12, CHILD_KEY_13, CHILD_KEY_14, CHILD_KEY_15, CHILD_KEY_16, CHILD_KEY_17, CHILD_KEY_18, CHILD_KEY_19, CHILD_KEY_20

Columns

Name Datatype Length Not-null Comments
RELATIONSHIP_CODE VARCHAR2 30 Yes Parent and child set object relationship for which data is stored.
CHILD_KEY_1 VARCHAR2 240 Yes Alternative key value for the first segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_2 VARCHAR2 240 Yes Alternative key value for the second segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_3 VARCHAR2 240 Yes Alternative key value for the third segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_4 VARCHAR2 40 Yes Alternative key value for the fourth segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_5 VARCHAR2 40 Yes Alternative key value for the fifth segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_6 VARCHAR2 40 Yes Alternative key value for the sixth segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_7 VARCHAR2 40 Yes Alternative key value for the seventh segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_8 VARCHAR2 40 Yes Alternative key value for the eighth segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_9 VARCHAR2 40 Yes Alternative key value for the ninth segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_10 VARCHAR2 40 Yes Alternative key value for the tenth segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_11 VARCHAR2 40 Yes Alternative key value for the eleventh segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_12 VARCHAR2 40 Yes Alternative key value for the twelfth segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_13 VARCHAR2 40 Yes Alternative key value for the thirteenth segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_14 VARCHAR2 40 Yes Alternative key value for the fourteenth segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_15 VARCHAR2 40 Yes Alternative key value for the fifteenth segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_16 VARCHAR2 40 Yes Alternative key value for the sixteenth segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_17 VARCHAR2 40 Yes Alternative key value for the seventeenth segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_18 VARCHAR2 40 Yes Alternative key value for the eighteenth segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_19 VARCHAR2 40 Yes Alternative key value for the nineteenth segment in the alternative key of the child object. Contains a single space if the value is null.
CHILD_KEY_20 VARCHAR2 40 Yes Alternative key value for the twentieth segment in the alternative key of the child object. Contains a single space if the value is null.
PARENT_KEY_1 VARCHAR2 240 Yes Alternative key value for the first segment in the alternative key of the parent object. Contains a single space if the value is null.
PARENT_KEY_2 VARCHAR2 240 Yes Alternative key value for the second segment in the alternative key of the parent object. Contains a single space if the value is null.
PARENT_KEY_3 VARCHAR2 240 Yes Alternative key value for the third segment in the alternative key of the parent object. Contains a single space if the value is null.
PARENT_KEY_4 VARCHAR2 40 Yes Alternative key value for the fourth segment in the alternative key of the parent object. Contains a single space if the value is null.
PARENT_KEY_5 VARCHAR2 40 Yes Alternative key value for the fifth segment in the alternative key of the parent object. Contains a single space if the value is null.
PARENT_KEY_6 VARCHAR2 40 Yes Alternative key value for the sixth segment in the alternative key of the parent object. Contains a single space if the value is null.
PARENT_KEY_7 VARCHAR2 40 Yes Alternative key value for the seventh segment in the alternative key of the parent object. Contains a single space if the value is null.
PARENT_KEY_8 VARCHAR2 40 Yes Alternative key value for the eighth segment in the alternative key of the parent object. Contains a single space if the value is null.
PARENT_KEY_9 VARCHAR2 40 Yes Alternative key value for the ninth segment in the alternative key of the parent object. Contains a single space if the value is null.
PARENT_KEY_10 VARCHAR2 40 Yes Alternative key value for the tenth segment in the alternative key of the parent object. Contains a single space if the value is null.

Indexes

Index Uniqueness Columns
XLA_MIGRATION_CLEANUP_GT_N1 Non Unique RELATIONSHIP_CODE, PARENT_KEY_1, PARENT_KEY_2, PARENT_KEY_3, PARENT_KEY_4, PARENT_KEY_5, PARENT_KEY_6, PARENT_KEY_7, PARENT_KEY_8, PARENT_KEY_9, PARENT_KEY_10
XLA_MIGRATION_CLEANUP_GT_U1 Unique RELATIONSHIP_CODE, CHILD_KEY_1, CHILD_KEY_2, CHILD_KEY_3, CHILD_KEY_4, CHILD_KEY_5, CHILD_KEY_6, CHILD_KEY_7, CHILD_KEY_8, CHILD_KEY_9, CHILD_KEY_10, CHILD_KEY_11, CHILD_KEY_12, CHILD_KEY_13, CHILD_KEY_14, CHILD_KEY_15, CHILD_KEY_16, CHILD_KEY_17, CHILD_KEY_18, CHILD_KEY_19, CHILD_KEY_20