Table 2-1 lists the database changes that were included in 6.0.16 and 6.2.0 patches, and the 6.2.1 release. There were no database changes made in the 6.0.15 patches. For changes delivered in patches, the build number where the change was first introduced is referenced. If you have installed 6.0.x or 6.2, refer to the build number to determine if you have already implemented the changes that are listed.
Table 2-1 Database Changes in 6.0.16 and 6.2.0 Patches, and the 6.2.1 Release
| Release | Prodfixsql File | Change | SQL |
|---|---|---|---|
|
6.0.16.b661 |
13112773.sql |
New Sequence |
CREATE SEQUENCE ASAP.SQ_NA_NET_LOC_SEQ increment by 1 START WITH '||(select nvl(max(na_net_loc_seq),0)+1 from asap.na_net_loc) || ' MAXVALUE 999999999999999999999999999 NOCYCLE noorder CACHE 20 / |
|
6.2.0.b210 |
12328184.sql |
New Table |
create table ASAP.ITEM_SPEC_EQUIP_SPEC_REL ( ITEM_SPEC_ID NUMBER(9,0) NOT NULL, EQUIPMENT_SPEC_ID NUMBER(9,0) NOT NULL, ISESR_SEQ NUMBER(3,0) NOT NULL, PRIORITY_SEQ NUMBER(2,0), LAST_MODIFIED_DATE DATE NOT NULL, LAST_MODIFIED_USERID VARCHAR2(32 BYTE) NOT NULL, CONSTRAINT PK_ITEM_SPEC_EQUIP_SPEC_REL PRIMARY KEY (ITEM_SPEC_ID, EQUIPMENT_SPEC_ID, ISESR_SEQ), CONSTRAINT FK_IT_SP_EQ_SP_REL__EQ_SP FOREIGN KEY (EQUIPMENT_SPEC_ID) REFERENCES ASAP.EQUIPMENT_SPEC (EQUIPMENT_SPEC_ID), CONSTRAINT FK_IT_SP_EQ_SP_REL__IT_SP FOREIGN KEY (ITEM_SPEC_ID) REFERENCES ASAP.ITEM_SPEC (ITEM_SPEC_ID) ) / |
|
6.2.0.b210 |
12328184.sql |
New Index |
CREATE INDEX ASAP.FKIDX_IT_SP_EQ_SP_REL_EQ_SP ON ASAP.ITEM_SPEC_EQUIP_SPEC_REL (EQUIPMENT_SPEC_ID) / CREATE UNIQUE INDEX ASAP.PK_ITEM_SPEC_EQUIP_SPEC_REL ON ASAP.ITEM_SPEC_EQUIP_SPEC_REL (ITEM_SPEC_ID, EQUIPMENT_SPEC_ID, ISESR_SEQ) / |
|
6.2.0.b210 |
12328184.sql |
New Table |
CREATE TABLE ASAP.STD_ITEM_EQUIP_SPEC_REL ( ITEM_TYPE_CD VARCHAR2(10 BYTE) NOT NULL, ITEM_CD VARCHAR2(10 BYTE) NOT NULL, ITEM_SEQ NUMBER(3,0) NOT NULL, EQUIPMENT_SPEC_ID NUMBER(9,0) NOT NULL, SIESR_SEQ NUMBER(3,0) NOT NULL, LAST_MODIFIED_DATE DATE NOT NULL, LAST_MODIFIED_USERID VARCHAR2(32 BYTE) NOT NULL, CONSTRAINT PK_STD_ITEM_EQUIP_SPEC_REL PRIMARY KEY (ITEM_TYPE_CD, ITEM_CD, ITEM_SEQ, SIESR_SEQ), CONSTRAINT FK_ST_IT_EQ_SP_REL__EQ_SP FOREIGN KEY (EQUIPMENT_SPEC_ID) REFERENCES ASAP.EQUIPMENT_SPEC (EQUIPMENT_SPEC_ID), CONSTRAINT FK_ST_IT_EQ_SP_REL__ST_IT FOREIGN KEY (ITEM_TYPE_CD, ITEM_CD, ITEM_SEQ) REFERENCES ASAP.STD_ITEM (ITEM_TYPE_CD, ITEM_CD, ITEM_SEQ)) / |
|
6.2.0.b210 |
12328184.sql |
New Index |
CREATE INDEX ASAP.FKIDX_ST_IT_EQ_SP_REL__EQ_SP ON ASAP.STD_ITEM_EQUIP_SPEC_REL (EQUIPMENT_SPEC_ID) / CREATE UNIQUE INDEX ASAP.PK_STD_ITEM_EQUIP_SPEC_REL ON ASAP.STD_ITEM_EQUIP_SPEC_REL (ITEM_TYPE_CD, ITEM_CD, ITEM_SEQ, SIESR_SEQ) / |
|
6.2.0.b213 |
11070076A.sql |
New Columns |
alter table ASAP.EVENT add EXPRESSION_VALUE VarChar2(4000) null / |
|
6.2.0.b217 |
12325004.sql |
New Columns |
alter table ASAP.SPECIAL_ACCESS add INT_PROTOCOL_ADDRESS_IDENT Char(1) null / alter table ASAP.SPECIAL_ACCESS add EGRESS_SCHEDULER Char(1) null / alter table ASAP.SPECIAL_ACCESS add PROFILE_EGRESS VarChar2(25) null / alter table ASAP.SPECIAL_ACCESS add PROFILE_INGRESS VarChar2(25) null / alter table ASAP.ASR_SRSI add INT_PROTOCOL_ADDRESS_IDENT Char(1) null / alter table ASAP.ACI_SRSI add INT_PROTOCOL_ADDRESS_IDENT Char(1) null / alter table ASAP.ACI_SRSI add EGRESS_SCHEDULER Char(1) null / alter table ASAP.ACI_SRSI add PROFILE_EGRESS VarChar2(25) null / alter table ASAP.ACI_SRSI add PROFILE_INGRESS VarChar2(25) null / alter table ASAP.FIRM_ORDER_CONFIRMATION add FRAME_DUE_TIME VarChar2(6) null / alter table ASAP.FIRM_ORDER_CONFIRMATION add TIME_ZONE_CODE CHAR(1) null / alter table ASAP.FIRM_ORDER_CONFIRMATION add CONF_BRIDGE_TEL_NO VarChar2(10) null / alter table ASAP.FIRM_ORDER_CONFIRMATION add CONF_BRIDGE_PASSCODE VarChar2(15) null / alter table ASAP.ASR_CONTACT_INFORMATION add MAINT_CONTACT_EMAIL VarChar2(60) null / |
|
6.2.0.b217 |
12325004.sql |
Modify Columns |
alter table ASAP.SPECIAL_ACCESS modify IP_ADDRESS VarChar2(39) / alter table ASAP.ASR_SRSI modify IP_ADDRESS VarChar2(39) / alter table ASR_CONTACT_INFORMATION modify CONF_BRIDGE_TEL_NO Varchar2(10) / alter table ASAP.ACI_SRSI modify IP_ADDRESS VarChar2(39) / |
|
6.2.0.b251 |
13331576.sql |
New Columns |
alter table ASAP.ACCESS_SERVICE_REQUEST add LOCATION_ID_JPR NUMBER(9) null / alter table ASAP.ACCESS_SERVICE_REQUEST add EARLY_DATE_ACCEPTANCE Char(1) null / alter table ASAP.FIRM_ORDER_CONFIRMATION add NETWORK_FACILITY_REQUIREMENT Char(1) null / alter table ASAP.END_USER_LOCATION_USAGE add LOCAL_CONTACT_EMAIL VarChar2(60) null / alter table ASAP.END_USER_LOCATION_USAGE add ADDL_ALT_CONTACT_TEL_NBR VarChar2(14) null / alter table ASAP.END_USER_LOCATION_USAGE add ALT_LOCAL_CONTACT_EMAIL VarChar2(60) null / alter table ASAP.EVC_UNI_MAP add EVC_MEET_POINT_ID VarChar2(42) null / |
|
6.2.0.b251 |
13331576.sql |
Modify Columns |
alter table ASAP.END_USER_LOCATION_USAGE modify ADDITIONAL_LOCATION_DETAILS VarChar2(150) / |
|
6.2.1 GA |
10071290. sql |
New Table |
alter table TASK add ( TASK_LABEL_2 VarChar2(255) null, TASK_LABEL_3 VarChar2(255) null, TASK_LABEL_4 VarChar2(255) null, TASK_LABEL_5 VarChar2(255) null, TASK_LABEL_6 VarChar2(255) null, TASK_LABEL_7 VarChar2(255) null, TASK_LABEL_8 VarChar2(255) null, TASK_LABEL_9 VarChar2(255) null, TASK_LABEL_10 VarChar2(255) null, TASK_LABEL_11 VarChar2(255) null, TASK_LABEL_12 VarChar2(255) null, TASK_LABEL_13 VarChar2(255) null, TASK_LABEL_14 VarChar2(255) null, TASK_LABEL_15 VarChar2(255) null, TASK_LABEL_16 Date null, TASK_LABEL_17 Date null, TASK_LABEL_18 Date null, TASK_LABEL_19 Date null, TASK_LABEL_20 Date null ) / |
|
6.2.1 GA |
10071290. sql |
Modify Columns |
alter table TASK modify TASK_LABEL VarChar2(255) / |
|
6.2.1 GA |
11732166.sql |
New Columns |
ALTER TABLE TASK ADD ( EXPEDITED_COMPLETION_DAYS NUMBER(2,0), EXPEDITED_COMPLETION_HOURS NUMBER(2,0), EXPEDITED_COMPLETION_MINUTES NUMBER(2,0) ) / ALTER TABLE PROVISIONING_PLAN_TASK ADD ( EXPEDITED_COMPLETION_DAYS NUMBER(2,0), EXPEDITED_COMPLETION_HOURS NUMBER(2,0), EXPEDITED_COMPLETION_MINUTES NUMBER(2,0) ) / ALTER TABLE BEHAVIOR_TASK_TYPE ADD ( EXPEDITED_COMPLETION_DAYS NUMBER(2,0), EXPEDITED_COMPLETION_HOURS NUMBER(2,0), EXPEDITED_COMPLETION_MINUTES NUMBER(2,0) ) / |
|
6.2.1 GA |
11904365.sql |
New Columns |
ALTER TABLE ASAP.GT_DSG_TRANS_CKT_CKT_POS ADD ( CKT_ALLOCATION_PARAMS VARCHAR2(100), NST_COMP_TYPE_CON_ID NUMBER(9) ) / |