Technical data

Guidelines for System Table Updates
Oracle Application Framework System Table Guide C-5
To Do Priority and Role
New To Do Types released will be linked to the default To Do Role and set to the product
assigned priority value initially. These initial settings can be overridden by the implementation.
Development and Implementation System Tables
This section defines the standards for the system tables that contain data for application
development. The data in these tables implement business logic and UI functions shared by
various products and product extensions in the same database.
Standards
When adding new data, the owner flag value of the environment must prefix certain fields of these
tables. For example, when a developer adds a new algorithm type to an Oracle Utilities Customer
Care and Billing environment, C1 should prefix the new Algorithm Type code. The fields that are
subject to this rule are listed in Standard Data Fields property.
The data that is already in these tables cannot be modified if the data owner is different than the
environment owner. This prevents the developers from accidentally modifying system data that
belongs to the Oracle Utilities application framework or the base products. However, some fields
are exempt from this rule and can be modified by Customer Modification. These fields are listed
in the Customer Modification Fields property.
Starting with version 2.2 of the framework a new system data upgrade rule was introduced -
Override Owner flag. If duplicate data rows (data row with same primary key values) are found at
the time of upgrade, the owner flag values will get overridden. The lower level application system
data will override the upper level system data. For example, F1 overrides C1, F1&C1 override CM,
and so on. This rule will be applied to the following tables: CI_CHAR_ENTITY,
CI_MD_MO_ALG, F1_BUS_OBJ_ALG, F1_BUS_OBJ_STATUS_ALG, CI_MD_MO_OPT,
F1_BUS_OBJ_OPT, F1_BUS_OBJ_STATUS_OPT, F1_BUS_OBJ_STATUS,
F1_BUS_OBJ_STATUS_L
Algorithm Type
Properties Description
Tables CI_ROLE(L), CI_TD_VAL_ROLE
Initial Data F1_DFLT
Properties Description
Tables CI_ALG_TYPE, CI_ALG_TYPE_L,
CI_ALG_TYPE_PRM,
CI_ALG_TYPE_PRM_L
Standard Data Fields Algorithm Type (ALG_TYPE_CD)
Customer Modification None