2Application Toolkit

Tables

ATK_ESSMETA_DS_ATTRS

This table stores the LOV Data Source Attributes.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ATK_ESSMETA_DS_ATTRS_PK

ATTR_ID

Columns

Name Datatype Length Precision Not-null Comments
ATTR_ID NUMBER 18 Yes COLUMN1
DATASOURCE_ID NUMBER 18 Yes DATASOURCE_ID
ID_ATTR_NAME VARCHAR2 30 Yes ID_ATTR_NAME
DISPLAY_ATTR_NAME VARCHAR2 30 Yes DISPLAY_ATTR_NAME
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_ESSMETA_DS_ATTRS atk_essmeta_ds_b DATASOURCE_ID

Indexes

Index Uniqueness Columns
ATK_ESSMETA_DS_ATTRS_U1 Unique ATTR_ID
ATK_ESSMETA_DS_ATTRS_U2 Unique DATASOURCE_ID, ATTR_ID
ATK_ESSMETA_DS_ATTRS_U3 Unique DATASOURCE_ID, ID_ATTR_NAME

ATK_ESSMETA_DS_B

This table stores the LOV Data Source Names.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ATK_ESSMETA_DS_B_PK

DATASOURCE_ID

Columns

Name Datatype Length Precision Not-null Comments
DATASOURCE_ID NUMBER 18 Yes DATASOURCE_ID
PRODUCT_SHORT_NAME VARCHAR2 10 Yes PRODUCT_SHORT_NAME
IS_VALUESET VARCHAR2 1 Yes IS_VALUESET
DATASOURCE_DEF_NAME VARCHAR2 2000 Yes DATASOURCE_DEF_NAME
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
atk_essmeta_ds_attrs atk_essmeta_ds_b DATASOURCE_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_ESSMETA_DS_B_U1 Unique Default DATASOURCE_ID

ATK_ESSMETA_DS_TL

This table stores the translated LOV Data Source Attributes.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ATK_ESSMETA_DS_TL_PK

DATASOURCE_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
DATASOURCE_ID NUMBER 18 Yes COLUMN1
USER_DATASOURCE_NAME VARCHAR2 240 Yes USER_DATASOURCE_NAME
DESCRIPTION VARCHAR2 2000 DESCRIPTION
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.

Indexes

Index Uniqueness Tablespace Columns
ATK_ESSMETA_DS_TL_PK Unique Default DATASOURCE_ID, LANGUAGE

ATK_FUSE_CARDS

atk_fuse_cards: this table stores the fuse cards information of fuse page.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_FUSE_CARDS_PK

FUSE_CARD_CODE

Columns

Name Datatype Length Precision Not-null Comments
FUSE_CARD_CODE VARCHAR2 100 Yes FUSE_CARD_CODE: unique code based on LBA Prefix.
CARD_ICON VARCHAR2 400 Yes CARD_ICON: path to ACR image to use for card display. Means image is supposed to be available in fusionapps/jlib/AdfAcrImagesPublicUi.jar
CARD_LOOKUP_TYPE VARCHAR2 30 Yes CARD_LOOKUP_TYPE: reference to FND_STANDARD_LOOKUP_TYPES.LOOKUP_TYPE based on the seeded lookup type for Card (VIEW_APPLICATION_ID = 0 and SET_ID = 0).
CARD_LOOKUP_CODE VARCHAR2 30 Yes CARD_LOOKUP_CODE: reference to FND_LOOKUPS.LOOKUP_CODE. Product teams to seed lookup code with meaning for the lookup type. The translated lookup meaning is shown for fuse card.
CARD_ENABLED VARCHAR2 1 Yes CARD_ENABLED : indicates if the card is enabled or not to show it to the user
CAN_BE_HIDDEN VARCHAR2 1 Yes CAN_BE_HIDDEN: Indicates whether this card can be hidden through customization or not
MODULE_ID VARCHAR2 32 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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
ATK_FUSE_CARDS_PK Unique Default FUSE_CARD_CODE
ATK_FUSE_CARDS_U1 Unique Default FUSE_CARD_CODE, CARD_ICON, CARD_LOOKUP_TYPE, CARD_LOOKUP_CODE, CARD_ENABLED, CAN_BE_HIDDEN

ATK_FUSE_CARDS_EXTN

atk_fuse_cards_extn:this table stores the admin customizations done to fuse cards information in atk_fuse_cards.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_FUSE_CARDS_EXTN_PK

FUSE_CARD_CODE

Columns

Name Datatype Length Precision Not-null Comments
FUSE_CARD_CODE VARCHAR2 100 Yes FUSE_CARD_CODE: unique code based on LBA Prefix.
CARD_LOOKUP_TYPE VARCHAR2 30 CARD_LOOKUP_TYPE: reference to FND_STANDARD_LOOKUP_TYPES.LOOKUP_TYPE based on the seeded lookup type for Card (VIEW_APPLICATION_ID = 0 and SET_ID = 0).
CARD_LOOKUP_CODE VARCHAR2 30 CARD_LOOKUP_CODE: reference to FND_LOOKUPS.LOOKUP_CODE. Product teams to seed lookup code with meaning for the lookup type. The translated lookup meaning is shown for fuse card.
CARD_ENABLED VARCHAR2 1 CARD_ENABLED : indicates if the card is enabled or not to show it to the user
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.
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.

Indexes

Index Uniqueness Tablespace Columns
ATK_FUSE_CARDS_EXTN_PK Unique Default FUSE_CARD_CODE
ATK_FUSE_CARDS_EXTN_U1 Unique Default FUSE_CARD_CODE, CARD_LOOKUP_TYPE, CARD_LOOKUP_CODE, CARD_ENABLED

ATK_FUSE_CARDS_SEQ

atk_fuse_cards_seq : this table contains the mappings between the fuse cards and categories.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_FUSE_CARDS_SEQ_PK

FUSE_CARD_CODE, FUSE_CATEGORY_CODE

Columns

Name Datatype Length Precision Not-null Comments
FUSE_CARD_CODE VARCHAR2 100 Yes FUSE_CARD_CODE: unique code based on LBA Prefix.
FUSE_CATEGORY_CODE VARCHAR2 30 Yes FUSE_CATEGORY_CODE: The category to which the card belongs to. Valid values are HCM and CRM.
CARD_SEQUENCE NUMBER 9 Yes CARD_SEQUENCE : this will be used for ordering of cards in UI
ENABLED VARCHAR2 1 Yes ENABLED : indicates if the card is enabled or not to show it for this category FUSE_CATEGORY_CODE. Valid values are Y and N.
MODULE_ID VARCHAR2 32 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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
ATK_FUSE_CARDS_SEQ_PK Unique Default FUSE_CARD_CODE, FUSE_CATEGORY_CODE
ATK_FUSE_CARDS_SEQ_U1 Unique Default FUSE_CARD_CODE, FUSE_CATEGORY_CODE, CARD_SEQUENCE, ENABLED

ATK_FUSE_CARDS_SEQ_EXTN

atk_fuse_cards_seq_extn : this table stores the admin customizations done to the data present in atk_fuse_cards_seq table.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_FUSE_CARDS_SEQ_EXTN_PK

FUSE_CARD_CODE, FUSE_CATEGORY_CODE

Columns

Name Datatype Length Precision Not-null Comments
FUSE_CARD_CODE VARCHAR2 100 Yes FUSE_CARD_CODE: unique code based on LBA Prefix.
FUSE_CATEGORY_CODE VARCHAR2 30 Yes FUSE_CATEGORY_CODE: The category to which the card belongs to. Valid values are HCM and CRM.
CARD_SEQUENCE NUMBER CARD_SEQUENCE : this will be used for ordering of cards in UI
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.
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.

Indexes

Index Uniqueness Tablespace Columns
ATK_FUSE_CARDS_SEQ_EXTN_PK Unique Default FUSE_CARD_CODE, FUSE_CATEGORY_CODE
ATK_FUSE_CARDS_SEQ_EXTN_U1 Unique Default FUSE_CARD_CODE, FUSE_CATEGORY_CODE, CARD_SEQUENCE

ATK_FUSE_THEMES

atk_fuse_themes : this table stores the list of thems for fuse page.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_FUSE_THEMES_PK

THEME_ID

Columns

Name Datatype Length Precision Not-null Comments
THEME_ID NUMBER 18 Yes Primary Key for the Theme identification
THEME_NAME VARCHAR2 280 Yes Name of the Theme such as Oracle White
THEME_TYPE VARCHAR2 210 Yes Theme Type such as UI or Icon Theme
IS_SELECTED VARCHAR2 120 Yes Default Value is Y while seeding for Oracle White, rest all are N.When user changes a Theme Value, then that becomes Y
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
ATK_FUSE_THEMES_PK Unique Default THEME_ID
ATK_FUSE_THEMES_U1 Unique Default THEME_NAME

ATK_FUSE_THEME_IMAGES

ATK_FUSE_THEME_IMAGES: This stores image type and actual image content of a particular fuse theme

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_SEED

Primary Key

Name Columns

ATK_FUSE_THEME_IMAGES_PK

THEME_ID, THEME_ATTR_NAME

Columns

Name Datatype Length Precision Not-null Comments
THEME_ID NUMBER 18 Yes THEME_ID
THEME_NAME VARCHAR2 280 Yes Contains Theme Name
THEME_ATTR_NAME VARCHAR2 1000 Yes Attribute Name. In this table it can onlyl be IMAGE or WATERMARK for now
IMAGE BLOB Actual image stored in this column
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.
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.

Indexes

Index Uniqueness Tablespace Columns
ATK_FUSE_THEME_IMAGES_PK Unique Default THEME_ID, THEME_ATTR_NAME
ATK_FUSE_THEME_IMAGES_U1 Unique Default THEME_NAME, THEME_ATTR_NAME

ATK_FUSE_THEME_PROPERTIES

atk_fuse_theme_properties : this table stores the meta data of each fuse theme.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_FUSE_THEME_PROPERTIES_PK

THEME_ID, THEME_ATTR_NAME

Columns

Name Datatype Length Precision Not-null Comments
THEME_ID NUMBER 18 Yes THEME_ID
THEME_NAME VARCHAR2 280 Yes Contains Theme Name
THEME_ATTR_NAME VARCHAR2 1000 Yes CSS Attribute name
DEFAULT_THEME_ATTR_VALUE VARCHAR2 1000 Yes Seeded Value for Various Theme properties
SITE_THEME_ATTR_VALUE VARCHAR2 1000 Values when user changes the properties, if NULL, then use Default Value, else use this Value in UI
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
ATK_FUSE_THEME_PROPERTIES_PK Unique Default THEME_ID, THEME_ATTR_NAME
ATK_FUSE_THEME_PROPERTIES_U1 Unique Default THEME_NAME, THEME_ATTR_NAME

