1. Tables and Views for Sales and Fusion Service
  2. ZOE_OL_CFGFILES

ZOE_OL_CFGFILES

This table stores the following files defined by iCRM: 1 Outlook client configuration xml file : the customization xml files used by iCRM. There are 9 types of them plus localization files for supported languages 2 XSD for outlook client configuration file : the schema definition for the 9 types of metadata xml files. It is used for validation. 3 Outlook server configuration xml file. It is for internal use only.

Details

  • Schema: FUSION

  • Object owner: ZOE

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ZOE_OL_CFGFILES_PK

DOC_GUID

Columns

Name Datatype Length Precision Not-null Comments
DOC_GUID VARCHAR2 64 Yes guid of the Outlook Config File, primary key of the table
DOC_TYPE VARCHAR2 30 Yes file type defined in FND_LOOKUP for ZOE. This column is used to differentiate whether it's outlook client configuration xml file, or XSD file or server configuration file
DOC_NAME VARCHAR2 800 Yes name of the Outlook Config File.
DOC_COMMENT VARCHAR2 4000 comments of the Outlook Config File.
DOC_SIZE NUMBER size of the Outlook Config File.
DOC_SOURCE BLOB Yes the content of the Outlook Config File
DOC_HASHVALUE VARCHAR2 200 document MD5 hash value, typically expressed as a 32 digit hexadecimal number. It is required for xml files(enforced by our program) but not for other non-xml files.
EFFECTIVE_START_DATE DATE Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
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.
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.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table Foreign Table Foreign Key Column
zoe_ol_dpmpkg_files zoe_ol_cfgfiles DOC_GUID
zoe_ol_filemappings zoe_ol_cfgfiles XSD_DOC_GUID

Indexes

Index Uniqueness Tablespace Columns
ZOE_OL_CFGFILES_N1 Non Unique Default DOC_TYPE
ZOE_OL_CFGFILES_PK Unique Default DOC_GUID, ORA_SEED_SET1
ZOE_OL_CFGFILES_PK1 Unique Default DOC_GUID, ORA_SEED_SET2
ZOE_OL_CFGFILES_UK1 Unique Default DOC_NAME, ORA_SEED_SET1
ZOE_OL_CFGFILES_UK11 Unique Default DOC_NAME, ORA_SEED_SET2