Technical data

Guidelines for System Table Updates
Oracle Application Framework System Table Guide C-9
A new Feature option is defined through adding a value to EXT_SYS_TYP_FLG. The field value
for this look up field must be prefixed by the Owner flag value.
Map
Standard Data Fields Field Name (FIELD_NAME)
• A lookup field name must have
corresponding field metadata. The
name of the lookup field column must
be assigned to avoid conflicts among
different products. If you follow the
standards for database field names, a
Customer Modification lookup field
name will be automatically Customer
Modification prefixed.
Field Value (FIELD_VALUE)
• If a lookup field is customizable,
Customer Modification can insert new
lookup values. X or Y must prefix
when implementers introduce a new
lookup value.
• Product development can extend the
Oracle Utilities Application
Framework owned lookup field's value
with caution. When it needs to be
extended, prefix the first letter of the
Owner Flag to the value. For example,
when adding a new value to the
algorithm entity flag
(ALG_ENTITY_FLG), prefix with
C1 if you are developing an Oracle
Utilities Customer Care and Billing
product.
Introduced in V 4.0.1:
Value (F1_EXT_LOOKUP_VALUE)
• This will allow storing longer value
keys rather than the normal 4byte
lookup values.
Customer Modification Override Description (DESCR_OVRD)
on Lookup Field Value Language Table
(CI_LOOKUP_VAL_L)
Properties Description
Properties Description
Tables F1_MAP, F1_MAP_L
Standard Data Fields UI Map (MAP_CD)
Customer Modification None