ATK_HOMEPAGE_OBJECTS

atk_homepage_objects : this table stores the meta data of each fuse card.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_HOMEPAGE_OBJECTS_PK

OBJECT_CODE

Columns

Name Datatype Length Precision Not-null Comments
OBJECT_CODE VARCHAR2 100 Yes Object Code: unique code based on LBA Prefix.
FUSE_CARD_CODE VARCHAR2 100 Yes FUSE_CARD_CODE: reference to ATK_FUSE_CARDS.FUSE_CARD_CODE
IMAGE_PATH VARCHAR2 400 Image Path: path to ACR image to use for Icon display for tabs. Means image is supposed to be available in fusionapps/jlib/AdfAcrImagesPublicUi.jar
LABEL_LOOKUP_TYPE VARCHAR2 30 Yes LABEL_LOOKUP_TYPE: reference to FND_STANDARD_LOOKUP_TYPES.LOOKUP_TYPE based on the seeded lookup type for tab (VIEW_APPLICATION_ID = 0 and SET_ID = 0).
LABEL_LOOKUP_CODE VARCHAR2 30 Yes Label Lookup Code: reference to FND_LOOKUP_VALUES.LOOKUP_CODE . Product teams to seed lookup code with lookup type (VIEW_APPLICATION_ID = 0 and SET_ID = 0). The translated lookup meaning is shown for tabs in the ui.
TASKFLOW_ID VARCHAR2 400 Yes TaskFlow Id: The task flow for this object drilldown for object
TASKFLOW_INPUT_PARAMLIST VARCHAR2 400 Parameters list to pass in to the task flow. This is a semicolon delimited String of name value pairs. For example, "param1=value1;param2=value2"
FUSE_COMMON_OBJECT VARCHAR2 1 Yes FUSE_COMMON_OBJECT: resembles whether the task flow is a common task flow available in all containers. Set "N" if it is not a common task flow available in all containers Set "Y" if it is a common task flow available in all containers Defalut value is 'N'
REMOTE VARCHAR2 1 Yes Remote Flag: Indicates whether the TaskFlow in local or remote Set "N" if it is local task flow from jar included in home page app Set "Y" if it is remote task flow invocation against different app
WEBAPP_MODULE VARCHAR2 100 Yes Topology Module Key for the UI App that contains the task flow This is used for determining the end point. Reference to ASK_MODULES.MODULE_NAME
SECURITY_STRIPE VARCHAR2 10 Yes Indicates the security policy stripe for the owning application. Valid values are fscm, hcm, crm. Default Value is fscm
ENABLED VARCHAR2 1 Yes Enabled: indicates if the object is enabled or not to show it to the user
SEQUENCE NUMBER 9 Sequence: this will be used for icons ordering
CAN_BE_HIDDEN VARCHAR2 1 Yes CAN_BE_HIDDEN: Indicates whether this object can be hidden through customization or not
MODULE_ID VARCHAR2 32 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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
ATK_HOMEPAGE_OBJECTS_PK Unique Default OBJECT_CODE
ATK_HOMEPAGE_OBJECTS_U1 Unique Default OBJECT_CODE, FUSE_CARD_CODE, IMAGE_PATH, LABEL_LOOKUP_TYPE, LABEL_LOOKUP_CODE, TASKFLOW_ID, REMOTE, TASKFLOW_INPUT_PARAMLIST, WEBAPP_MODULE, SECURITY_STRIPE, ENABLED, SEQUENCE, FUSE_COMMON_OBJECT, CAN_BE_HIDDEN

ATK_HOMEPAGE_OBJECTS_EXTN

atk_homepage_objects_extn : this table stores the admin customizations done to the data present in atk_homepage_objects.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_HOMEPAGE_OBJECTS_EXTN_PK

OBJECT_CODE

Columns

Name Datatype Length Precision Not-null Comments
OBJECT_CODE VARCHAR2 100 Yes Object Code: unique code based on LBA Prefix.
LABEL_LOOKUP_TYPE VARCHAR2 30 LABEL_LOOKUP_TYPE: reference to FND_STANDARD_LOOKUP_TYPES.LOOKUP_TYPE based on the seeded lookup type for tab (VIEW_APPLICATION_ID = 0 and SET_ID = 0).
LABEL_LOOKUP_CODE VARCHAR2 30 Label Lookup Code: reference to FND_LOOKUP_VALUES.LOOKUP_CODE . Product teams to seed lookup code with lookup type (VIEW_APPLICATION_ID = 0 and SET_ID = 0). The translated lookup meaning is shown for tabs in the ui.
ENABLED VARCHAR2 1 Enabled: indicates if the object is enabled or not to show it to the user
SEQUENCE NUMBER Sequence: this will be used for icons ordering
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.
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.

Indexes

Index Uniqueness Tablespace Columns
ATK_HOMEPAGE_OBJECTS_EXT_PK Unique Default OBJECT_CODE
ATK_HOMEPAGE_OBJECTS_EXT_U1 Unique Default OBJECT_CODE, LABEL_LOOKUP_TYPE, LABEL_LOOKUP_CODE, ENABLED, SEQUENCE

ATK_HP_ANNOUNCEMENTS

This stores Help portal announcements.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ATK_HP_ANNOUNCEMENTS_PK

ANNOUNCEMENT_ID

Columns

Name Datatype Length Precision Not-null Comments
ANNOUNCEMENT_ID NUMBER 18 Yes ID of the announcement.
CATEGORY_CODE VARCHAR2 20 Yes indicates the category to which the announcement belongs.
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.
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.
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.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
SUBJECT VARCHAR2 400 Yes Subject of the announcement.
START_DATE TIMESTAMP Yes indicates the date from when the announcement is active.
EXPIRE_DATE TIMESTAMP indicates the expiry date of the announcement.
DESCRIPTION CLOB Description of the announcement.
EXPIRY_DAYS_FLAG VARCHAR2 1 Flag to determine to show expiry days or expire date.
IMAGE_URL VARCHAR2 1024 IMAGE_URL
IMAGE_FILE BLOB IMAGE_FILE
VIDEO_URL VARCHAR2 1024 VIDEO_URL
CATEGORY_NAME VARCHAR2 1024 CATEGORY_NAME
MESSAGE_TYPE VARCHAR2 64 MESSAGE_TYPE
IMAGE_NAME VARCHAR2 1024 IMAGE_NAME
CROPPED_IMAGE_FILE BLOB CROPPED_IMAGE_FILE

Indexes

Index Uniqueness Tablespace Columns
ATK_HP_ANNOUNCEMENTS_N1 Non Unique Default CATEGORY_CODE
ATK_HP_ANNOUNCEMENTS_N2 Non Unique Default EXPIRE_DATE
ATK_HP_ANNOUNCEMENTS_N4 Non Unique Default START_DATE, EXPIRE_DATE
ATK_HP_ANNOUNCEMENTS_U1 Unique Default ANNOUNCEMENT_ID

ATK_HP_FEEDBACK

This stores Help portal feedback notes.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ATK_HP_FEEDBACK_PK

FEEDBACK_ID

Columns

Name Datatype Length Precision Not-null Comments
FEEDBACK_ID NUMBER 18 Yes ID of the feedback.
FEEDBACK_TYPE VARCHAR2 1 Yes Type of Feedback
FEEDBACK_NOTES VARCHAR2 4000 Yes Notes in the Feedback provided
FA_EXPERIENCE VARCHAR2 1 Experience with Fusion Applications
FULL_NAME VARCHAR2 80 Full Name of the Feedback Submitter
EMAIL_ID VARCHAR2 80 Email Id of the Submitter
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.
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.
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.
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
ATK_HP_FEEDBACK_PK Unique Default FEEDBACK_ID

ATK_KRH_CONFIG

The Configuration/Setup Table, which stores company details

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_CONFIG_PK

CONFIG_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id
LOGO_FILE_NAME VARCHAR2 255 CUSTOM_FILE_NAME
CONFIG_ID NUMBER 18 Yes Configuration Identifier.
TECH_LIBRARY_URL VARCHAR2 2000 This is the URL to the Apps Technology Library.
SITEMAP_HIERARCHY_TYPE VARCHAR2 4 Specifies the hierarchy that is displayed on the Site Map. This hiearchy must contain all topics so that external crawlers can find them via the site map.
DISCUSSION_FORUM_ENABLED VARCHAR2 1 Yes DISCUSSION_FORUM_ENABLED
ANNOUNCEMENT_ENABLED VARCHAR2 1 Yes ANNOUNCEMENT_ENABLED
CUSTOMER_FORUM_ENABLED VARCHAR2 1 Yes CUSTOMER_FORUM_ENABLED
ORACLE_UNIV_ENABLED VARCHAR2 1 Yes ORACLE_UNIV_ENABLED
HELP_ENABLED VARCHAR2 1 Yes HELP_ENABLED
PRIVACY_STMT_URL VARCHAR2 2000 The Privacy Statement URL
INCLUDE_UPK VARCHAR2 1 This flag indicates if the UOK Link should be displayed in the Page or not
DEFAULT_CONTENT_LOCATION VARCHAR2 2000 The Directory where the Custom Contents can be uploaded from.
URL VARCHAR2 2000 The UPK URL
REMOTE_HELP_PORTAL_FLAG VARCHAR2 1 Yes This flag indicates where the help portal resides. If set to Yes, the usage is through the central, hosted environment accessed remotely over the internet. If set to No, indicates the usage of local installation at customer site.
REMOTE_USER_RATING_FLAG VARCHAR2 1 Yes This flag indicates if user ratings are stored centrally in hosted help portal or locally at customer site. Yes value for this flag is applicable only when REMOTE_HELP_PORTAL_FLAG is set to No at customer site. If REMOTE_HELP_PORTAL_FLAG is set to Yes, then this flag must be set to No.
UPK_WEBSERVER_AGENT VARCHAR2 2000 UPK_WEBSERVER_AGENT
UPK_ALL_DEMO_URL VARCHAR2 2000 UPK_ALL_DEMO_URL
LOGO BLOB LOGO
SECURE_CUSTOM_HELP VARCHAR2 1 Yes Enable data security on help topics. (Y/N)
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created 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.
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.
ORACLE_SUPPORT_ENABLED VARCHAR2 1 Yes ORACLE_SUPPORT_ENABLED
CUSTOMER_FORUM_URL VARCHAR2 2000 Customer Forum URL
ORACLE_UNIVERSITY_URL VARCHAR2 2000 Oracle University URL
ORACLE_SUPPORT_URL VARCHAR2 2000 Oracle Support URL
HOME_BCKGRD_IMAGE BLOB This is the background image that gets displayed on help landing page.
HOME_BCKGRD_IMAGE_NAME VARCHAR2 255 This is the name of the background image that gets displayed on help landing page.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
atk_krh_config_tl atk_krh_config CONFIG_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_CONFIG_PK Unique Default CONFIG_ID

