This section contains the names of system tables, upgrade actions, and a brief description of the tables. The upgrade actions are explained below.
Keep (KP): The data of the table in the customer's database is kept untouched. No insert or delete is performed to this table by the upgrade process. The initial installation will add necessary data for the system
Merge (MG): The non-base product data of the table in the database is kept untouched. If the data belongs to the base product, any changes pertaining to the new version of the software are performed.
Refresh (RF): The existing data in the table is replaced with the data from the base product table.
New product data is also inserted into tables marked as 'Merge'. If implementers add rows for a customer specific enhancement, it can cause duplication when the system data gets upgraded to the next version. We strongly recommend following the guidelines on how to use designated range of values or prefixes to segregate the implementation data from the base product data.
Table Name |
Upgrade Action |
Description |
---|---|---|
CI_ALG |
MG |
Algorithm |
CI_ALG_L |
MG |
Algorithm Language |
CI_ALG_PARM |
MG |
Algorithm Parameters |
CI_ALG_TYPE |
MG |
Algorithm Type |
CI_ALG_TYPE_L |
MG |
Algorithm Type Language |
CI_ALG_TYPE_PRM |
MG |
Algorithm Type Parameter |
CI_ALG_TYPE_PRM_L |
MG |
Algorithm Type Parameter Language |
CI_ALG_VER |
MG |
Algorithm Version |
CI_APP_SVC_ACC |
MG |
Application Service Access Mode |
CI_BATCH_CTRL |
MG |
Batch Control |
CI_BATCH_CTRL_L |
MG |
Batch Control Language |
CI_BATCH_CTRL_P |
MG |
Batch Control Parameters |
CI_BATCH_CTRL_P_L |
MG |
Batch Control Parameters Language |
CI_CHAR_ENTITY |
MG |
Characteristic Type Entity |
CI_CHAR_TYPE |
MG |
Characteristic Type |
CI_CHAR_TYPE_L |
MG |
Characteristic Type Language |
CI_CHAR_VAL |
MG |
Characteristic Type Value |
CI_CHAR_VAL_L |
MG |
Characteristic Type Value Language |
CI_DISP_ICON |
MG |
Display Icon |
CI_DISP_ICON_L |
MG |
Display Icon Language |
CI_FK_REF |
MG |
Foreign Key Reference |
CI_FK_REF_L |
MG |
Foreign Key Reference Language |
CI_LANGUAGE |
MG |
Language Code |
CI_LOOKUP_FIELD |
MG |
Lookup Field |
CI_LOOKUP_VAL |
MG |
Lookup Field Value |
CI_LOOKUP_VAL_L |
MG |
Lookup Field Value Language |
CI_MD_ATT_TY |
RF |
MD Element Attribute Type |
CI_MD_AT_DTL |
RF |
MD Element Attribute Type Detail |
CI_MD_AT_DTL_L |
RF |
MD Element Attribute Type Detail Language |
CI_MD_CONST |
MG |
Constraints |
CI_MD_CONST_FLD |
MG |
Constraint Fields |
CI_MD_CTL |
RF |
Generator Control |
CI_MD_CTL_L |
RF |
Generator Control Language |
CI_MD_CTL_TMPL |
RF |
Generator Control Template |
CI_MD_ELTY |
RF |
MD Element Type |
CI_MD_ELTY_AT |
RF |
Element Type Attributes |
CI_MD_ELTY_L |
RF |
Element Type Language |
CI_MD_FLD |
MG |
Field |
CI_MD_FLD_L |
MG |
Field Language |
CI_MD_LOOKUP |
RF |
MD Lookup Field Value |
CI_MD_LOOKUP_F |
RF |
MD Lookup Field |
CI_MD_MENU |
MG |
Menu Information |
CI_MD_MENU_IMOD |
MG |
Menu Item Module Maint |
CI_MD_MENU_ITEM |
MG |
Menu Item |
CI_MD_MENU_ITEM_L |
MG |
Menu Item Language |
CI_MD_MENU_L |
MG |
Menu Language |
CI_MD_MENU_LINE |
MG |
Menu Line |
CI_MD_MENU_LINE_L |
MG |
Menu Line Language |
CI_MD_MENU_MOD |
MG |
Menu Product Components |
CI_MD_MO |
MG |
Maintenance Object |
CI_MD_MO_ALG |
MG |
Maintenance Object Algorithm |
CI_MD_MO_L |
MG |
Maintenance Object Language |
CI_MD_MO_OPT |
MG |
Maintenance Object Option |
CI_MD_MO_TBL |
MG |
Maintenance Object Table |
CI_MD_MO_WRK |
MG |
Maintenance Object Work Tables |
CI_MD_MSG |
RF |
MD Message |
CI_MD_MSG_L |
RF |
MD Message Language |
CI_MD_NAV |
MG |
Navigation Key |
CI_MD_PDF |
RF |
Predefined Fields |
CI_MD_PDF_VAL |
RF |
Predefined Values |
CI_MD_PRG_COM |
MG |
Program Components |
CI_MD_PRG_ELEM |
MG |
UI Page Elements |
CI_MD_PRG_EL_AT |
MG |
UI Page Element Attributes |
CI_MD_PRG_LOC |
MG |
Program Location |
CI_MD_PRG_MOD |
MG |
Program Module |
CI_MD_PRG_SEC |
MG |
UI Page Sections |
CI_MD_PRG_SQL |
MG |
MD SQL Meta Data |
CI_MD_PRG_TAB |
MG |
UI Tab Meta Data |
CI_MD_PRG_VAR |
MG |
Program Variable |
CI_MD_SO |
MG |
Search Object |
CI_MD_SOCG |
MG |
Search Object Criteria Group |
CI_MD_SOCG_FLD |
MG |
Search Object Criteria Group Field |
CI_MD_SOCG_FLDAT |
MG |
Search Object Criteria Group Field Attribute |
CI_MD_SOCG_L |
MG |
Search Object Criteria Group Language |
CI_MD_SOCG_SORT |
MG |
Search Object Criteria Group Result Sort Order |
CI_MD_SO_L |
MG |
Search Object Language |
CI_MD_SO_RSFLD |
MG |
Search Object Result Field |
CI_MD_SO_RSFLDAT |
MG |
Search Object Result Field Attribute |
CI_MD_SRC_TYPE |
RF |
Source Type |
CI_MD_SRC_TYPE_L |
RF |
Source Type Language |
CI_MD_SVC |
MG |
MD Service |
CI_MD_SVC_L |
MG |
MD Service Language |
CI_MD_SVC_PRG |
MG |
MD Service Program |
CI_MD_TAB_MOD |
MG |
UI Tab Module |
CI_MD_TBL |
MG |
MD Table |
CI_MD_TBL_FLD |
MG |
MD Table Field |
CI_MD_TBL_FLD_L |
MG |
MD Table Field Language |
CI_MD_TBL_L |
MG |
MD Table Language |
CI_MD_TMPL |
RF |
Template |
CI_MD_TMPL_ELTY |
RF |
Template Element Types |
CI_MD_TMPL_L |
RF |
Template Language |
CI_MD_TMPL_VAR |
RF |
Template Variable |
CI_MD_TMPL_VAR_L |
RF |
Template Variable Language |
CI_MD_VAR |
RF |
Variable |
CI_MD_VAR_DTL |
RF |
Variable Detail |
CI_MD_VAR_DTL_L |
RF |
Variable Detail Language |
CI_MD_WRK_TBL |
MG |
Work Table |
CI_MD_WRK_TBLFLD |
MG |
Work Table Field |
CI_MD_WRK_TBL_L |
MG |
Work Table Language |
CI_MSG |
MG |
Message |
CI_MSG_CATEGORY |
MG |
Message Category |
CI_MSG_CATEGORY_L |
MG |
Message Category Language |
CI_MSG_L |
MG |
Message Language |
CI_NAV_OPT |
MG |
Navigation Option |
CI_NAV_OPT_CTXT |
MG |
Navigation Option Context |
CI_NAV_OPT_L |
MG |
Navigation Option Language |
CI_NAV_OPT_USG |
MG |
Navigation Option Usage |
CI_PORTAL |
MG |
Portal Page |
CI_PORTAL_L |
MG |
Portal Page Language |
CI_PORTAL_ZONE |
MG |
Portal Zone |
CI_SCR |
MG |
Script |
CI_SCR_CRT |
MG |
Script Criteria |
CI_SCR_CRT_GRP |
MG |
Script Criteria Group |
CI_SCR_CRT_GRP_L |
MG |
Script Criteria Group Language |
CI_SCR_DA |
MG |
Script Data Area |
CI_SCR_FLD_MAP |
MG |
Script Field Mapping |
CI_SCR_L |
MG |
Script Language |
CI_SCR_PRMPT |
MG |
Script Prompt |
CI_SCR_PRMPT_L |
MG |
Script Prompt Language |
CI_SCR_STEP |
MG |
Script Step |
CI_SCR_STEP_L |
MG |
Script Step Language |
CI_SEQ |
MG |
Sequence |
CI_TD_DRLKEY_TY |
MG |
To Do Type Drill Key |
CI_TD_SRTKEY_TY |
MG |
To Do Type Sort Key |
CI_TD_SRTKEY_TY_L |
MG |
To Do Type Sort Key Language |
CI_TD_TYPE |
MG |
To Do Type |
CI_TD_TYPE_L |
MG |
To Do Type Language |
CI_XAI_ADAPTER |
MG |
XAI Adapter |
CI_XAI_ADAPTER_L |
MG |
XAI Adapter Lang |
CI_XAI_CLASS |
MG |
XAI Class |
CI_XAI_CLASS_L |
MG |
XAI Class Language |
CI_XAI_ENV_HNDL |
MG |
XAI Envelope Handler |
CI_XAI_ENV_HNDL_L |
MG |
XAI Envelope Handler Language |
CI_XAI_EXECUTER |
RF |
XAI Executer |
CI_XAI_EXECUTER_L |
RF |
XAI Executer Language |
CI_XAI_FORMAT |
RF |
XAI Format |
CI_XAI_FORMAT_L |
RF |
XAI Format Language |
CI_XAI_IN_SVC |
MG |
XAI Inbound Service |
CI_XAI_IN_SVC_L |
MG |
XAI Inbound Service Language |
CI_XAI_SVC_PARM |
MG |
XAI Inbound Service Parameters |
CI_XAI_SVC_VERS |
MG |
XAI Inbound Service Version |
CI_XAI_SVC_VERS_L |
MG |
XAI Inbound Service Version Language |
CI_ZONE |
MG |
Zone |
CI_ZONE_HDL |
MG |
Zone Type |
CI_ZONE_HDL_L |
MG |
Zone Type Language |
CI_ZONE_HDL_PRM |
MG |
Zone Type Parameters |
CI_ZONE_HDL_PRM_L |
MG |
Zone Type Parameters Language |
CI_ZONE_L |
MG |
Zone Language |
CI_ZONE_PRM |
MG |
Zone Parameters |
F1_BUS_OBJ |
MG |
Business Object |
F1_BUS_OBJ_ALG |
MG |
Business Object Algorithm |
F1_BUS_OBJ_L |
MG |
Business Object Language |
F1_BUS_OBJ_OPT |
MG |
Business Object Option |
F1_BUS_OBJ_STATUS |
MG |
Business Object Status |
F1_BUS_OBJ_STATUS_ALG |
MG |
Business Object Status Algorithm |
F1_BUS_OBJ_STATUS_L |
MG |
Business Object Status Language |
F1_BUS_OBJ_STATUS_OPT |
MG |
Business Object Status Option |
F1_BUS_OBJ_TR_RULE |
MG |
Business Object Transition Rule |
F1_BUS_OBJ_TR_RULE_L |
MG |
Business Object Transition Rule Language |
F1_BUS_SVC |
MG |
Business Service |
F1_BUS_SVC_L |
MG |
Business Service Language |
F1_DATA_AREA |
MG |
Data Area |
F1_DATA_AREA_L |
MG |
Data Area Language |
F1_MAP |
MG |
UI Map |
F1_MAP_L |
MG |
UI Map Language |
F1_SCHEMA |
MG |
Schema |
SC_ACCESS_CNTL |
MG |
User Group Access Control |
SC_APP_SERVICE |
MG |
Application Service |
SC_APP_SERVICE_L |
MG |
Application Service Language |
SC_USR_GRP_PROF |
MG |
User Group Profile |
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.