Technical data

Guidelines for System Table Updates
Oracle Application Framework System Table Guide C-3
Guidelines for System Table Updates
This section describes guidelines regarding the updating of the system table properties.
Business Configuration Tables
The majority of data in the tables in this group belongs to the customer. But these tables are
shipped with some initial data in order for the customer to login to the system and begin
configuring the product. Unless specified otherwise, the initial data is maintained by Oracle
Utilities Application Framework and subject to subsequent upgrade.
Application Security and User Profile
These tables define the access rights of a User Group to Application Services and Application
Users.
Developer's Note: When a new service is added to the system, all actions
defined for the service must be made available to the User Group All
SERVICES.
Currency Code
The ISO 4217 three-letter codes are taken as the standard code for the representation of each
currency.
Properties Description
Tables SC_ACCESS_CNTL, SC USER,
SC_USR_GRP_PROF,
SC_USR_GRP_USR, SC_USER_GROUP,
SC_USER_GROUP_L
Initial Data User Group All SERVICES and default
system user SYSUSER. Upon installation
the system default User Group All
SERVICES is given unrestricted accesses
to all services defined in Oracle Utilities
Application Framework.
Properties Description
Tables CI_CURRENCY_CD,
CI_CURRENCY_CD_L
Initial Data United States Dollar (USD).