ATK_KRH_CONFIG_TL

The translatable table from ATK_KRH_CONFIG

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_CONFIG_TL_PK

CONFIG_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id
CONFIG_ID NUMBER 18 Yes COLUMN1
COMPANY_NAME VARCHAR2 2000 COMPANY_NAME
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created 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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_KRH_CONFIG_TL atk_krh_config CONFIG_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_CONFIG_TL_PK Unique Default CONFIG_ID, LANGUAGE

ATK_KRH_DF_BPM_MAPPING

This table defines the Mapping between the HelpPortal Topic Levels to the Discussion Forum Category and Forum Id.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ATK_KRH_DF_BPM_MAPPING_PK

MAPPING_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant enterprise Id
MAPPING_ID NUMBER 18 Yes MAPPING_ID
BPM_NAME VARCHAR2 2000 Yes This column stores the TopicId.
BPM_ID NUMBER 18 Yes This is just used for compatibility purpose.Default value is always 99.
CATEGORY_FORUM_ID NUMBER 18 Yes Contains the Category and/or Forum Id created for the Topics in Discussion Server.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.

Indexes

Index Uniqueness Tablespace Columns Status
ATK_KRH_DF_BPM_MAPPING_U1 Unique Default MAPPING_ID
ATK_KRH_DF_BPM_MAPPING_U2 Unique Default ENTERPRISE_ID, BPM_NAME, BPM_ID, CATEGORY_FORUM_ID Obsolete
ATK_KRH_DF_BPM_MAPPING_U3 Unique Default BPM_NAME, BPM_ID, CATEGORY_FORUM_ID

ATK_KRH_HIERARCHY_INTERSECTION

This table stores the Hierarchy Intersection data.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_HIERARCHY_INTERS_PK

PARENT_ITEM_ID, CHILD_ITEM_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id
PARENT_ITEM_ID VARCHAR2 20 Yes The parent item ID.
TOPIC_COUNT NUMBER 9 Yes TOPIC_COUNT
TOPIC_COUNT_FAQ NUMBER 9 Yes TOPIC_COUNT_FAQ
CHILD_ITEM_ID VARCHAR2 20 Yes The child item ID.
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_HIERARCHY_INTERS_PK Unique Default PARENT_ITEM_ID, CHILD_ITEM_ID
ATK_KRH_HIERARCHY_INTERS_U1 Unique Default CHILD_ITEM_ID, PARENT_ITEM_ID

ATK_KRH_HIERARCHY_ITEMS

This table stores the Hierarchy Items data.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_HIERARCHY_ITEMS_PK

ITEM_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id
TOPIC_COUNT_FAQ NUMBER 9 Yes TOPIC_COUNT_FAQ
ITEM_ID VARCHAR2 20 Yes The hierarchy key.
TOPIC_COUNT NUMBER 9 Yes TOPIC_COUNT
HIERARCHY_TYPE VARCHAR2 4 Yes The hierarchy type. Hierarchy types that begin with 'O' are reserved by Oracle.
ITEM_ID_NUMBER NUMBER 18 Yes The hierarchy number. Used to support older database views that require keys of type NUMBER.
ICON_FILE_NAME VARCHAR2 260 The icon file name. The icons are displayed on the Help Portal home page tabs, next to each hierarchy item.
TOPIC_RELEASES VARCHAR2 1000 A list of release numbers found on the topics table for this heirarchy item. A format of " en fr zu " would indicate the hierarchy node contains topics in English, French and Zulu.
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_KRH_HIERARCHY_ITEMS atk_krh_hierarchy_types HIERARCHY_TYPE
atk_krh_hierarchy_items_tl atk_krh_hierarchy_items ITEM_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_HIERARCHY_ITEMS_PK Unique Default ITEM_ID
ATK_KRH_HIERARCHY_ITEMS_U1 Unique Default ITEM_ID, HIERARCHY_TYPE

ATK_KRH_HIERARCHY_ITEMS_TL

This table stores the translated Hierarchy Items data.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_HIERARCHY_ITEMS_TL_PK

ITEM_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant enterprise Id
ITEM_ID VARCHAR2 20 Yes The hierarchy key.
NAME VARCHAR2 240 Yes The hierarchy name.
DESCRIPTION VARCHAR2 4000 The hierarchy description.
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_KRH_HIERARCHY_ITEMS_TL atk_krh_hierarchy_items ITEM_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_HIERARCHY_ITEMS_TL_PK Unique Default ITEM_ID, LANGUAGE

ATK_KRH_HIERARCHY_TYPES

This table stores the Hierarchy Types data.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_HIERARCHY_TYPES_PK

HIERARCHY_TYPE

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id
HIERARCHY_TYPE VARCHAR2 4 Yes The hierarchy type. Hierarchy types that begin with 'O' are reserved by Oracle.
DISPLAY_ON_NAV_REGION VARCHAR2 1 Yes Does the hierarchy appear on the Help Portal navigation region and used as a facet when searching topics. (0/1)
DISPLAY_LEVELS_ON_NAV_REGION NUMBER 9 The number of levels displayed on the navigation region.
DISPLAY_ON_HOME_TAB VARCHAR2 1 Yes Does the hierarchy appear on the Help Portal home page as a separate tab. (0/1)
DISPLAY_LEVELS_ON_TAB_REGION NUMBER 9 The number of levels displayed on the home page tab.
DISPLAY_ORDER NUMBER 9 Yes The order the hierarchy item appears on the navigation and tab UI.
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
atk_krh_hierarchy_types_tl atk_krh_hierarchy_types HIERARCHY_TYPE
atk_krh_hierarchy_items atk_krh_hierarchy_types HIERARCHY_TYPE

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_HIERARCHY_TYPES_PK Unique Default HIERARCHY_TYPE

ATK_KRH_HIERARCHY_TYPES_TL

This table stores the Translated Hierarchy Types data.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_HIERARCHY_TYPES_TL_PK

HIERARCHY_TYPE, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant enterprise Id
HIERARCHY_TYPE VARCHAR2 4 Yes The hierarchy type. Hierarchy types that begin with 'O' are reserved by Oracle.
NAVIGATION_REGION_NAME VARCHAR2 240 The Help Portal navigation region name.
HOME_TAB_NAME VARCHAR2 240 The Help Portal home page tab name.
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_KRH_HIERARCHY_TYPES_TL atk_krh_hierarchy_types HIERARCHY_TYPE

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_HIERARCHY_TYPES_TL_PK Unique Default HIERARCHY_TYPE, LANGUAGE

ATK_KRH_INDUSTRIES

ATK_KRH_INDUSTRIES Originally fusdoc.industries

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_INDUSTRIES_PK

INDUSTRY_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id
INDUSTRY_ID NUMBER Yes INDUSTRY_ID
HIERARCHY_NUMBER VARCHAR2 40 HIERARCHY_NUMBER
OWNER VARCHAR2 255 OWNER
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
atk_krh_industries_tl atk_krh_industries INDUSTRY_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_INDUSTRIES_PK Unique Default INDUSTRY_ID

ATK_KRH_INDUSTRIES_TL

MLS Table of ATK_KRH_INDUSTRIES

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_INDUSTRIES_TL_PK

INDUSTRY_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id
INDUSTRY_ID NUMBER Yes INDUSTRY_ID
NAME VARCHAR2 240 Yes NAME
DESCRIPTION VARCHAR2 1024 DESCRIPTION
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_KRH_INDUSTRIES_TL atk_krh_industries INDUSTRY_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_INDUSTRIES_TL_PK Unique Default INDUSTRY_ID, LANGUAGE

ATK_KRH_LANGUAGE_TRACK

This tracks whether help content exists for language code.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_LANGUAGE_TRACK_PK

ISO_LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
ISO_LANGUAGE VARCHAR2 30 Yes Language Tag.
TOPIC_EXISTS VARCHAR2 1 Yes Indicates where help content exists or not.
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.
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.

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_LANGUAGE_TRACK_N1 Non Unique Default TOPIC_EXISTS
ATK_KRH_LANGUAGE_TRACK_PK Unique Default ISO_LANGUAGE

ATK_KRH_RELEASES

Release lookup - table storing the release code and sequence.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_RELEASES_PK

RELEASE_CODE

Columns

Name Datatype Length Precision Not-null Comments
RELEASE_CODE VARCHAR2 20 Yes RELEASE_CODE
SEQ_NUM NUMBER Yes SEQ_NUM
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_RELEASES_PK Unique Default RELEASE_CODE

ATK_KRH_RELEASES_TL

Release - Single MLS table storing the release code

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_RELEASES_TL_PK

RELEASE_CODE, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
RELEASE_CODE VARCHAR2 20 Yes The current release
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
DESCRIPTION VARCHAR2 255 A more detailed description of the release.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_RELEASES_TL_PK Unique Default RELEASE_CODE, LANGUAGE

ATK_KRH_TERRITORIES

This stores the list of territories that are enabled for helpportal

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_TERRITORIES_PK

TERRITORY_CODE

Columns

Name Datatype Length Precision Not-null Comments
TERRITORY_CODE VARCHAR2 2 Yes TERRITORY_CODE
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
atk_krh_territory_track atk_krh_territories TERRITORY_CODE

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_TERRITORIES_U1 Unique Default TERRITORY_CODE

ATK_KRH_TERRITORIES_TL

MLS table of ATK_KRH_TERRITORIES

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_TERRITORIES_TL_PK

TERRITORY_CODE, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id
TERRITORY_CODE VARCHAR2 2 Yes TERRITORY_CODE
TERRITORY_SHORT_NAME VARCHAR2 80 Yes TERRITORY_SHORT_NAME
DESCRIPTION VARCHAR2 240 DESCRIPTION
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_TERRITORIES_TL_PK Unique Default TERRITORY_CODE, LANGUAGE

ATK_KRH_TERRITORY_TRACK

This tracks whether help content exists for Territory code or not.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_TERRITORY_TRACK_PK

TERRITORY_CODE

Columns

