Technical data

Guidelines for System Table Updates
Oracle Application Framework System Table Guide C-13
Meta Data - Constraints
Meta Data - Menu
Menus can be extended to support multiple products by adding a new menu line to an existing
menu. The sequence number on the menu line language table (CI_MD_MENU_LINE_L)
determines the order the menu lines appear. Within the same sequence, alphabetic sorting is used.
Meta Data - Program, Location and Services
Properties Description
Tables CI_MD_CONST, CI_MD_CONST_FLD
Standard Data Fields Constraint Id (CONST_ID)
• Index Name for Primary Constraints
• <Index Name>Rnn for Foreign Key
Constraints Where
• nn: integer, 01 through 99
Customer Modification None
Properties Description
Tables CI_MD_MENU, CI_MD_MENU_L,
CI_MD_MENU_ITEM,
CI_MD_MENU_ITEM_L,
CI_MD_MENU_LINE,
CI_MD_MENU_LINE_L
Standard Data Fields Menu Name (MENU_NAME), Menu Item
Id (MENU_ITEM_ID), Menu Line Id
(MENU_LINE_ID)
Customer Modification Override Label (OVRD_LABEL) on
Menu Line Language Table
(CI_MD_MENU_LINE_L)
Properties Description
Tables CI_MD_PRG_COM,
CI_MD_PRG_LOC, CI_MD_SVC,
CI_MD_SVC_L, CI_MD_SVC_PRG,
CI_MD_PRG_REF, CI_MD_PRG_MOD,
CI_MD_PRG_EL_AT,
CI_MD_PRG_ELEM,
CI_MD_PRG_SEC, CI_MD_PRG_SQL,
CI_MD_PRG_VAR, CI_MD_PRG_TAB