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) |
Properties | Description |
---|---|
Tables | CI_DISP_PROF, CI_DISP_PROF_L |
Initial Data | North America (NORTHAM) and Europe (EURO) and HIJRI Format (HIJRI) Configuration Note: In order to use HIJRI Format display profile, additional configuration is needed to define the mappings between Hijri dates and Gregorian dates. Refer to the Display Profile documentation for more information. |
Properties | Description |
---|---|
Tables | F1_INSTALLATION, CI_INSTALL_ALG, CI_INSTALL_MSG, CI_INSTALL_MSG_L, CI_INSTALL_PROD |
Initial Data | Option 11111 |
Properties | Description |
---|---|
Tables | CI_LANGUAGE |
Initial Data | English (ENG) |
Properties | Description |
---|---|
Tables | CI_TIME_ZONE, CI_TIME_ZONE_L |
Initial Data | UTC |
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 |
Properties | Description |
---|---|
Tables | CI_ALG, CI_ALG_L, CI_ALG_PARM, CI_ALG_VER |
Standard Data Fields | Algorithm (ALG_CD) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | SC_APP_SERVICE, SC_APP_SERVICE_L, CI_APP_SVC_ACC |
Standard Data Fields | Application Service ID (APP_SVC_ID). |
Customer Modification | None |
Properties | Description |
---|---|
Tables | CI_BATCH_CTRL, CI_BATCH_CTRL_L, CI_BATCH_CTRL_P, CI_BATCH_CTRL_P_L |
Standard Data Fields | Batch Process (BATCH_CD), Program Name (PROGRAM_NAME) |
Customer Modification | Next Batch Number (NEXT_BATCH_NBR), Last Update Instance (LAST_UPDATE_INST), Last Update Date time (LAST_UPDATE_DTTM) and the batch process update these columns. Time Interval (TIMER_INTERVAL), Thread Count (BATCH_THREAD_CNT), Maximum Commit Records (MAX_COMMIT_RECS), User (USER_ID), Language (LANGUAGE_CD), Email Address (EMAILID), Start program debug tracing (TRC_PGM_STRT_SW), End Program Debug trace (TRC_PGM_END_SW), SQL debug tracing (TRC_SQL_SW) and Standard debug tracing (TRC_STD_SW) on CI_BATCH_CTRL Table. Batch Parameter Value (BATCH_PARM_VAL) and Security flag (TEXT_SECURITY_FLG) on Batch Control Parameters Table (CI_BATCH_CTRL_P) |
Properties | Description |
---|---|
Tables | F1_BUS_OBJ, F1_BUS_OBJ_L, F1_BUS_OBJ_ALG, F1_BUS_OBJ_OPT, F1_BUS_OBJ_STATUS, F1_BUS_OBJ_STATUS_L, F1_BUS_OBJ_STATUS_ALG, F1_BUS_OBJ_STATUS_OPT, F1_BUS_OBJ_STATUS_RSN, F1_BUS_OBJ_STATUS_RSN_L, F1_BUS_OBJ_STATUS_RSN_CHAR, F1_BUS_OBJ_TR_RULE, F1_BUS_OBJ_TR_RULE_L |
Standard Data Fields | Business Object (BUS_OBJ_CD), Status Reason (BO_STATUS_REASON_CD) |
Customer Modification | Batch Control (BATCH_CD), Alert (BO_ALERT_FLG), Sequence (SORT_SEQ5), Status Reason (STATUS_REASON_FLG) fields on Business Object Status Table (F1_BUS_OBJ_STATUS). Instance Control (INSTANCE_CTRL_FLG), Application Service (APP_SVC_ID) on Business Object Table (F1_BUS_OBJ). Status Reason Selection (STATUS_REASON_SELECT_FLG) on Status Reason Table (F1_BUS_OBJ_STATUS_RSN) |
Properties | Description |
---|---|
Tables | F1_BUS_SVC, F1_BUS_SVC_L |
Standard Data Fields | Business Service (BUS_SVC_CD) |
Customer Modification | Application Service (APP_SVC_ID) |
Properties | Description |
---|---|
Tables | CI_CHAR_TYPE, CI_CHAR_TYPE_L, CI_CHAR_ENTITY, CI_CHAR_VAL, CI_CHAR_VAL_L |
Standard Data Fields | Characteristic Type (CHAR_TYPE_CD) Characteristic Value (CHAR_VAL) on CI_CHAR_VAL If the characteristic type is customizable, Customer Modification can insert new characteristic values. CM must prefix when implementers introduce a new characteristic value. |
Customer Modification | Adhoc Characteristic Value Validation Rule (ADHOC_VAL_ALG_CD), Allow Search by Characteristic Value (SEARCH_FLG) |
Properties | Description |
---|---|
Tables | F1_MIGR_PLAN,F1_MIGR_PLAN_L,F1_MIGR_PLAN_INSTR,F1_MIGR_PLAN_INSTR_L, F1_MIGR_PLAN_INSTR_ALG, F1_MIGR_REQ, F1_MIGR_REQ_L, F1_MIGR_REQ_INSTR, F1_MIGR_REQ_INST R_L, F1_MIGR_REQ_INSTR_ENTITY, F1_MIGR_REQ_INCL_REQ |
Standard Data Fields | Migration Plan Code (MIGR_PLAN_CD), Migration Request Code (MIGR_REQ_CD) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | F1_DATA_AREA, F1_DATA_AREA_L |
Standard Data Fields | Data Area Code (DATA_AREA_CD) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | F1_DEPLOYMENT_PART, F1_DEPLOYMENT_PART_L, F1_DEPLOYMENT_ITEM |
Standard Data Fields | Deployment ID (F1_DEPLOYMENT_ID) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | CI_DISP_ICON, CI_DISP_ICON_L |
Standard Data Fields | Display Icon Code (DISP_ICON_CD) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | F1_EXT_LOOKUP_VAL, F1_EXT_LOOKUP_VAL_L, F1_EXT_LOOKUP_VAL_CHAR |
Standard Data Fields | Business Object (BUS_OBJ_CD), Extendable Lookup Value (F1_EXT_LOOKUP_VALUE) |
Customer Modification | Business Object Data Area (BO_DATA_AREA) Override Description (DESCR_OVRD) on Extendable Lookup Field Value Language Table (F1_EXT_LOOKUP_VAL_L) Note: When the product releases base owned records in Extendable Lookup, if there are additional elements the business object will map the element to the BO_DATA_AREA if the value is allowed to be modified by an implementation. |
Properties | Description |
---|---|
Tables | CI_FK_REF, CI_FK_REF_L |
Standard Data Fields | FK reference code (FK_REF_CD) |
Customer Modification | Info Program Name (INFO_PRG), Zone (ZONE_CD) |
Properties | Description |
---|---|
Tables | F1_IWS_SVC_L, F1_IWS_SVC, F1_IWS_SVC_OPER_L, F1_IWS_SVC_OPER, F1_IWS_SVC_OPER_PARM, F1_IWS_ANN_L, F1_IWS_ANN_PARM, F1_IWS_ANN, F1_IWS_ANN_TYPE_L, F1_IWS_ANN_TYPE, F1_IWS_ANN_TYPE_PARM, F1_IWS_ANN_TYPE_PARM_L |
Standard Data Fields | Webservice Name (IN_SVC_NAME), Annotation (ANN_CD), Annotation Type (ANN_TYPE_CD) |
Customer Modification | Debug (DEBUG_SW), Active (ACTIVE_SW), Trace (TRACE_SW), Request XSL (REQUEST_XSL), Response XSL (RESPONSE_XSL) |
Properties | Description |
---|---|
Tables | F1_LGCY_OBJ |
Standard Data Fields | Object ID (LGCY_OBJ_ID) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | CI_LOOKUP_FIELD, CI_LOOKUP_VAL, CI_LOOKUP_VAL_L |
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 may add lookup values to a Oracle Utilities Application Framework owned lookup field’s value. When extended new value is added, the Owner Flag is used to prefix the value. For example: When the Oracle Utilities Customer Care and Billing product adds a new value to the algorithm entity flag (ALG_ENTITY_FLG), it is prefixed with C1. |
Customer Modification | Override Description (DESCR_OVRD) on Lookup Field Value Language Table (CI_LOOKUP_VAL_L) |
Properties | Description |
---|---|
Tables | F1_MAP, F1_MAP_L |
Standard Data Fields | UI Map (MAP_CD) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | F1_MANAG_CONTENT, F1_MANAG_CONTENT_L |
Standard Data Fields | Managed Content (MANAG_CONTENT_CD) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | CI_MSG_CATEGORY, CI_MSG_CATEGORY_L, CI_MSG, CI_MSG_L |
Standard Data Fields | Message Category (MESSAGE_CAT_NBR) • Messages are grouped in categories and each category has message numbers between 1 and 99999. A range of message categories is assigned to a product. An implementation may only use categories assigned for customization use. • Implementer Message Categories are 80000 and 90000 • Reserved for Tests - 99999 Message Number (MESSAGE_NBR) for message categories • Message numbers below 1000 are reserved for common messages. Implementers must not use message numbers below 1000. Message Number (MESSAGE_NBR) for Java message categories • Subsystem Standard Messages - 00001 thru 02000 • Reserved - 02001 thru 09999 • Published Messages - 10001 thru 11000 • Package Messages - 10001 thru 90000 • Reserved - 90001 thru 99999 • Each package is allocated 100 message numbers, each starting from 101. • Published Messages are messages that are special-interest messages that implementations need to know about and are therefore published in the user docs. Examples of these include messages that are highly likely to be changed for an implementation, or messages that are embedded into other texts/messages and therefore the message number is never shown • Reserved message number ranges are for future use and therefore must not be used by all products. |
Customer Modification | Override Description (DESCRLONG_OVRD), Message Text Override (MESSAGE_TEXT_OVRD) |
Properties | Description |
---|---|
Tables | CI_MD_TBL, CI_MD_TBL_FLD, CI_MD_TBL_L, CI_MD_TBL_FLD_L, CI_MD_FLD, CI_MD_FLD_L, F1_DB_OBJECTS_REPO |
Standard Data Fields | Table Name (TBL_NAME) • Table names must match with the physical table name or view name in the database. • Field Name (FLD_NAME) Field name must match with the physical column name in the database unless the field is a work field. Field name does not have to follow the prefixing standard unless the field is a work field or customer modification field. • F1_DB_OBJECTS_REPO Table stores information about Indexes, Sequences, Triggers and other database objects excluding Tables and Fields (as they are already stored in the other Metadata tables) |
Customer Modification | Audit Switches (AUDIT_INSERT_SW, AUDIT_UPDATE_SW, AUDIT_DELETE_SW), Override label (OVRD_LABEL) on MD Table Field Table (CI_MD_TBL_FLD). Audit Program Name (AUDIT_PGM_NAME), Audit Table Name (AUDIT_TBL_NAME), Audit Program Type (AUDIT_PGM_TYPE_FLG), Key Validation (KEY_VALIDATION_FLG) and Caching strategy (CACHE_FLG) on MD Table (CI_MD_TBL). Override Label (OVRD_LABEL) and Customer Specific Description (DESCRLONG_OVRD) on Field Table. |
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_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 |
Standard Data Fields | Program Component Id (PROG_COM_ID), Location Id (LOC_ID), Program Component Name (PROG_COM_NAME), Service Name (SVC_NAME), Navigation Key (NAVIGATION_KEY) |
Customer Modification | User Exit Program Name (USER_EXIT_PGM_NAME) on Program Components Table (CI_MD_PRG_COM), |
Properties | Description |
---|---|
Tables | CI_MD_MO, CI_MD_MO_L, CI_MD_MO_TBL, CI_MD_MO_OPT, CI_MD_MO_ALG |
Standard Data Fields | Maintenance Object (MAINT_OBJ_CD) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | CI_MD_WRK_TBL, CI_MD_WRK_TBL_L, CI_MD_WRK_TBLFLD, CI_MD_MO_WRK |
Standard Data Fields | Work Table Name (WRK_TBL_NAME) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | CI_MD_SO, CI_MD_SO_L, CI_MD_SO_RSFLD, CI_MD_SO_RSFLDAT, CI_MD_SOCG, CI_MD_SOCG_FLD, CI_MD_SOCG_FLDAT, CI_MD_SOCG_L, CI_MD_SOCG_SORT |
Standard Data Fields | Search Object (SO_CD) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | F1_MOBILE_COMPONENT, F1_MOBILE_COMPONENT_L, F1_MOB_COMP_CNT, F1_MOBILE_COMP_CHAR |
Standard Data Fields | Mobile Component Code (F1_MOB_COMP_TYPE_CD) |
Customer Modification | Expiration Days (F1_EXPIRATION_TIME_DUR) |
Properties | Description |
---|---|
Tables | CI_NAV_OPT, CI_NAV_OPT_L, CI_NAV_OPT_CTXT, CI_NAV_OPT_USG, CI_MD_NAV |
Standard Data Fields | Navigation Option Code (NAV_OPT_CD), Navigation Key (NAVIGATION_KEY) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | F1_OUTMSG_TYPE, F1_OUTMSG_TYPE_L |
Standard Data Fields | Outbound Message Type Code (OUTMSG_TYPE_CD) |
Customer Modification | Priority (OUTMSG_PRIOR_FLG) |
Properties | Description |
---|---|
Tables | CI_PORTAL, CI_PORTAL_L, CI_PORTAL_ZONE, CI_PORTAL_OPT, CI_ZONE, CI_ZONE_L, CI_ZONE_PRM, CI_ZONE_HDL, CI_ZONE_HDL_L, CI_ZONE_HDL_PRM, CI_ZONE_HDL_PRM_L, CI_UI_ZONE |
Standard Data Fields | Portal Code (PORTAL_CD), Zone Code (ZONE_CD), Zone Type Code (ZONE_HDL_CD) • A new Zone can be added to the Product owned Portal Pages. • The existing Zones cannot be removed from the Product owned Portal Pages. |
Customer Modification | Sort Sequence (SORT_SEQ) on Context Sensitive Zone Table (CI_UI_ZONE). Show on Portal Preferences (USER_CONFIG_FLG) on Portal Table (CI_PORTAL). Override Sequence (SORT_SEQ_OVRD) on Portal Zone Table (CI_PORTAL_ZONE). Customer Specific Description (DESCRLONG_OVRD) on Zone Language Table (CI_ZONE_L). Override Parameter Value (ZONE_HDL_PARM_OVRD) on Zone Type Parameters Table (CI_ZONE_HDL_PRM). Override Parameter Value (ZONE_PARM_VAL_OVRD) on Zone Parameters Table (CI_ZONE_PRM). |
Properties | Description |
---|---|
Tables | F1_PROC_DEFN F1_PROC_DEFN_L F1_PROC_NEXT_PANEL F1_PROC_PANEL |
Standard Data Fields | Process Flow Type (PROCESS_CD) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | CI_SEQ |
Standard Data Fields | Sequence Name (SEQ_NAME) |
Customer Modification | Sequence Number (SEQ_NBR) This field is updated by the application process and must be set to 1 initially. |
Properties | Description |
---|---|
Tables | F1_SCHEMA |
Standard Data Fields | Schema Name (SCHEMA_NAME) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | CI_SCR, CI_SCR_L, CI_SCR_CRT, CI_SCR_CRT_GRP, CI_SCR_CRT_GRP_L, CI_SCR_DA, CI_SCR_FLD_MAP, CI_SCR_PRMPT, CI_SCR_PRMPT_L, CI_SCR_STEP, CI_SCR_STEP_L |
Standard Data Fields | Script (SCR_CD) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | CI_TD_TYPE, CI_TD_TYPE_L, CI_TD_SRTKEY_TY, CI_TD_DRLKEY_TY, CI_TD_SRTKEY_TY_L |
Standard Data Fields | To Do Type Code (TD_TYPE_CD) |
Customer Modification | Creation Batch Code (CRE_BATCH_CD), Route Batch Code (RTE_BATCH_CD), Priority Flag (TD_PRIORITY_FLG) on To Do Type Table (CI_TD_TYPE) |
Properties | Description |
---|---|
Tables | F1_WEB_CAT, F1_WEB_CAT_L, F1_WEB_CAT_INCL_SVC |
Standard Data Fields | Web Service Category code (WEB_SVC_CAT_CD) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | CI_XAI_ADAPTER, CI_XAI_ADAPTER_L, CI_XAI_CLASS, CI_XAI_CLASS_L, CI_XAI_ENV_HNDL, CI_XAI_ENV_HNDL_L, CI_XAI_FORMAT, CI_XAI_FORMAT_L, CI_XAI_RCVR, CI_XAI_RCVR_L, CI_XAI_RCVR_CTX, CI_XAI_RCVR_RSP, CI_XAI_RCVR_RGRP, CI_XAI_SENDER, CI_XAI_SERNDER_L, CI_XAI_SNDR_CTX, CI_XAI_OPTION |
Standard Data Fields | Adapter Id (XAI_ADAPTER_ID), Class Id (XAI_CLASS_ID), Envelope Handler Id (XAI_ENV_HNDL_ID), XAI Format Id (XAI_FORMAT_ID), Receiver Id (XAI_RCVR_ID), Sender Id (XAI_SENDER_ID) |
Customer Modification | Option Value (OPTION_VALUE) on Message Option Table (CI_XAI_OPTION) |
Properties | Description |
---|---|
Tables | CI_XAI_IN_SVC, CI_XAI_IN_SVC_L, CI_XAI_SVC_PARM |
Standard Data Fields | XAI Inbound Service Id (XAI_IN_SVC_ID), XAI Inbound Service Name (XAI_IN_SVC_NAME) |
Customer Modification | XAI Version (XAI_VERSION_ID), Trace (TRACE_SW), Debug (DEBUG_SW), Request XSL (INPUT_XSL), Response XSL (RESPONSE_XSL), Record XSL (RECORD_XSL and Post Error (POST_ERROR_SW) on XAI Inbound Service Table (CI_XAI_IN_SVC) |
Properties | Description |
---|---|
Tables | F1_IWS_SVC_OPER_PARM |
Standard Data Fields | Inbound Service Name (IN_SVC_NAME ) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | F1_MKTCFG |
Standard Data Fields | Market Configuration Code (MKTCFG_CD) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | F1_FILE_INT_REC, F1_FILE_INT_REC_L, F1_FILE_INT_REC_ALG, F1_FILE_INT_TYPE, F1_FILE_INT_TYPE_L |
Standard Data Fields | File Integration Record (FILE_INT_REC_CD), File Integration Type (FILE_INT_TYPE_CD) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | F1_MD_BI_TBL, F1_MD_BI_TBL_L, F1_MD_BI_TBL_FLD |
Standard Data Fields | Table Name (BI_TBL_NAME) |
Customer Modification | None |
Properties | Description |
---|---|
Tables | F1_DATA_EXPORT_CTRL, F1_DATA_EXPORT_CTRL_LOG, F1_DATA_EXPORT_CTRL_LOG_PARM |
Standard Data Fields | F1_DATA_EXPORT_CTRL (DATA_EXPORT_CD) |
Customer Modification | None |