Name Datatype Length Precision Not-null Comments
TERRITORY_CODE VARCHAR2 2 Yes Territory code.
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.
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.
TOPIC_EXISTS VARCHAR2 1 Yes Indicates whether help content exists or not.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_KRH_TERRITORY_TRACK atk_krh_territories TERRITORY_CODE

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_TERRITORY_TRACK_PK Unique Default TERRITORY_CODE

ATK_KRH_UAP_KEYS

ATK_KRH_UAP_KEYS Table storing the UAP Keys

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_UAP_KEYS_PK

HELP_KEY

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant enterprise Id
HELP_KEY VARCHAR2 300 Yes HELP_KEY
UAP_HIERARCHY_IDS VARCHAR2 4000 UAP_HIERARCHY_IDS
STATUS VARCHAR2 200 Yes STATUS
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created 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.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
atk_krh_uap_keys_tl atk_krh_uap_keys HELP_KEY

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_UAP_KEYS_N1 Non Unique Default UPPER("HELP_KEY")
ATK_KRH_UAP_KEYS_PK Unique Default HELP_KEY

ATK_KRH_UAP_KEYS_TL

This table stores the translated UAP Keys data.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KRH_UAP_KEYS_TL_PK

HELP_KEY, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id
HELP_KEY VARCHAR2 300 Yes The UAP help key.
COMP_LABEL VARCHAR2 80 Yes COMP_LABEL
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_KRH_UAP_KEYS_TL atk_krh_uap_keys HELP_KEY

Indexes

Index Uniqueness Tablespace Columns
ATK_KRH_UAP_KEYS_TL_N1 Non Unique Default UPPER("COMP_LABEL"), LANGUAGE
ATK_KRH_UAP_KEYS_TL_PK Unique Default HELP_KEY, LANGUAGE

ATK_KR_GRAPHICS

This table represents binary files contained in a notional 'graphics' subdirectory. Image/object links in the main document refer to these files via. that relative path.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KR_GRAPHICS_PK

FILENAME

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id
FILENAME VARCHAR2 400 Yes The name of the file (a basename with no directory component).
MIME_TYPE VARCHAR2 128 MIME_TYPE
CONTENT BLOB The binary document file itself.
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_GRAPHICS_U1 Unique Default FILENAME

ATK_KR_HELP_TOPIC_SEQ

This table stores the help topic sequence for a given help key.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Columns

Name Datatype Length Precision Not-null Comments
ORIG_TITLE VARCHAR2 150 Yes ORIG_TITLE
SEQ NUMBER Yes Help Topic Sequence.
TOPIC_ID VARCHAR2 150 Yes TOPIC_ID
UAPKEY VARCHAR2 300 Yes UAPKEY
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_HELP_TOPIC_SEQ_N1 Non Unique Default TOPIC_ID
ATK_KR_HELP_TOPIC_SEQ_PK Unique FUSION_TS_TX_DATA ORIG_TITLE, UAPKEY, TOPIC_ID

ATK_KR_HIDDEN_TOPICS

Table that stores information on which Topics are hidden for which enterprises.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ATK_KR_HIDDEN_TOPICS_PK

TOPIC_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id
TOPIC_ID VARCHAR2 150 Yes TOPIC_ID
HIDDEN VARCHAR2 1 Yes Topic Hidden flag (1/0)
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.
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.

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_HIDDEN_TOPICS_U1 Unique Default TOPIC_ID

ATK_KR_HIERS_SUGGESTIONS

Suggestions of new search_ids for the orphaned search_ids for custom topics during upgrade.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KR_HIERS_SUGGESTIONS_PK

OLD_SEARCH_ID, NEW_SEARCH_ID

Columns

Name Datatype Length Precision Not-null Comments
OLD_SEARCH_ID VARCHAR2 500 Yes OLD_SEARCH_ID
NEW_SEARCH_ID VARCHAR2 500 Yes NEW_SEARCH_ID
CHANGED VARCHAR2 1 CHANGED
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.
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.

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_HIERS_SUGGESTIONS_U1 Unique Default OLD_SEARCH_ID, NEW_SEARCH_ID

ATK_KR_INDEX_TERMS

This table stores the HelpPortal Index terms.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id
TOPIC_ID VARCHAR2 150 Yes TOPIC_ID
INDEX_TERM VARCHAR2 300 Yes INDEX_TERM
INDEX_TERM_UPPER VARCHAR2 300 Yes INDEX_TERM_UPPER
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
ATK_KR_INDEX_TERMS_N1 Non Unique FUSION_TS_TX_DATA INDEX_TERM_UPPER
ATK_KR_INDEX_TERMS_PK Unique Default TOPIC_ID, INDEX_TERM

ATK_KR_INFO_TYPES

Lookup table for information about source XML document types.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KR_INFO_TYPES_PK

INFO_TYPE

Columns

Name Datatype Length Precision Not-null Comments
INFO_TYPE VARCHAR2 20 Yes Toplevel tag of the source XML document; the document type.
TOPIC_TYPE VARCHAR2 20 Yes The topic_type this info_type is mapped to.
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_KR_INFO_TYPES atk_kr_topic_types TOPIC_TYPE
atk_kr_info_types_tl atk_kr_info_types INFO_TYPE

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_INFO_TYPES_PK Unique Default INFO_TYPE

ATK_KR_INFO_TYPES_TL

The MLS table for ATK_KR_INFO_TYPES table

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KR_INFO_TYPES_TL_PK

INFO_TYPE, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
INFO_TYPE VARCHAR2 20 Yes INFO_TYPE
DESCRIPTION VARCHAR2 2000 DESCRIPTION
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_KR_INFO_TYPES_TL atk_kr_info_types INFO_TYPE

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_INFO_TYPES_TL_PK Unique Default INFO_TYPE, LANGUAGE

ATK_KR_ORPHAN_TOPIC_HIER

Contains the orphaned search ids of custom topics after every upgrade.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KR_ORPHAN_TOPIC_HIER_PK

TOPIC_ID, SEARCH_ID

Columns

Name Datatype Length Precision Not-null Comments
TOPIC_ID VARCHAR2 600 Yes Id of the custom topic which has orphaned search ids.
SEARCH_ID VARCHAR2 500 Yes Orphaned search id of the custom topic.
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.
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.

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_ORPHAN_TOPIC_HIER_U1 Unique Default TOPIC_ID, SEARCH_ID

ATK_KR_SEARCH_STATS

Table that stores search statistics for keyword searches done in Help Portal. A record of search term, and the no: of times searched is maintained.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ATK_KR_SEARCH_STATS_PK

SEARCH_TERM

Columns

Name Datatype Length Precision Not-null Comments
SEARCH_TERM VARCHAR2 4000 Yes Keyword used in search, for which statistics need to be gathered
SEARCH_COUNT NUMBER 18 Yes Aggregate count of number of times keyword has been searched for
HIER_TYPE VARCHAR2 20 Hierarchy Type
LEVEL1_ID VARCHAR2 20 LEVEL1_ID
LEVEL2_ID VARCHAR2 20 LEVEL2_ID
LEVEL3_ID VARCHAR2 20 LEVEL3_ID
LEVEL4_ID VARCHAR2 20 LEVEL4_ID
LEVEL5_ID VARCHAR2 20 LEVEL5_ID
LEVEL6_ID VARCHAR2 20 LEVEL6_ID
SOURCE VARCHAR2 20 Facet values for Source facet
RELEASE VARCHAR2 4000 Facet values for Release facet
ISO_LANGUAGE VARCHAR2 4000 Facet values for Language facet
SEARCH_TERRITORIES VARCHAR2 4000 Facet values for Country facet
TOPIC_TYPE VARCHAR2 200 Facet values for Topic_type facet
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.
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.

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_SEARCH_STATS_U1 Unique Default SEARCH_TERM

ATK_KR_SRCH_TOPICS_HIER

snapshot table for snapshot FUSION.ATK_KR_SRCH_TOPIC_HIERARCHY

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KR_SRCH_TOPICS_HIER_PK

TOPIC_ID, HIERARCHY_TYPE, LEVEL1_ID, LEVEL2_ID, LEVEL3_ID, LEVEL4_ID, LEVEL5_ID, LEVEL6_ID, TERRITORY_CODE

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id
TOPIC_ID VARCHAR2 150 Yes TOPIC_ID
TOPIC_TYPE VARCHAR2 20 TOPIC_TYPE
SEARCH_RELEASES VARCHAR2 4000 SEARCH_RELEASES
TERRITORY_CODE VARCHAR2 2 Yes TERRITORY_CODE
ISO_LANGUAGE VARCHAR2 30 ISO_LANGUAGE
HIERARCHY_TYPE VARCHAR2 4 Yes The hierarchy type.
LEVEL1_ID VARCHAR2 20 Yes The hierarchy level 1 ID.
LEVEL2_ID VARCHAR2 20 Yes The hierarchy level 2 ID.
LEVEL3_ID VARCHAR2 20 Yes The hierarchy level 3 ID.
LEVEL4_ID VARCHAR2 20 Yes The hierarchy level 4 ID.
LEVEL5_ID VARCHAR2 20 Yes The hierarchy level 5 ID.
LEVEL6_ID VARCHAR2 20 Yes The hierarchy level 6 ID.
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.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_KR_SRCH_TOPICS_HIER atk_kr_topics TOPIC_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_SRCH_TOPICS_HIER_N01 Non Unique Default HIERARCHY_TYPE, LEVEL1_ID, ISO_LANGUAGE, TERRITORY_CODE, TOPIC_TYPE
ATK_KR_SRCH_TOPICS_HIER_N02 Non Unique Default HIERARCHY_TYPE, LEVEL2_ID, ISO_LANGUAGE, TERRITORY_CODE, TOPIC_TYPE
ATK_KR_SRCH_TOPICS_HIER_N03 Non Unique Default HIERARCHY_TYPE, LEVEL3_ID, ISO_LANGUAGE, TERRITORY_CODE, TOPIC_TYPE
ATK_KR_SRCH_TOPICS_HIER_N04 Non Unique Default HIERARCHY_TYPE, LEVEL4_ID, ISO_LANGUAGE, TERRITORY_CODE, TOPIC_TYPE
ATK_KR_SRCH_TOPICS_HIER_N05 Non Unique Default HIERARCHY_TYPE, LEVEL5_ID, ISO_LANGUAGE, TERRITORY_CODE, TOPIC_TYPE
ATK_KR_SRCH_TOPICS_HIER_N06 Non Unique Default HIERARCHY_TYPE, LEVEL6_ID, ISO_LANGUAGE, TERRITORY_CODE, TOPIC_TYPE
ATK_KR_SRCH_TOPICS_HIER_N22 Non Unique Default HIERARCHY_TYPE, LEVEL1_ID, LEVEL2_ID, ISO_LANGUAGE, TERRITORY_CODE, TOPIC_TYPE
ATK_KR_SRCH_TOPICS_HIER_N23 Non Unique Default HIERARCHY_TYPE, LEVEL1_ID, LEVEL2_ID, LEVEL3_ID, ISO_LANGUAGE, TERRITORY_CODE, TOPIC_TYPE
ATK_KR_SRCH_TOPICS_HIER_N24 Non Unique Default HIERARCHY_TYPE, LEVEL1_ID, LEVEL2_ID, LEVEL3_ID, LEVEL4_ID, ISO_LANGUAGE, TERRITORY_CODE, TOPIC_TYPE
ATK_KR_SRCH_TOPICS_HIER_N25 Non Unique Default HIERARCHY_TYPE, LEVEL1_ID, LEVEL2_ID, LEVEL3_ID, LEVEL4_ID, LEVEL5_ID, ISO_LANGUAGE, TERRITORY_CODE, TOPIC_TYPE
ATK_KR_SRCH_TOPICS_HIER_N26 Non Unique Default HIERARCHY_TYPE, LEVEL1_ID, LEVEL2_ID, LEVEL3_ID, LEVEL4_ID, LEVEL5_ID, LEVEL6_ID, ISO_LANGUAGE, TERRITORY_CODE, TOPIC_TYPE
ATK_KR_SRCH_TOPICS_HIER_N31 Non Unique Default TOPIC_ID, TOPIC_TYPE, TERRITORY_CODE
ATK_KR_SRCH_TOPICS_HIER_PK Unique Default TOPIC_ID, HIERARCHY_TYPE, LEVEL1_ID, LEVEL2_ID, LEVEL3_ID, LEVEL4_ID, LEVEL5_ID, LEVEL6_ID, TERRITORY_CODE
ATK_KR_SRCH_TOPICS_HIER_U1 Unique Default TOPIC_ID, HIERARCHY_TYPE, LEVEL1_ID, LEVEL2_ID, LEVEL3_ID, LEVEL4_ID, LEVEL5_ID, LEVEL6_ID, ISO_LANGUAGE, TERRITORY_CODE, TOPIC_TYPE

