Table | Name | Description |
F1_MST_CONFIG_CHAR | Master Configuration Characteristics | Future use only. |
F1_BUS_OBJ_STATUS_VW | Business Object Status View | New view populates status description with the override description (if populated) otherwise with the description. SQLs that need the BO status description can use this view instead of doing the work to check the override description. |
F1_BUS_OBJ_STATUS_RSN_VW | Status Reason View | New view populates status reason description with the override description (if populated) otherwise with the description. SQLs that need the BO status reason description can use this view instead of doing the work to check the override description. |
F1_PROD_METRIC_TYPE | Product Metric Type | Internal use only. |
F1_PROD_METRIC_TYPE_L | Product Metric Type Language | Internal use only. |
F1_PROD_METRIC_SNPSHT | Product Metric Snapshot | Internal use only. |
F1_PROD_METRIC_SNPSHT_K | Product Metric Snapshot Key | Internal use only. |
F1_PROD_METRIC_SNPSHT_VAL | Product Metric Values | Used to store Product Metric snapshot data |
CI_BATCH_CTRL_OPT | Batch Control Option | Used to store batch control option |
F1_PATCH_DETAILS | Patch Details | Internal Use Only. |
F1_ATTACHMENT_DATA | Store file detail information | Used to store file attachment information |
Table_Name | Column_Name | Data Type | Data Length |
|---|---|---|---|
F1_MIGR_REQ_INSTR | ENTITY_TAG | Varchar2 | 30 |
C1_TD_ENTRY | TD_SUB_STATUS_FLG | Flag | 4 |
C1_TD_LOG | TD_LOG_STATUS_FLG | Flag | 4 |
CI_TD_ENTRY | RTE_BATCH_CD | Character | 8 |
CI_TD_ENTRY | RTE_BATCH_NBR | Number | 10 |
F1_BUS_OBJ_STATUS_L | DESCR_OVRD | VARCHAR2 | 60 |
F1_BUS_OBJ_STATUS_RSN_L | DESCR_OVRD | VARCHAR2 | 60 |
F1_BUS_OBJ_TR_RULE_L | BO_NEXT_STATUS_OVRD_LBL | VARCHAR2 | 60 |
F1_MST_CONFIG | CONFIG_PART_NAME | VARCHAR2 | 254 |
F1_MST_CONFIG | CONFIG_CLS_FLG | CHAR | 4 |
CI_PORTAL | PORTAL_ROLE_FLG | CHAR | 4 |
CI_ZONE | ZONE_ROLE_FLG | CHAR | 4 |
CI_BATCH_CTRL | BATCH_TEMPLATE_XFLG | VARCHAR2 | 256 |
CI_BATCH_CTRL | BASE_BATCH_FLG | CHAR | 4 |
F1_REQ_TYPE | OWNER_FLG | CHAR | 4 |
F1_REQ_TYPE_L | OWNER_FLG | CHAR | 4 |
F1_ATTACHMENT | ATTCH_CONT_LOC_FLG | CHAR | 4 |
F1_ATTACHMENT | ATTCH_FILE_REF | VARCHAR2 | 2,000 |
Table_Name | Column_Name | Old Data Type | New Data Type |
|---|---|---|---|
F1_CRYPTO_KEY | PUBLIC_KEY | VARCHAR2(4000) | VARCHAR2(32767) |
CI_MD_IDX | IDX_CD | CHAR(12) | VARCHAR2 (128) |
CI_MD_IDX_FLD | IDX_CD | CHAR(12) | VARCHAR2 (128) |
F1_BUS_OBJ_STATUS_L | DESCR | Null | Space as default |
F1_BUS_OBJ_STATUS_L | OWNER_FLG | Null | Space as default |
F1_BUS_OBJ_STATUS_L | DESCRLONG | Null | Space as default |
F1_BUS_OBJ_STATUS_L | DESCR_OVRD | Null | Space as default |
F1_BUS_OBJ_STATUS_RSN_L | DESCR | Null | Space as default |
F1_BUS_OBJ_STATUS_RSN_L | OWNER_FLG | Null | Space as default |
F1_BUS_OBJ_STATUS_RSN_L | DESCRLONG | Null | Space as default |
F1_BUS_OBJ_STATUS_RSN_L | DESCR_OVRD | Null | Space as default |
F1_BUS_OBJ_TR_RULE_L | BO_NEXT_STATUS_LBL | Null | Space as default |
F1_BUS_OBJ_TR_RULE_L | OWNER_FLG | Null | Space as default |
F1_BUS_OBJ_TR_RULE_L | BO_NEXT_STATUS_OVRD_LBL | Null | Space as default |
Table | Index |
|---|---|
F1_TSPACE_ENTRY | FT001S1 (TSPACE_NAME, TSPACE_ENTRY_TY, TSPACE_ENTRY_ID) |
F1_MKTMSG_OUT | F1T782S3 (OUTMSG_ID) |
F1_MKTMSG_OUT | F1T782S4 (MKTPROC_ID) |
F1_MKTMSG_OUT | F1T782S5 (MKT_REG_NBR |
F1_BATCH_RUN_ANALYTICS_SNAP | F1T301S02 (END_DTTM, BATCH_CD, BATCH_NBR, BATCH_RERUN_NBR) |
F1_BATCH_RUN_ANALYTICS_SNAP | F1T301S03(BATCH_BUS_DT, BATCH_CD, BATCH_NBR, BATCH_RERUN_NBR) |
F1_BATCH_THD_ANALYTICS_SNAP | F1T401S02 (BATCH_BUS_DT, BATCH_CD, BATCH_NBR, BATCH_RERUN_NBR, BATCH_THREAD_NBR) |
F1_BATCH_THD_ANALYTICS_SNAP | F1T401S03 (START_DTTM, BATCH_CD, BATCH_NBR, BATCH_RERUN_NBR, BATCH_THREAD_NBR) |
CI_TD_ENTRY | XT039S9 (RTE_BATCH_CD,RTE_BATCH_NBR,ENTRY_STATUS_FLG) |
F1_OUTMSG | FT010S2 (NT_XID_CD, CRE_DTTM, OUTMSG_STATUS_FLG) |
CI_MD_CONST_FLD | XC617S1 |
CI_MD_MO_TBL | XC079S2 |
F1_ERASURE_SCHED | F1T756S2 |
XT028S2(END_DTTM, START_DTTM, BAT CH_NBR, BATCH_RERUN_NBR, BATCH_CD) | CI_BATCH_RUN |
F1T681S2(MAINT_OBJ_CD, PK_VALUE1, PK_VALUE2, BUS_FLG_ID) | F1_BUS_FLG |
Table_Name | View_Name | Description |
|---|---|---|
F1_BUS_OBJ_STATUS_VW | Business Object Status View | New view populates status description with the override description (if populated) otherwise with the description. SQLs that need the BO status description can use this view instead of doing the work to check the override description. |
F1_BUS_OBJ_STATUS_RSN_VW | Status Reason View | New view populates status reason description with the override description (if populated) otherwise with the description. SQLs that need the BO status reason description can use this view instead of doing the work to check the override description. |
F1_SIBSCH_TBLS_VW | Sibling Schema Tables | This is for internal processing. |
View_Name | Changes |
|---|---|
CI_TD_ENTRY_OPEN_VW | New Field: TD_SUB_STATUS_FLG |
F1_BATCH_RUN_HIST_VW | Used with New Batch Analytics Views feature. |
F1_BATCH_THD_HIST_VW | Used with New Batch Analytics Views feature. |
F1_BATCH_CONF_VW | Used with New Batch Analytics Views feature. |
F1_BATCH_THD_CAP_VW | Used with New Batch Analytics Views feature. |
CI_USR_ACC_GRP_VW | Added DISTINCT clause to the SELECT query |
Table_Name | Old Fields | New Fields |
F1_WEB_CAT_INCL_SVC | “WEB_SVC_CAT_CD”, “SEQNO” | “WEB_SVC_CAT_CD”, “SEQNO”, “OWNER_FLG” |