ATK_KR_TITLES

A title is a record representing all the topics that have the same originalTitle value.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KR_TITLES_PK

ORIG_TITLE

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id
ORIG_TITLE VARCHAR2 150 Yes The document's key string value. The field name used is dictated by the spec.
INFO_TYPE VARCHAR2 30 Yes Topic Info Type.
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.
DOC_IDENT VARCHAR2 200 Identifier/version of original document for trackback. The value depends on the SCM system in use, via. the Staging subsystem.
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.
SEEN_MARK VARCHAR2 1 Yes This is the flag used for title processing.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
atk_kr_topics atk_kr_titles ORIG_TITLE

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_TITLES_U1 Unique Default ORIG_TITLE

ATK_KR_TITLE_UAPKEYS

This table stores the title and uapkeys.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id
ORIG_TITLE VARCHAR2 150 Yes ORIG_TITLE
UAPKEY VARCHAR2 300 Yes UAPKEY
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.
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.

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_TITLE_UAPKEYS_N1 Non Unique Default UAPKEY
ATK_KR_TITLE_UAPKEYS_PK Unique FUSION_TS_TX_DATA ORIG_TITLE, UAPKEY

ATK_KR_TOPICS

An individual instance of a title document, for a particular industry, localization(s), release, and language.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KR_TOPICS_PK

TOPIC_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant enterprise Id
TOPIC_ID VARCHAR2 150 Yes Unique generated primary key for the topic.
ORIG_TITLE VARCHAR2 150 Yes The title that this topic is an instance of.
TITLE VARCHAR2 4000 Yes Title of the topic.
TOPIC_TYPE VARCHAR2 20 Yes TOPIC_TYPE
FILE_TYPE VARCHAR2 20 FILE_TYPE
DOCUMENT BLOB DOCUMENT
MIME_TYPE VARCHAR2 128 MIME_TYPE
ABSTRACT_SUMMARY VARCHAR2 4000 Yes ABSTRACT
SOURCE VARCHAR2 20 Yes SOURCE
CHANGED TIMESTAMP Yes CHANGED
HIDDEN VARCHAR2 1 Yes HIDDEN
OBSOLETE VARCHAR2 1 Yes Marked as 1 when Topic is obsoleted.
ISO_LANGUAGE VARCHAR2 30 Yes ISO_LANGUAGE
RELEASE VARCHAR2 4000 Yes RELEASE
INDUSTRY_ID NUMBER INDUSTRY_ID
NEW_FEATURE VARCHAR2 1 NEW_FEATURE
FILE_NAME VARCHAR2 2000 FILE_NAME
URL VARCHAR2 4000 URL
UPK_READONLY_URL VARCHAR2 4000 UPK_READONLY_URL
UPK_TOPIC_GUID VARCHAR2 4000 UPK_TOPIC_GUID
UPK_TOPIC_NAME VARCHAR2 2000 UPK_TOPIC_NAME
UPK_TOPIC_URL VARCHAR2 4000 UPK_TOPIC_URL
TOP_TOPIC_COUNT NUMBER TOP_TOPIC_COUNT
PRIMARY_HIERARCHY_TYPE VARCHAR2 20 Yes PRIMARY_HIERARCHY_TYPE
PRIMARY_LEVEL1_ID VARCHAR2 20 Yes PRIMARY_LEVEL1_ID
PRIMARY_LEVEL2_ID VARCHAR2 20 PRIMARY_LEVEL2_ID
PRIMARY_LEVEL3_ID VARCHAR2 20 PRIMARY_LEVEL3_ID
PRIMARY_LEVEL4_ID VARCHAR2 20 PRIMARY_LEVEL4_ID
PRIMARY_LEVEL5_ID VARCHAR2 20 PRIMARY_LEVEL5_ID
PRIMARY_LEVEL6_ID VARCHAR2 20 PRIMARY_LEVEL6_ID
SEARCH_IDS VARCHAR2 4000 Yes HIERARCHY_IDS
INDEX_TERMS VARCHAR2 4000 Yes INDEX_TERMS
SEARCH_INDEXES VARCHAR2 4000 Yes SES_INDEX_TERMS
SEARCH_TERRITORIES VARCHAR2 4000 TERRITORY_CODES
SEARCH_RELEASES VARCHAR2 4000 Yes RELEASES
SEARCH_HELPKEYS VARCHAR2 4000 SEARCH_HELPKEYS
SEARCH_INDUSTRIES VARCHAR2 4000 INDUSTRIES
SECURITY_CODE VARCHAR2 20 A user definable security code that can be configured to support data security on help topics.
GETTING_STARTED VARCHAR2 1 Flag to determine whether the topic is a getting started topic or not.
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_KR_TOPICS atk_kr_titles ORIG_TITLE
atk_kr_srch_topics_hier atk_kr_topics TOPIC_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_TOPICS_N1 Non Unique FUSION_TS_TX_DATA ORIG_TITLE
ATK_KR_TOPICS_N2 Non Unique FUSION_TS_TX_DATA ISO_LANGUAGE
ATK_KR_TOPICS_N3 Non Unique Default DOCUMENT
ATK_KR_TOPICS_N4 Non Unique Default UPPER("TITLE")
ATK_KR_TOPICS_PK Unique FUSION_TS_TX_DATA TOPIC_ID

ATK_KR_TOPIC_HELPKEYS

this tables stores mappings of topics to helpkeys.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KR_TOPIC_HELPKEYS_PK

HELP_KEY, TOPIC_ID

Columns

Name Datatype Length Precision Not-null Comments Status
HELP_KEY VARCHAR2 300 Yes UAPKEY Active
TOPIC_ID VARCHAR2 150 Yes Unique generated primarykey for topic Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
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. Active

Indexes

Index Uniqueness Tablespace Columns Status
ATK_KR_TOPIC_HELPKEYS_PK Unique FUSION_TS_TX_IDX HELP_KEY, TOPIC_ID Active

ATK_KR_TOPIC_TXS

ATK_KR_TOPIC_TXS Table storing the user ratings

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_KR_TOPIC_TXS_PK

TOPIC_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id
TOPIC_ID VARCHAR2 150 Yes TOPIC_ID
RATING NUMBER 1 RATING
RATING_COUNT NUMBER 18 RATING_COUNT
RATING_TOTAL NUMBER 18 RATING_TOTAL
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.
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.

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_TOPIC_TXS_U1 Unique Default TOPIC_ID

ATK_KR_TOPIC_TYPES

A topic type is a record representing all the topic types.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KR_TOPIC_TYPES_PK

TOPIC_TYPE

Columns

Name Datatype Length Precision Not-null Comments
TOPIC_TYPE VARCHAR2 20 Yes TOPIC_TYPE
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
atk_kr_topic_types_tl atk_kr_topic_types TOPIC_TYPE
atk_kr_info_types atk_kr_topic_types TOPIC_TYPE

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_TOPIC_TYPES_PK Unique Default TOPIC_TYPE

ATK_KR_TOPIC_TYPES_TL

MLS Table of ATK_KR_TOPIC_TYPES

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_KR_TOPIC_TYPES_TL_PK

TOPIC_TYPE, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
TOPIC_TYPE VARCHAR2 20 Yes TOPIC_TYPE
SHORT_NAME VARCHAR2 200 Yes SHORT_NAME
DESCRIPTION VARCHAR2 2000 DESCRIPTION
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_KR_TOPIC_TYPES_TL atk_kr_topic_types TOPIC_TYPE

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_TOPIC_TYPES_TL_U1 Unique Default TOPIC_TYPE, LANGUAGE

ATK_KR_UAP_TOPICS_SEQ

This table stores the help topic sequence for a given help key,language, release and territory

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ATK_KR_UAP_TOPICS_SEQ_PK

ISO_LANGUAGE, TERRITORIES, RELEASE, ORIG_TITLE, TOPIC_ID, UAPKEY

Columns

Name Datatype Length Precision Not-null Comments
ISO_LANGUAGE VARCHAR2 30 Yes ISO_LANGUAGE
TERRITORIES VARCHAR2 30 Yes TERRITORIES
RELEASE VARCHAR2 20 Yes RELEASE
ORIG_TITLE VARCHAR2 150 Yes ORIG_TITLE
SEQ NUMBER Yes Help Topic Sequence.
TOPIC_ID VARCHAR2 150 Yes TOPIC_ID
UAPKEY VARCHAR2 300 Yes UAPKEY
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.
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.

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_UAP_TOPICS_SEQ_U1 Unique Default ISO_LANGUAGE, TERRITORIES, RELEASE, ORIG_TITLE, TOPIC_ID, UAPKEY

ATK_KR_USER_RATING

User Rating Table which stores the ratings

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_KR_USER_RATING_PK

USER_ID, PARENT_TABLE_NAME, PARENT_TABLE_KEY_VALUE

Columns

Name Datatype Length Precision Not-null Comments
USER_ID VARCHAR2 64 Yes User Identifier
USER_NAME VARCHAR2 64 User Name
PARENT_TABLE_NAME VARCHAR2 200 Yes Parent Table Name
PARENT_TABLE_KEY_VALUE VARCHAR2 32 Yes Parent Table Key Value
RATING NUMBER 2 Yes User Rating
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
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_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
REVIEW_COMMENTS VARCHAR2 4000 User Review Comments
REVIEW_TITLE VARCHAR2 200 User Review Title

Indexes

Index Uniqueness Tablespace Columns
ATK_KR_USER_RATING_U1 Unique Default USER_ID, PARENT_TABLE_NAME, PARENT_TABLE_KEY_VALUE

ATK_MESSAGING_PRODUCT_CONTEXTS

ATK_MESSAGING_PRODUCT_CONTEXTS stores the context and Product Details

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ATK_MESSAGING_PRODUCT_CON_PK

CONTEXT_ID

Columns

Name Datatype Length Precision Not-null Comments
CONTEXT_ID NUMBER 18 Yes CONTEXT_ID : The id of the context.
PRODUCT_SHORT_NAME VARCHAR2 10 Yes PRODUCT_SHORT_NAME: The Product Short Name
CONTEXT VARCHAR2 240 Yes CONTEXT : Stores the context Information
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.

Indexes

Index Uniqueness Tablespace Columns
ATK_MESSAGING_PRODUCT_CON_PK Unique Default CONTEXT_ID

ATK_MESSAGING_TEMPLATES_B

ATK_MESSAGING_TEMPLATES_B Base Table

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ATK_MESSAGING_TEMPLATES_B_PK

TEMPLATE_ID

Columns

Name Datatype Length Precision Not-null Comments
TEMPLATE_ID NUMBER 18 Yes TEMPLATE_ID
TEMPLATE_PATH VARCHAR2 2000 Yes TEMPLATE_PATH
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CONTEXT_ID NUMBER 18 Yes CONTEXT_ID
TEMPLATE_NAME VARCHAR2 240 Yes TEMPLATE_NAME
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created 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.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
atk_messaging_templates_tl atk_messaging_templates_b TEMPLATE_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_MESSAGING_TEMPLATES_B_PK Unique Default TEMPLATE_ID

ATK_MESSAGING_TEMPLATES_TL

MLS table of ATK_MESSAGING_TEMPLATES

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ATK_MESSAGING_TEMPLATES_T_PK

TEMPLATE_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
TEMPLATE_ID NUMBER 18 Yes TEMPLATE_ID
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
USER_TEMPLATE_NAME VARCHAR2 240 Yes USER_TEMPLATE_NAME
TEMPLATE_DESCRIPTION VARCHAR2 240 TEMPLATE_DESCRIPTION
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created 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.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_MESSAGING_TEMPLATES_TL atk_messaging_templates_b TEMPLATE_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_MESSAGING_TEMPLATES_T_PK Unique Default TEMPLATE_ID, LANGUAGE

ATK_POPUP_ITEMS

Table to store notifications for users delivered by UMS.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ATK_POPUP_ITEMS_PK

MESSAGE_ID

Columns

Name Datatype Length Precision Not-null Comments
MESSAGE_ID NUMBER 18 Yes Generated Message Identifier.
TASK_ID VARCHAR2 64 Unique Identifier from SOA
UMS_MESSAGE_ID VARCHAR2 64 Message Identifier provided from source of this notification (SOA/CRM). Used for diagnosing any delivery issues.
USER_GUID VARCHAR2 64 Yes User Identifier. This is the user that the message is addressed to.
TASK_DISPLAY_URL VARCHAR2 2000 This is the drilldown URL for viewing notification details.
TASK_DETAILS_AVAILABLE_FLAG VARCHAR2 1 Yes Flag indicates whether notification details are available in source of this notification (SOA/CRM).
TASK_STATE VARCHAR2 20 TASK_STATE
SOA_SERVER VARCHAR2 128 SOA Server name of the Human Workflow Task created
SOA_OUTCOMES VARCHAR2 256 Outcomes for the current Task used to complete custom actions inline
SOA_OUTCOMES_DISPLAY VARCHAR2 256 Outcomes names to be displayed to the user as inline custom actions
TASK_CREATOR VARCHAR2 64 FROM_USER
MESSAGE_CREATION_DATE NUMBER 18 Yes Message creation date in java long format. Indicates when the message was created in source of this notification (SOA/CRM).
MESSAGE_SUMMARY VARCHAR2 2000 Notification summary.
THINGS_TO_FINISH_STATE VARCHAR2 20 Indicates whether the notification has to shown in things to finish section or not Valid values are null or HIDE.
STATUS VARCHAR2 20 Indicates whether the notification has been viewed by the user. Valid values are READ and UNREAD.
MSG_CREATION_DB_DATE TIMESTAMP Message creation date in database timestamp format. Indicates when the message was created in source of this notification (SOA/CRM).
SOURCE VARCHAR2 30 Indicates whether the notification is from SOA for human task delivered by UMS or if its from CRM for Calender Appointment/Task/Reminder. Valid values are 'SOA_HUMAN_TASK' and 'CRM_CALENDAR_APPOINTMENT'
NOTIFICATION_TYPE VARCHAR2 30 Indicates the type of Notification. Whether it will open up in a Dialog or Drill Down or no details at all.
ADDITIONAL_ATTRIBUTES VARCHAR2 2000 All the additional Attributes passed on from BPM.
NAVIGATION_URL_KEY VARCHAR2 80 This is the key to determine the host, port, context root, etc. to construct the url for the UI drilldown from watchlist item. Reference to FND_DEPLOYMENTS.DEPLOYMENT_NAME . This will be used for the applcore ui shell navigate api that will be used for UI navigation across applications.
VIEW_ID VARCHAR2 400 The view id (as per the ui shell menu) for the workarea/page that contains the task flow for this notification.
PAGE_PARAM_LIST_STRING VARCHAR2 400 Parameters list for the page. If the target workarea page accepts page parameters, this is a semicolon delimited String of name value pairs.
TASKFLOW_ID VARCHAR2 400 The task flow for this notification item's drilldown from Notification Bell Popup
TF_KEY_LIST_STRING VARCHAR2 400 Key list to pass into the task flow to open in the target workspace. This is a semicolon delimited keys or key-value pairs. For example, "key1;key2=value2".
TF_PARAMETER_STRING VARCHAR2 400 Parameters list to pass in to the task flow to open in the target workspace. This is a semicolon delimited String of name value pairs. For example, "param1=value1;param2=value2" For user created saved search, the view criteria id will be appended to this string (the string will need to end with <paramName>= for saved search). Required if WATCHLIST_ITEM_TYPE IN (SEEDED_SAVED_SEARCH, USER_SAVED_SEARCH) .
TASK_TAB_LABEL VARCHAR2 400 Label for the task flow to open in the target workspace. This should be an EL expression with fully qualified resource bundle reference within the target application.
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.
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.

Indexes

Index Uniqueness Tablespace Columns
ATK_POPUP_ITEMS_N1 Non Unique Default USER_GUID, "MESSAGE_CREATION_DATE", STATUS
ATK_POPUP_ITEMS_N2 Non Unique Default TASK_ID
ATK_POPUP_ITEMS_N3 Non Unique Default TASK_CREATOR, TASK_STATE, STATUS, "MESSAGE_CREATION_DATE"
ATK_POPUP_ITEMS_U1 Unique Default MESSAGE_ID

ATK_QB_CONTEXTS_ALL_B

Base table for all context objects, which can be either Rule Context or Query Context.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_QB_CONTEXTS_ALL_B_PK

CONTEXT_ID

Columns

Name Datatype Length Precision Not-null Comments
CONTEXT_ID NUMBER 18 Yes Primary key of the table.
APPLICATION_ID NUMBER 18 Yes Represents the application to which the context object belongs to.
CONTEXT_NAME VARCHAR2 240 Yes Name of the context object. This name is used for fetching queries, fetching the rule results etc.
MULTI_VALUE_FLAG VARCHAR2 3 Represents whether there is conditional dependency among the results that are to be returned when a rule matches.
MULTI_RULE_RESULT_FLAG VARCHAR2 3 Represents whether to return the result of first matching rule or the results of all the matching rules
CONTEXT_TYPE_CODE VARCHAR2 15 Yes This column is used to identify whether the context object is used for creating the rules or setting up queries. The current values to be assigned are "RULES" and "QUERY"
FLEX_FIELD_NAME VARCHAR2 240 If one result value depends on another value then we use the DFF. This field represents the name of the DFF.
FLEX_FIELD_APP_ID NUMBER 18 Represents the application to which the DFF belongs to.
USE_DEFAULT_FLAG VARCHAR2 3 Determines whether to use the default result if no rule matches.
IS_DEFAULT_REQUIRED_FLAG VARCHAR2 3 Determines whether the default value is mandatory or not.
CONTEXT_CATEGORY VARCHAR2 240 Yes This column is used to prevent the context name clashes.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
IS_QUERY_USER_NAME_UNIQUE VARCHAR2 1 Flag to restrict the user to create rules or queries with unique user name under a rule or query group.
UNIQUE_QRY_USER_NAME_REQ_MSG VARCHAR2 150 Error message raised when creating query or rule with existing user name under a query group or rule group.
IS_QRY_CRITERIA_REQ VARCHAR2 1 Flag to restrict the user to create rules with atleast one criteria or condition.
QRY_CRITERIA_REQ_MSG VARCHAR2 150 Error message raised when trying to create query or rule without condition or criteria.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
atk_qb_contexts_all_tl atk_qb_contexts_all_b CONTEXT_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_CONTEXTS_ALL_B_PK Unique Default CONTEXT_ID

ATK_QB_CONTEXTS_ALL_TL

Translational table for ATK_QB_CONTEXTS_ALL_B

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_QB_CONTEXTS_ALL_TL_PK

CONTEXT_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
CONTEXT_ID NUMBER 18 Yes Represents the context id to which the user informatioin belongs to.
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
USER_CONTEXT_NAME VARCHAR2 240 Yes Name of the context object as shown to the user.
CONTEXT_DESC VARCHAR2 240 Description of the context.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated 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 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_QB_CONTEXTS_ALL_TL atk_qb_contexts_all_b CONTEXT_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_CONTEXTS_ALL_TL_PK Unique Default CONTEXT_ID, LANGUAGE

ATK_QB_CXT_ATTRIBUTES_B

base table for Context Attributes

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_QB_CXT_ATTRIBUTES_B_PK

ATTRIBUTE_ID

Columns

Name Datatype Length Precision Not-null Comments
ATTRIBUTE_ID NUMBER 18 Yes Primary Key of the table.
ATTRIBUTE_NAME VARCHAR2 240 Yes The internal name of the attribute. This is used during the processing.
DATA_TYPE_CODE VARCHAR2 240 Yes Represents the data type of the attribute.
FLEX_VALUE_SET_ID NUMBER 18 If the value for this attribute comes from a valueset, then its id is stored in this column.
CONTEXT_ID NUMBER 18 Yes Identifier of the context to which this attribute belongs to.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
atk_qb_cxt_attributes_tl atk_qb_cxt_attributes_b ATTRIBUTE_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_CXT_ATTRIBUTES_B_PK Unique Default ATTRIBUTE_ID

ATK_QB_CXT_ATTRIBUTES_TL

Translational Table for ATK_QB_CXT_ATTRIBUTES_B

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_QB_CXT_ATTRIBUTES_TL_PK

ATTRIBUTE_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
ATTRIBUTE_ID NUMBER 18 Yes Identifier of the attribute to which the information belongs to.
USER_ATTRIB_NAME VARCHAR2 240 Yes Name of the attribute shown to the user.
ATTRIB_DESC VARCHAR2 240 Description of the attribute.
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated 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 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_QB_CXT_ATTRIBUTES_TL atk_qb_cxt_attributes_b ATTRIBUTE_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_CXT_ATTRIBUTES_TL_PK Unique Default ATTRIBUTE_ID, LANGUAGE

ATK_QB_CXT_ENT_REFS_B

Base table for Context Entity References

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_QB_CXT_ENT_REFS_B_PK

ENTITY_REFERENCE_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTITY_REFERENCE_ID NUMBER 18 Yes Primary key of table.
TABLE_APPLICATION_ID NUMBER 18 Yes The application to which the table or view belongs to.
TABLE_ID NUMBER 18 Yes The identification number of the product table or the view which is being represented by this reference.
CONTEXT_ID NUMBER 18 Yes The identification number of the context to which this reference belongs to.
ALIAS_NAME VARCHAR2 240 Yes This is the alias name of the table, and is used while building the query.
ENTITY_TYPE VARCHAR2 15 Yes This column is used to determine the type of the entity we are referencing. The valid values are 'TABLE' and 'VIEW'. If it is 'TABLE', we refer to a row of FND_TABLES and if the value is 'VIEW' we refer to row of FND_VIEWS.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
atk_qb_cxt_ent_refs_tl atk_qb_cxt_ent_refs_b ENTITY_REFERENCE_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_CXT_ENT_REFS_B_PK Unique Default ENTITY_REFERENCE_ID

ATK_QB_CXT_ENT_REFS_TL

Translation table for ATK_QB_CXT_ENT_REFS_B

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_QB_CXT_ENT_REFS_TL_PK

ENTITY_REFERENCE_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
ENTITY_REFERENCE_ID NUMBER 18 Yes The identifier of the entity reference to which this user information belongs to.
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
ENTITY_USER_NAME VARCHAR2 240 Yes The user defined name of the entity.
ENTITY_REFERENCE_DESC VARCHAR2 240 Description of the entity reference.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated 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 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_QB_CXT_ENT_REFS_TL atk_qb_cxt_ent_refs_b ENTITY_REFERENCE_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_CXT_ENT_REFS_TL_PK Unique Default ENTITY_REFERENCE_ID, LANGUAGE

ATK_QB_CXT_RESULTS_B

Base table for all Context Results

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_QB_CXT_RESULTS_B_PK

RESULT_ID

Columns

Name Datatype Length Precision Not-null Comments
RESULT_ID NUMBER 18 Yes Primary key of the table.
CONTEXT_ID NUMBER 18 Yes The identification number of the context to which the result belongs to.
SEQUENCE_NUM NUMBER 18 Yes This column is used while ordering the results.
RESULT_NAME VARCHAR2 240 Yes The name of the result.
DATA_TYPE_CODE VARCHAR2 18 Yes The datatype of the result.
FLEX_VALUESET_ID NUMBER 18 If the result gets its value from a valueset, then its is stored in this column.
RESULT_TYPE VARCHAR2 240 Yes Determines whether the value for this result comes from a valueset or from the entity attribute references or just a literal value. The possible values are 'FLEX', 'ATTRIBUTE','LITERAL'.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
atk_qb_qry_rslt_values atk_qb_cxt_results_b RESULT_ID
atk_qb_default_rslt_vals atk_qb_cxt_results_b RESULT_ID
atk_qb_cxt_results_tl atk_qb_cxt_results_b RESULT_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_CXT_RESULTS_B_PK Unique Default RESULT_ID

ATK_QB_CXT_RESULTS_TL

Translation Table for ATK_QB_CXT_RESULTS_B

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_QB_CXT_RESULTS_TL_PK

RESULT_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
RESULT_ID NUMBER 18 Yes The identifier of the context result to which this user information belongs to.
RESULT_USER_NAME VARCHAR2 240 Yes The user name of the result.
RESULT_DESC VARCHAR2 240 The description of the context result.
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated 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 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_QB_CXT_RESULTS_TL atk_qb_cxt_results_b RESULT_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_CXT_RESULTS_TL_PK Unique Default RESULT_ID, LANGUAGE

ATK_QB_DEFAULT_RSLT_VALS

Table for Default Result's values of RuleGroup

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_QB_DEFAULT_RSLT_VALS_PK

DEFAULT_VALUE_ID

Columns

Name Datatype Length Precision Not-null Comments
DEFAULT_VALUE_ID NUMBER 18 Yes The primary key of this table
QUERY_GROUP_ID NUMBER 18 Yes The id of the query group to which this default result value belongs.
RESULT_ID NUMBER 18 Yes The id of the result to which the default value is associated to.
DEFAULT_VALUE VARCHAR2 2000 Context level default value of a context result. If none of the rules matches and if the default value has to be used this value will be returned.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_QB_DEFAULT_RSLT_VALS atk_qb_cxt_results_b RESULT_ID
ATK_QB_DEFAULT_RSLT_VALS atk_qb_query_group_b QUERY_GROUP_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_DEFAULT_RSLT_VALS_PK Unique Default DEFAULT_VALUE_ID

ATK_QB_ENT_ATTR_REFS_B

Base table for Context Entity Attribute References

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_QB_ENT_ATTR_REFS_B_PK

ATTRIBUTE_REFERENCE_ID

Columns

Name Datatype Length Precision Not-null Comments
ATTRIBUTE_REFERENCE_ID NUMBER 18 Yes Primary key of the table.
ENTITY_REFERENCE_ID NUMBER 18 Yes The entity reference to which this attribute reference belongs to.
ATTRIBUTE_REFERENCE_NAME VARCHAR2 240 Yes The internal name of the attribute reference. This will be used as the alias of the column while building the sql query.
COLUMN_NAME VARCHAR2 240 Yes The name of the column of the table or the view which is being represented by the entity reference to which this attribute belongs to..
DATA_TYPE_CODE VARCHAR2 18 Yes The datatype of the column.
FLEX_VALUE_SET_ID NUMBER 18 Identifies the valueset from which this column gets its values.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
atk_qb_ent_attr_refs_tl atk_qb_ent_attr_refs_b ATTRIBUTE_REFERENCE_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_ENT_ATTR_REFS_B_PK Unique Default ATTRIBUTE_REFERENCE_ID

ATK_QB_ENT_ATTR_REFS_TL

Translation table for ATK_QB_ENT_ATTR_REFS_B

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_QB_ENT_ATTR_REFS_TL_PK

ATTRIBUTE_REFERENCE_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
ATTRIBUTE_REFERENCE_ID NUMBER 18 Yes The attribute reference to which this user information belongs to.
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
ATTRIBUTE_REF_USER_NAME VARCHAR2 240 Yes The user name of the entity attribute reference.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated 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 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_QB_ENT_ATTR_REFS_TL atk_qb_ent_attr_refs_b ATTRIBUTE_REFERENCE_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_ENT_ATTR_REFS_TL_PK Unique Default ATTRIBUTE_REFERENCE_ID, LANGUAGE

ATK_QB_QRY_BINDPARAMS

Table for the references to BindParameters that are present in the sqlQuery for the Rule/Query

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_QB_QRY_BINDPARAMS_PK

BIND_PARAM_ID

Columns

Name Datatype Length Precision Not-null Comments
BIND_PARAM_ID NUMBER 18 Yes Primary key of the table.
QUERY_ID NUMBER 18 Yes Represents the query to which this bind parameter is associated to.
ATTRIBUTE_ID NUMBER 18 Yes Represents the context attribute to which this bind parameter refers to.
BIND_PARAM_NAME VARCHAR2 480 Yes The name of the bind parameter.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_QB_QRY_BINDPARAMS atk_qb_queries_b QUERY_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_QRY_BINDPARAMS_PK Unique Default BIND_PARAM_ID

ATK_QB_QRY_CRITERIA

table for rule criterias defined based on which the Rule's/Query's sqlQuery is created

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_QB_QRY_CRITERIA_PK

CRITERIA_ID

Columns

Name Datatype Length Precision Not-null Comments
CRITERIA_ID NUMBER 18 Yes Primary key of this table.
SEQUENCE_NUMBER NUMBER 18 Yes The criteria of a particular parent have to be evaluated in a particular order. This ordering can be achieved using this sequnce number.
CRITERIA_TYPE VARCHAR2 240 Yes A Criteria can be one of the two types 'GROUP', or 'ITEM'. This column represents the type of the criteria.
PARENT_ID NUMBER 18 Yes Every criteria does have a parent. The parent can be a query or another criteria of type 'GROUP'. This column identifies the parent.
PARENT_TYPE VARCHAR2 240 Yes Every criteria does have a parent. The parent can be a query or another criteria of type 'GROUP'. This column identifies the type of the parent. The valid values are QUERY or GROUP.
CONJUNCTION_OPERATOR VARCHAR2 240 The criteria which are logical expressions are generally sepereated by operators like 'AND', 'OR' etc. This column represents this conjucntion operator.
LEFT_HAND_EXP_TYPE VARCHAR2 240 The product teams can have either an expression or an attribute on the left hand side of the expression. This column represents what is present on the left hand side of the criteria.
OPERATION_NAME VARCHAR2 240 Defines the operation on Left hand side operands
LHSLEFT_OPERAND_IDENTIFIER VARCHAR2 480 The identification number of the left operand in the left hand side expression.
LHSLEFT_OPERAND_TYPE VARCHAR2 240 The data type of the left operand in the left hand side expression.
LHSLEFT_OPERAND_VS_FLAG VARCHAR2 3 This field is used to determine whether the left hand operand is associated to a valueset of not. If the value is 'Y' then the operand is associated to a valueset. If the value is 'N' the operand is not assocaited to a valueset.
LHSRGHT_OPERAND_IDENTIFIER VARCHAR2 480 The identification number of the right operand in the left hand side expression.
OPERATOR_CODE VARCHAR2 240 Represents the operator used in the expression.
RHS_OPERAND_TYPE VARCHAR2 240 The right hand side of the expression can be either an 'OPERAND' or a 'LITERAL'. This column is used to identify the type of the right hand side of the expression.
RHS_LITERAL_VALUE VARCHAR2 2000 The literal value used in the right hand side of the expression.
RHS_DATE_LITERAL_VALUE DATE This holds a literal date value on the right hand side of the criteria.
RHS_VALUESET_LITERAL_VALUE VARCHAR2 480 This column stores the literal value that the user has selected from the value set associated with the LHS left operand.
RHS_VALUESET_NUMBER_VALUE NUMBER This column stores the value that the user has selected from the value set of type number associated with the LHS left operand.
RHS_VALUESET_DATE_VALUE DATE This column stores the value that the user has selected from the value set of type date associated with the LHS left operand.
RHS_NUMBER_LITERAL_VALUE NUMBER This holds a literal number value on the right hand side of the criteria.
RHS_OPERAND_IDENTIFIER VARCHAR2 480 The identification number of the operand in the right hand side expression.
CASE_SENSITIVE_FLAG VARCHAR2 4 This column is used only when we are dealing with the operands of STRING type. If the value of this column is 'Y' then the operation should not take case into consideration. Otherwise the comparision should be case sensitive.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_QRY_CRITERIA_PK Unique Default CRITERIA_ID

ATK_QB_QRY_GRP_ATTRIBUTES

table for Query Group Attributes which is a subset of union of ContextAttibutes and ContextEntityAttributeReferences

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_QB_QRY_GRP_ATTRIBUTES_PK

ATTRIBUTE_ID

Columns

Name Datatype Length Precision Not-null Comments
QUERY_GROUP_ID NUMBER 18 Yes The id of the query group to which the attribute belongs.
ATTRIBUTE_ID NUMBER 18 Yes The unique id associated with the query group attribute.
ATTRIBUTE_TYPE VARCHAR2 240 Yes The type of the query group attribute that holds either CONTEXT or ENTITYATTRIBUTE.
REFERENCE_ATTRIBUTE_ID NUMBER 18 Yes The id of context attribute/entity attribute reference to which the query group attribute refers.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_QB_QRY_GRP_ATTRIBUTES atk_qb_query_group_b QUERY_GROUP_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_QRY_GRP_ATTRIBUTES_PK Unique Default ATTRIBUTE_ID

ATK_QB_QRY_GRP_RESULTS

table for QueryGroup Results which is subset of ContextResults

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_QB_QRY_GRP_RESULTS_PK

RESULT_ID

Columns

Name Datatype Length Precision Not-null Comments
QUERY_GROUP_ID NUMBER 18 Yes The id of the query group to which the result belongs.
RESULT_ID NUMBER 18 Yes The unique id associated with the query group result.
REFERENCE_RESULT_ID NUMBER 18 Yes Id of the Context Result to which the query group result refers
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_QB_QRY_GRP_RESULTS atk_qb_query_group_b QUERY_GROUP_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_QRY_GRP_RESULTS_PK Unique Default RESULT_ID

ATK_QB_QRY_RSLT_VALUES

table for Query Result's Values

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_QB_QRY_RSLT_VALUES_PK

RESULT_VALUE_ID

Columns

Name Datatype Length Precision Not-null Comments
RESULT_VALUE_ID NUMBER 18 Yes Primary key of the table.
QUERY_ID NUMBER 18 Yes The query to which this result belongs to.
RESULT_ID NUMBER 18 Yes The result to which this value is going to be assigned.
RESULT_VALUE VARCHAR2 2000 The actual result value of string data type to be returned.
NUMBER_RESULT_VALUE NUMBER Actual query/rule result value of number data type to be returned.
DATE_RESULT_VALUE DATE Actual query/rule result value of date data type to be returned.
ATTRIBUTE_REFERENCE_ID NUMBER 18 If the result value is based on a table column, then this column stores the id of the table column (i.e the entity attribute reference).
VALUESET_STRING_VALUE VARCHAR2 240 The result value of type string that the user selects from the valueset.
VALUESET_NUMBER_VALUE NUMBER Actual query/rule result value of type number that the user selects from the valueset.
VALUESET_DATE_VALUE DATE Actual query/rule result value of type date that the user selects from the valueset.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_QB_QRY_RSLT_VALUES atk_qb_cxt_results_b RESULT_ID
ATK_QB_QRY_RSLT_VALUES atk_qb_queries_b QUERY_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_QRY_RSLT_VALUES_PK Unique Default RESULT_VALUE_ID

ATK_QB_QUERIES_B

Base table for Queries/Rules defined for a QueryGroup/RuleGroup

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_QB_QUERIES_B_PK

QUERY_ID

Columns

Name Datatype Length Precision Not-null Comments
QUERY_ID NUMBER 18 Yes Primary key of the table.
QUERY_GROUP_ID NUMBER 18 Yes Represents the query group to which this query belongs to
QUERY_NAME VARCHAR2 240 Yes The internal name of the Query. Used to fetch the sql query.
ENABLED_FLAG VARCHAR2 3 Yes Determines whether the rule/query is disabled.
SEQUENCE_NUM NUMBER 18 Yes Is used when the queries have to be executed in a particular order. Used to order queries/rules.
SELECT_STATEMENT VARCHAR2 4000 Yes The compiled query is stored here. This will be returned to the product teams if they want to see the query.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
atk_qb_queries_tl atk_qb_queries_b QUERY_ID
atk_qb_qry_rslt_values atk_qb_queries_b QUERY_ID
atk_qb_qry_bindparams atk_qb_queries_b QUERY_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_QUERIES_B_PK Unique Default QUERY_ID

ATK_QB_QUERIES_TL

translation table for ATK_QB_QUERIES_B

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_QB_QUERIES_TL_PK

QUERY_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
QUERY_ID NUMBER 18 Yes Foreign key to the primary key of the base table.
QUERY_USER_NAME VARCHAR2 240 Yes The user name of the query.
QUERY_DESC VARCHAR2 240 Description of the query.
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated 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 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_QB_QUERIES_TL atk_qb_queries_b QUERY_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_QUERIES_TL_PK Unique Default QUERY_ID, LANGUAGE

ATK_QB_QUERY_GROUP_B

Table for QueryGroups/RuleGroups defined for a Context Object

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_QB_QUERY_GROUP_B_PK

QUERY_GROUP_ID

Columns

Name Datatype Length Precision Not-null Comments
QUERY_GROUP_ID NUMBER 18 Yes The unique/primary id associated with the query group
CONTEXT_ID NUMBER 18 Yes The context to which this query group belongs to.
QUERY_GROUP_NAME VARCHAR2 20 Yes The name associated with the query group.
MULTI_RULE_RESULT_FLAG VARCHAR2 4 Boolean flag to indicate, if the result from multiple matching rules in the query group is required.
USE_DEFAULT_RESULT_FLAG VARCHAR2 4 Boolean flag to indicate, whether the default result is expected for the query group.
IS_DEFAULT_RESULT_REQ_FLAG VARCHAR2 4 Boolean flag to indicate, if default result for the query group is required.
USE_CONTEXT_METADATA VARCHAR2 4 Yes Boolean flag to indicate, if the context metadata would be used for creating query groups.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
atk_qb_qry_grp_results atk_qb_query_group_b QUERY_GROUP_ID
atk_qb_query_group_tl atk_qb_query_group_b QUERY_GROUP_ID
atk_qb_default_rslt_vals atk_qb_query_group_b QUERY_GROUP_ID
atk_qb_qry_grp_attributes atk_qb_query_group_b QUERY_GROUP_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_QUERY_GROUP_B_PK Unique Default QUERY_GROUP_ID

ATK_QB_QUERY_GROUP_TL

Translation table for ATK_QB_QUERY_GROUP_B

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ATK_QB_QUERY_GROUP_TL_PK

QUERY_GROUP_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
QUERY_GROUP_ID NUMBER 18 Yes Id associated with the query group in the base table.
QUERY_GROUP_USER_NAME VARCHAR2 240 Yes The user-defined name associated with the query group.
QUERY_GROUP_DESC VARCHAR2 240 A brief description about the query group.
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated 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 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
ATK_QB_QUERY_GROUP_TL atk_qb_query_group_b QUERY_GROUP_ID

Indexes

Index Uniqueness Tablespace Columns
ATK_QB_QUERY_GROUP_TL_PK Unique Default QUERY_GROUP_ID, LANGUAGE

ATK_RPANE_REPORTS_MAPPINGS

ATK_RPANE_REPORTS_MAPPINGS Table

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ATK_RPANE_REPORTS_MAPPING_PK

REPORT_ID

Columns

Name Datatype Length Precision Not-null Comments
REPORT_ID NUMBER 18 Yes Unique identifer for reports that are mapped to the workarea
ENTERPRISE_ID NUMBER 18 Yes Tenant Enterprise Id.
WORKAREA_ID NUMBER 18 Yes WorkArea identifier to which reports are mapped.
REPORT_NAME VARCHAR2 840 Yes Report name which is mapped to the work area.
REPORT_PATH VARCHAR2 2000 Yes Destination of reports in BI Catalog.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
ATK_RPANE_REPORTS_MAPPINGS_PK Unique Default REPORT_ID

ATK_RPANE_WORKAREAS

Base Table for all ReportingPane workareas.

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key