Oracle® Communications MetaSolv Solution

Database Change Reference

Release 6.2.1

E41393-04

July 2017

Oracle Communications MetaSolv Solution Database Change Reference, Release 6.2.1

E41393-04

Copyright © 2017, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Contents

Preface

- Audience

- Related Documents

- Documentation Accessibility

1 Database Changes in 6.2.1 Patches

2 Database Changes in 6.2.1 GA

3 Database Changes in 6.2

Preface

This document contains the database changes for the Oracle Communications MetaSolv Solution (MSS) 6.2.1 release. Database changes for each subsequent maintenance releases will be added to this guide as they are released.

Audience

This document is for database administrators responsible for installing or maintaining MSS and ensuring the software is operating as required.

Related Documents

For more information, see the following documents in the MSS 6.2.1 documentation set:

- MSS Planning Guide: Describes information you need to consider in planning your MetaSolv Solution environment prior to installation.

- MSS Installation Guide: Describes system requirements and installation procedures for installing MetaSolv Solution.

- MSS System Administrator's Guide: Describes post-installation tasks and administrative tasks such as maintaining user security.

- MSS Network Grooming User's Guide: Provides information about the MSS Network Grooming tool.

- MSS Technology Module Guide: Describes each of the MetaSolv Solution technology modules.

- MSS Data Selection Tool How-to Guide: Provides an overview of the Data Selection Tool, and procedures on how it used to migrate the product catalog, equipment specifications, and provisioning plans from one release of your environment to another.

- MSS Operational Reports: Provides an overview of using Operational Reports and Business Objects with MSS, and procedures for running reports, updating universes, and simple maintenance.

- MSS CORBA API Developer's Reference: Describes how MetaSolv Solution APIs work, high-level information about each API, and instructions for using the APIs to perform specific tasks.

- MSS Custom Extensions Developer's Reference: Describes how to extend the MetaSolv Solution business logic with custom business logic through the use of custom extensions.

- MSS XML API Developer's Reference: Describes how to integrate MetaSolv Solution with other Oracle products, or with external applications, through the use of APIs.

- MSS Flow-through Packages Guide: Describes information and procedures you need to install and work with the flow-through packages provided by Oracle as an example of how to integrate MetaSolv Solution with ASAP for flow-through activation.

For step-by-step instructions for tasks you perform in MSS, log into the application to see the online Help.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

1 Database Changes in 6.2.1 Patches

Table 1-1 lists the database changes that were included in 6.2.1 patches. The build number where the change was first introduced is referenced.

Table 1-1 Database Changes in 6.2.1 Patches

Release

Prodfixsql File

Change

SQL

6.2.1.b240

13463161.SQL

Modify Columns

alter table ASAP.NETWORK_NODE modify IP_ADDRESS VarChar2(39)

6.2.1.b240

13463161.SQL

New Columns

alter table ASAP.NI_IP_ADDR add IPV6NETWORK_TYPE Char(1) null

6.2.1.b240

13463161.SQL

New Columns

alter table ASAP.NI_IP_ADDR add IPV6NODE_1 VarChar2(4) null

6.2.1.b240

13463161.SQL

New Columns

alter table ASAP.NI_IP_ADDR add IPV6NODE_2 VarChar2(4) null

6.2.1.b240

13463161.SQL

New Columns

alter table ASAP.NI_IP_ADDR add IPV6NODE_3 VarChar2(4) null

6.2.1.b240

13463161.SQL

New Columns

alter table ASAP.NI_IP_ADDR add IPV6NODE_4 VarChar2(4) null

6.2.1.b240

13463161.SQL

New Columns

alter table ASAP.NI_IP_ADDR add IPV6NODE_5 VarChar2(4) null

6.2.1.b240

13463161.SQL

New Columns

alter table ASAP.NI_IP_ADDR add IPV6NODE_6 VarChar2(4) null

6.2.1.b240

13463161.SQL

New Columns

alter table ASAP.NI_IP_ADDR add IPV6NODE_7 VarChar2(4) null

6.2.1.b240

13463161.SQL

New Columns

alter table ASAP.NI_IP_ADDR add IPV6NODE_8 VarChar2(4) null

6.2.1.b240

13949971.SQL

Modify Columns

alter table ASAP.SPECIAL_ACCESS modify PROFILE_EGRESS VarChar2(30)

alter table ASAP.SPECIAL_ACCESS modify PROFILE_INGRESS VarChar2(30)

alter table ASAP.ACI_SRSI modify PROFILE_EGRESS VarChar2(30)

alter table ASAP.ACI_SRSI modify PROFILE_INGRESS VarChar2(30)

6.2.1.b240

13949971.SQL

New Columns

alter table ASAP.SPECIAL_ACCESS add BUM_OPTION CHAR(1) null

alter table ASAP.SPECIAL_ACCESS add BUNDLING_INDICATOR CHAR(1) null

alter table ASAP.ACI_SRSI add BUM_OPTION CHAR(1) null

alter table ASAP.ACI_SRSI add BUNDLING_INDICATOR CHAR(1) null

alter table ASAP.EVC_UNI_MAP add OEC_TERMINATING VarChar2(4) null

alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT CHAR(1) null

alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT_1 CHAR(1) null

alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT_2 CHAR(1) null

alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT_3 CHAR(1) null

alter table ASAP.EVC_UNI_MAPadd CUST_EDGE_VACT_4 CHAR(1) null

alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT_5 CHAR(1) null

alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT_6 CHAR(1) null

alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT_7 CHAR(1) null

alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT_8 CHAR(1) null

alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT_9 CHAR(1) null

6.2.1.b296

14754431.SQL

Modify Columns

alter table ASAP.ITEM_SPEC_EQUIP_SPEC_REL Modify PRIORITY_SEQ NUMBER(3)

6.2.1.b296

14737246.SQL

Modify Columns

alter table ASAP.EVC_UNI_MAP modify STACKED_VLAN VarChar2(9)

6.2.1.b296

14737246.SQL

New Columns

alter table ASAP.ACCESS_SERVICE_REQUEST add NETWORK_ACCESS_GROOM CHAR(1) null

alter table ASAP.SPECIAL_ACCESS add LINK_AGGREGATION_GRP_PROTECT VarChar2(2) null

alter table ASAP.CLARIFICATION_REQUEST add SUBSEQUENT_DISPATCH_INDICATOR CHAR(1) null

alter table ASAP.FIRM_ORDER_CONFIRMATION add LINK_AGGREGATION_GROUP_ID VarChar2(24) null

alter table ASAP.EVC_UNI_MAP add S_VACT CHAR(1) null

alter table ASAP.EVC_UNI_MAP add S_VACT1 CHAR(1) null

alter table ASAP.EVC_UNI_MAP add S_VLAN1 VarChar2(9) null

alter table ASAP.EVC_UNI_MAP add S_VACT2 CHAR(1) null

alter table ASAP.EVC_UNI_MAP add S_VLAN2 VarChar2(9) null

alter table ASAP.EVC_DETAIL add SVLAN_ID_PRESERVATION CHAR(1) null

6.2.1.b337

14336877.SQL

Modify Columns

Alter Table ASAP.CUST_ACCT Modify (COMPANY_NAME VARCHAR2(125))

6.2.1.b337

14336877.SQL

Modify Columns

Alter Table ASAP.CUST_ACCT_ADDR Modify (COMPANY_NAME VARCHAR2(125))

6.2.1.b348

15900554.SQL

New Index

create index ASAP.IDX_DCDL__BLOCK_IND on ASAP.DLR_CIRCUIT_DESIGN_LINE (SUBSTR(block_ind,1,2)) tablespace INDEXES

6.2.1.b394

16627050.SQL

Modify Columns

alter table ASAP.ASR_CONTACT_INFORMATION modify BILLING_PHONE_NMBR VarChar2(17)

alter table ASAP.ASR_CONTACT_INFORMATION modify INITIATOR_PHONE_NMBR VarChar2(17)

alter table ASAP.ASR_CONTACT_INFORMATION modify DESIGNER_PHONE_NMBR VarChar2(17)

alter table ASAP.ACCESS_BILLING_DATA modify CABS_BILL_CONTACT_PHONE VarChar2(17)

alter table ASAP.FOC_EVC modify STACKED_VLAN VARCHAR2(9)

6.2.1.b394

16627050.SQL

New Columns

alter table ASAP.SPECIAL_ACCESS add SUPPLEMENTAL_BANDWIDTH VarChar2(7) null

alter table ASAP.SPECIAL_ACCESS add SUPPLEMENTAL_BANDWIDTH_UOM CHAR(1) null

alter table ASAP.SPECIAL_ACCESS add INDEPENDENT_CO_LOCATION VarChar2(8) null

alter table ASAP.FIRM_ORDER_CONFIRMATION add NETWORK_FAC_REQUIRE_TYPE_1 CHAR(1) null

alter table ASAP.FIRM_ORDER_CONFIRMATION add NETWORK_FAC_REQUIRE_TYPE_2 CHAR(1) null

alter table ASAP.EVC_UNI_MAP add ENNI_INDICATOR CHAR(1) null

alter table ASAP.FOC_EVC add S_VLAN1 VARCHAR2(9) null

alter table ASAP.FOC_EVC add S_VLAN2 VARCHAR2(9) null

6.2.1.b498

16244675.SQL

Modify Columns

alter table ASAP.TASK modify SEQUENCE NUMBER(4)

6.2.1.b498

15931168.SQL

Modify Columns

alter table ASAP.DLR_NOTES modify DLR_NOTES_SEQUENCE_NBR NUMBER(4)

6.2.1.b528

17769155.SQL

Modify Columns

alter table ASAP.PARTY_ROLE_ADDRESS modify PARTY_ROLE_ADDR_SEQ NUMBER(9)

6.2.1.b528

17769155.SQL

Modify Columns

alter table ASAP.NET_LOC_ADDR_PR_ADDR modify PARTY_ROLE_ADDR_SEQ NUMBER(9)

6.2.1.b528

17769155.SQL

Modify Columns

alter table ASAP.SR_LOC modify PARTY_ROLE_ADDR_SEQ NUMBER(9)

6.2.1.b528

17619356.SQL

New Columns

alter table ASAP.CLARIFICATION_REQUEST add ESTIMATED_DUE_DATE DATE null

6.2.1.b528

17619356.SQL

New Columns

alter table ASAP.RING_SRSI add SECLOC_EUNAME VARCHAR(24) null

6.2.1.b589

17838220.SQL

Modify Columns

alter table ASAP.REMARK modify SEQUENCE_NUMBER NUMBER(9)

6.2.1.b589

18058766.SQL

Modify Columns

alter table ASAP.SI_LOC modify PARTY_ROLE_ADDR_SEQ NUMBER(9)

6.2.1.b589

18058766.SQL

Modify Columns

alter table ASAP.SR_PARTY_ROLE_ADDRESS modify PARTY_ROLE_ADDR_SEQ NUMBER(9)

6.2.1.b654

16535471.SQL

New Table

Create table ASAP.ACU_LOG

(

ACU_LOG_ID NUMBER(9) not null,

SEQ_NO NUMBER(9) not null,

LOG_DETAIL VARCHAR2(4000) null,

STATUS CHAR(1) null,

START_DATE DATE null,

END_DATE DATE null,

USERID VARCHAR2(8) not null

) Tablespace Data

6.2.1.b654

16535471.SQL

New Synonym

CREATE PUBLIC SYNONYM ACU_LOG FOR ASAP.ACU_LOG

6.2.1.b654

16535471.SQL

New Index

create unique index PFXPK_ACU_LOG on ACU_LOG (ACU_LOG_ID asc, SEQ_NO asc) Tablespace INDEXES

6.2.1.b654

16535471.SQL

New Constraint

alter table ACU_LOG add constraint PFXPK_ACU_LOG primary key (ACU_LOG_ID,SEQ_NO)

6.2.1.b654

16535471.SQL

New Sequence

create sequence ASAP.SQ_ACU_LOG

INCREMENT BY 1

START WITH 1000

MINVALUE 1000

MAXVALUE 999999999999999999999999999

NOCYCLE

NOORDER

CACHE 20

6.2.1.b654

16535471.SQL

New Synonym

CREATE PUBLIC SYNONYM SQ_ACU_LOG FOR ASAP.SQ_ACU_LOG

6.2.1.b654

16535471.SQL

New Index

CREATE INDEX PFXPK_ACT_END_USER_LOC ON DLR_CIRCUIT_DESIGN_LINE (END_USER_LOCATION_ID asc, LOCATION_ID asc) Tablespace INDEXES nologging

6.2.1.b696

18542980.SQL

New Columns

alter table ASAP.ACCESS_SERVICE_REQUEST add Switched_Ethernet_Indicator Char(1) null

6.2.1.b696

18542980.SQL

New Columns

alter table ASAP.FIRM_ORDER_CONFIRMATION add Ethernet_Service_Point NUMBER(9) null

6.2.1.b696

18542980.SQL

New Columns

alter table ASAP.EVC_UNI_MAP add Autonomous_System_Number VarChar2(5) null

6.2.1.b696

18542980.SQL

New Columns

alter table ASAP.EVC_UNI_MAP add VPN_Identifier_Activity Char(1) null

6.2.1.b696

18542980.SQL

New Columns

alter table ASAP.EVC_UNI_MAP add VPN_Identifier VarChar2(10) null

6.2.1.b696

18542980.SQL

New Table

CREATE TABLE ASAP.Switched_Ethernet_Service (

DOCUMENT_NUMBER NUMBER(9) not null,

SEC_NETWORK_CHANNEL_INTERFACE VarChar2(12) null,

Special_Routing_Code_PriLoc Char(1) null,

Special_Routing_Code_Io_Fac Char(1) null,

Special_Routing_Code_Secloc Char(1) null,

Supplemental_Bandwidth VarChar2(7) null,

Supplemental_Bandwidth_Uom Char(1) null,

BUM_option Char(1) null,

Bundling_Indicator Char(1) null,

Egress_Scheduler Char(1) null,

Profile_Egress VarChar2(30) null,

Profile_Ingress VarChar2(30) null,

Link_Aggregation_Group_ID VarChar2(24) null,

Link_Aggregation_Grp_Protect VarChar2(2) null,

Diverse_Circuit_ID VarChar2(36) null,

Diverse_PON VarChar2(16) null,

Cross_Connect_Eq_Assign VarChar2(60) null,

Gen_Exch_Tariff_Opt_ses Char(1) null,

Gen_Exch_Tar_Opt_Bill_Tel_Nmbr VarChar2(10) null,

GEN_EXCH_TARIFF_OPT_CONTACT_NM VarChar2(25) null,

GEN_EXCHG_TARIFF_OPT_TEL_NBR VarChar2(14) null,

IP_Address VarChar2(39) null,

INT_PROTOCOL_ADDRESS_IDENT Char(1) null,

Subnet_Mask VarChar2(15) null,

Ethernet_Service_Point Number(9) null,

Other_Exchange_Company VarChar2(4) null,

LAST_MODIFIED_USERID VarChar2(20) not null,

LAST_MODIFIED_DATE DATE not null

) tablespace DATA

6.2.1.b696

18542980.SQL

New Index

create unique index ASAP.PFXPK_SES on Switched_Ethernet_Service (DOCUMENT_NUMBER asc) tablespace INDEXES

6.2.1.b696

18542980.SQL

New Constraint

alter table ASAP.Switched_Ethernet_Service add constraint PFXPK_SES primary key (DOCUMENT_NUMBER)

6.2.1.b696

18542980.SQL

New Constraint

alter table ASAP.Switched_Ethernet_Service add constraint PFXFK_SES_ACC_SERV_REQ foreign key (DOCUMENT_NUMBER) references ACCESS_SERVICE_REQUEST (DOCUMENT_NUMBER)

6.2.1.b696

18542980.SQL

New Synonym

create public synonym Switched_Ethernet_Service for ASAP.Switched_Ethernet_Service

6.2.1.b738

19168504.SQL

Modify Columns

ALTER table ASAP.SERV_ITEM Modify TRUNK_SEG Varchar2(5)

6.2.1.b738

19168504.SQL

Modify Columns

ALTER table ASAP.SERV_REQ_SI Modify TRUNK_SEG Varchar2(5)

6.2.1.b751

13341865.SQL

New Table

CREATE GLOBAL TEMPORARY TABLE map_circuit_pos_processed (circuit_id NUMBER(9,0),

equipment_id NUMBER(9,0),

port_address_seq NUMBER(9,0)

) ON COMMIT DELETE ROWS

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.SPECIAL_ACCESS add LAYER2_CTRL_PROTOCOL_PEERING VarChar2(25) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.SPECIAL_ACCESS add LAYER2_CTRL_PROTOCOL_ADDRESS VarChar2(5) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.SPECIAL_ACCESS add UNI_MAX_SERVICE_FRAME_SIZE VarChar2(5) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.ACI_SRSI add SYNCHRONOUS_MODE Char(1) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.ACI_SRSI add UNI_MAX_SERVICE_FRAME_SIZE VarChar2(5) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.SWITCHED_ETHERNET_SERVICE add HIGH_VOLTAGE_PROTECTION Char(1) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.SWITCHED_ETHERNET_SERVICE add LAYER2_CTRL_PROTOCOL_PEERING VarChar2(25) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.SWITCHED_ETHERNET_SERVICE add LAYER2_CTRL_PROTOCOL_ADDRESS VarChar2(5) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.SWITCHED_ETHERNET_SERVICE add SYNCHRONOUS_MODE Char(1) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.SWITCHED_ETHERNET_SERVICE add UNI_MAX_SERVICE_FRAME_SIZE VarChar2(5) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.EVC_UNI_MAP add BROADCAST_FRAME_DELIVERY Char(1) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.EVC_UNI_MAP add UNICAST_FRAME_DELIVERY Char(1) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.EVC_UNI_MAP add MULTICAST_FRAME_DELIVERY Char(1) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.EVC_DETAIL add CEVLAN_ID_PRESERVATION Char(1) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.EVC_DETAIL add CEVLAN_COS_PRESERVATION Char(1) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.EVC_DETAIL add MAX_SERVICE_FRAME_SIZE VarChar2(5) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.EVC_LVL_SERV add COMMITTED_INFO_RATE_INGRESS VarChar2(6) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.EVC_LVL_SERV add COMMITTED_INFO_RATE_INGR_UOM Char(1) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.EVC_LVL_SERV add COMMITTED_BURST_SIZE_INGRESS VarChar2(7) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.EVC_LVL_SERV add EXCESS_INFO_RATE_INGRESS VarChar2(6) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.EVC_LVL_SERV add EXCESS_INFO_RATE_INGRESS_UOM Char(1) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.EVC_LVL_SERV add EXCESS_BURST_SIZE_INGRESS VarChar2(7) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.EVC_LVL_SERV add COLOR_MODE_IDENTIFIER_INGRESS Char(1) null

6.2.1.b804

19856022.SQL

New Columns

alter table ASAP.EVC_LVL_SERV add BDW_COUPLING_FLAG_INGRESS Char(1) null

6.2.1.b849

20342947.SQL

New Columns

ALTER TABLE ASAP.EVENT ADD CUST_SQL_IND CHAR(1) DEFAULT ''N''

6.2.1.b849

20342947.SQL

New Columns

ALTER TABLE ASAP.EVENT ADD CUST_SQL_EXPRESSION_VALUE VARCHAR2(4000)

6.2.1.b849

20342947.SQL

Modify Columns

ALTER TABLE ASAP.EVENT MODIFY CUST_SQL_IND CHAR(1) NOT NULL

6.2.1.870

18191708.SQL

New Columns

Alter Table ASAP.NST_CONFIGURATION_TYPE ADD DISABLE_DELETE_GRAPHICS Char(1) null

6.2.1.b914

20954197.SQL

Modify Columns

alter table ASAP.ACCESS_SERVICE_REQUEST modify CASE_NUMBER Varchar2(16)

6.2.1.b914

20954197.SQL

New Columns

alter table ASAP.ACCESS_SERVICE_REQUEST add END_USER_INDICATOR Char(1) null

6.2.1.b914

20954197.SQL

New Columns

alter table ASAP.ACCESS_SERVICE_REQUEST add PVC_IND Char(1) null

6.2.1.b914

20954197.SQL

New Columns

alter table ASAP.ACCESS_SERVICE_REQUEST add NBR_OF_PERM_VIRTUAL_CONN Varchar2(2) null

6.2.1.b914

20954197.SQL

New Columns

alter table ASAP.ACI_SRSI add OPTICAL_FIBER_CONN_PRILOC VarChar2(15) null

6.2.1.b914

20954197.SQL

New Columns

alter table ASAP.ACI_SRSI add OPTICAL_FIBER_CONN_SECLOC VarChar2(15) null

6.2.1.b914

20954197.SQL

New Columns

alter table ASAP.ACI_SRSI add IP_ADDRESS2 VarChar2(39) null

6.2.1.b914

20954197.SQL

New Columns

alter table ASAP.ACI_SRSI add INT_PROTOCOL_ADDRESS_IDENT2 Char(1) null

6.2.1.b914

20954197.SQL

New Columns

alter table ASAP.ACI_SRSI add SUBNET_MASK2 VarChar2(15) null

6.2.1.b914

20954197.SQL

New Columns

alter table ASAP.ACI_SRSI add ACCESS_CIRCUIT_ID VarChar2(42) null

6.2.1.b914

20954197.SQL

New Columns

alter table ASAP.ACI_SRSI add ETH_ACCESS_SUPPL_BANDWIDTH VarChar2(7) null

6.2.1.b914

20954197.SQL

New Columns

alter table ASAP.ACI_SRSI add ETH_ACCESS_SUPPL_BANDWIDTH_UOM Char(1) null

6.2.1.b914

20954197.SQL

New Columns

alter table ASAP.SWITCHED_ETHERNET_SERVICE add WORK_AUTH_CKT_DETAIL_LINK_1 VarChar2(36) null

6.2.1.b914

20954197.SQL

Modify Columns

alter table ASAP.RCONF_ECHO modify CASE_NUMBER VarChar2(16)

6.2.1.b914

20954197.SQL

New Columns

alter table EBOND.FOC_PROVIDER_CIRCUIT add ACCESS_CIRCUIT_ORDER_NUMBER VarChar2(17) null

6.2.1.b914

20954197.SQL

New Columns

alter table EBOND.FOC_PROVIDER_CIRCUIT add ACCESS_CIRCUIT_ID VarChar2(42) null

6.2.1.b914

20954197.SQL

New Columns

alter table ASAP.END_USER_LOCATION_USAGE add OPTICAL_FIBER_CONN VarChar2(15) null

6.2.1.b914

20954197.SQL

New Columns

alter table ASAP.EVC_DETAIL add EGRESS_PROFILE_SELECTION VarChar2(30) null

6.2.1.b914

20954197.SQL

New Columns

alter table ASAP.EVC_UNI_MAP add VPN_NAME VarChar2(30) null

6.2.1.b914

20954197.SQL

Drop Constraint

alter table ASAP.FOC_EVC_DETAIL drop constraint PFXFK_EVC_DETAIL__FOC_EVC_DET

6.2.1.b914

20954197.SQL

Modify Columns

alter table ASAP.SERV_REQ modify CASE_NUMBER Varchar2(16)

6.2.1.b914

20954197.SQL

New Table

CREATE TABLE ASAP.DEDICATED_INTERNET_SERVICE (

DOCUMENT_NUMBER NUMBER(9,0) not null,

SEC_NETWORK_CHANNEL_INTERFACE VarChar2(12) null,

SPECIAL_ROUTING_CODE_PRILOC Char(1) null,

SPECIAL_ROUTING_CODE_IO_FAC Char(1) null,

SPECIAL_ROUTING_CODE_SECLOC Char(1) null,

SUPPLEMENTAL_BANDWIDTH VarChar2(7) null,

SUPPLEMENTAL_BANDWIDTH_UOM Char(1) null,

ETH_ACCESS_SUPPL_BANDWIDTH VarChar2(7) null,

ETH_ACCESS_SUPPL_BANDWIDTH_UOM Char(1) null,

ACCESS_TYPE VARCHAR2(12) null,

LINK_AGGREGATION_GROUP_ID VarChar2(24) null,

LINK_AGGREGATION_GRP_PROTECT VarChar2(2) null,

ROUTER Number(9,0) null,

PROFILE_EGRESS VarChar2(30) null,

AUTONOMOUS_SYSTEM_NUMBER Varchar2(10) null,

INT_PROTOCOL_ADDRESS_IDENT Char(1) null,

IP_ADDRESS VarChar2(39) null,

SUBNET_MASK VarChar2(15) null,

INT_PROTOCOL_ADDRESS_IDENT_2 Char(1) null,

IP_ADDRESS_2 VarChar2(39) null,

SUBNET_MASK_2 VarChar2(15) null,

CROSS_CONNECT_EQ_ASSIGN VarChar2(60) null,

GEN_EXCH_TARIFF_OPT_DIS Char(1) null,

GEN_EXCH_TAR_OPT_BILL_TEL_NMBR VarChar2(10) null,

GEN_EXCH_TARIFF_OPT_CONTACT_NM VarChar2(25) null,

GEN_EXCHG_TARIFF_OPT_TEL_NBR VarChar2(14) null,

DIVERSE_CIRCUIT_ID VarChar2(36) null,

DIVERSE_PON VarChar2(16) null,

SECLOC Number(9,0) null,

OTHER_EXCHANGE_COMPANY VarChar2(4) null,

LAST_MODIFIED_USERID VarChar2(8) not null,

LAST_MODIFIED_DATE DATE not null ) tablespace DATA

6.2.1.b914

20954197.SQL

New Index

create unique index ASAP.PFXPK_DIS on DEDICATED_INTERNET_SERVICE (DOCUMENT_NUMBER asc) tablespace INDEXES

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.DEDICATED_INTERNET_SERVICE add constraint PFXPK_DIS primary key (DOCUMENT_NUMBER)

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.DEDICATED_INTERNET_SERVICE add constraint PFXFK_DIS__ACC_SERV_REQ foreign key (DOCUMENT_NUMBER) references ACCESS_SERVICE_REQUEST (DOCUMENT_NUMBER)

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.DEDICATED_INTERNET_SERVICE add constraint PFXFK_DIS__NET_LOC_ROUTER foreign key (ROUTER) references NETWORK_LOCATION (LOCATION_ID)

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.DEDICATED_INTERNET_SERVICE add constraint PFXFK_DIS__NET_LOC_SECLOC foreign key (SECLOC) references NETWORK_LOCATION (LOCATION_ID)

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.DEDICATED_INTERNET_SERVICE add constraint PFXFK_DIS__NCI_SECNCI foreign key (SEC_NETWORK_CHANNEL_INTERFACE) references NETWORK_CHANNEL_INTERFACE (NETWORK_CHANNEL_INTERFACE_CODE)

6.2.1.b914

20954197.SQL

New Synonym

create public synonym DEDICATED_INTERNET_SERVICE for ASAP.DEDICATED_INTERNET_SERVICE

6.2.1.b914

20954197.SQL

New Table

CREATE TABLE ASAP.PRIVATE_INTERNET_PROTOCOL (

DOCUMENT_NUMBER NUMBER(9,0) not null,

SEC_NETWORK_CHANNEL_INTERFACE VarChar2(12) null,

SPECIAL_ROUTING_CODE_PRILOC Char(1) null,

SPECIAL_ROUTING_CODE_IO_FAC Char(1) null,

SPECIAL_ROUTING_CODE_SECLOC Char(1) null,

ACCESS_TYPE VARCHAR2(12) null,

INT_PROTOCOL_ADDRESS_IDENT Char(1) null,

INT_PROTOCOL_ADDRESS_IDENT_2 Char(1) null,

ETH_ACCESS_SUPPL_BANDWIDTH VarChar2(7) null,

ETH_ACCESS_SUPPL_BANDWIDTH_UOM Char(1) null,

LINK_MGMT_PROTOCOL Char(1) null,

ROUTER Number(9,0) null,

EGRESS_SCHEDULER Char(1) null,

PROFILE_EGRESS VarChar2(30) null,

ACCESS_CIRCUIT_ID VarChar2(42) null,

CROSS_CONNECT_EQ_ASSIGN VarChar2(60) null,

GEN_EXCH_TARIFF_OPT_PIP Char(1) null,

GEN_EXCH_TAR_OPT_BILL_TEL_NMBR VarChar2(10) null,

GEN_EXCH_TARIFF_OPT_CONTACT_NM VarChar2(25) null,GEN_EXCHG_TARIFF_OPT_TEL_NBR VarChar2(14) null,

DIVERSE_CIRCUIT_ID VarChar2(36) null,

DIVERSE_PON VarChar2(16) null,SECLOC Number(9,0) null,

OTHER_EXCHANGE_COMPANY VarChar2(4) null,

LAST_MODIFIED_USERID VarChar2(8) not null,

LAST_MODIFIED_DATE DATE not null) tablespace DATA

6.2.1.b914

20954197.SQL

New Index

create unique index ASAP.PFXPK_PIP on PRIVATE_INTERNET_PROTOCOL (DOCUMENT_NUMBER asc) tablespace INDEXES

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.PRIVATE_INTERNET_PROTOCOL add constraint PFXPK_PIP primary key (DOCUMENT_NUMBER)

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.PRIVATE_INTERNET_PROTOCOL add constraint PFXFK_PIP__ACC_SERV_REQ foreign key (DOCUMENT_NUMBER) references ACCESS_SERVICE_REQUEST (DOCUMENT_NUMBER)

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.PRIVATE_INTERNET_PROTOCOL add constraint PFXFK_PIP__NET_LOC_ROUTER foreign key (ROUTER) references NETWORK_LOCATION (LOCATION_ID)

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.PRIVATE_INTERNET_PROTOCOL add constraint PFXFK_PIP__NET_LOC_SECLOC foreign key (SECLOC) references NETWORK_LOCATION (LOCATION_ID)

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.PRIVATE_INTERNET_PROTOCOL add constraint PFXFK_PIP__NCI_SECNCI foreign key (SEC_NETWORK_CHANNEL_INTERFACE) references NETWORK_CHANNEL_INTERFACE (NETWORK_CHANNEL_INTERFACE_CODE)

6.2.1.b914

20954197.SQL

New Synonym

create public synonym PRIVATE_INTERNET_PROTOCOL for ASAP.PRIVATE_INTERNET_PROTOCOL',

40, 'CREATE TABLE ASAP.PVC_COMMON (

DOCUMENT_NUMBER NUMBER(9,0) not null,

PVC_COMMON_ID NUMBER(9,0) not null,

NETWORK_CHANNEL_SERVICE_CODE VarChar2(2) null,

NETWORK_CHANNEL_OPTION_CODE VarChar2(2) null,

NETWORK_CHANNEL_INTERFACE_CODE VarChar2(12) null,

RELATED_PORT_IDENTIFIER VarChar2(28) null,

LAST_MODIFIED_USERID VarChar2(8) not null,

LAST_MODIFIED_DATE DATE not null) tablespace DATA

6.2.1.b914

20954197.SQL

New Index

create unique index ASAP.PFXPK_PVC_COMMON on PVC_COMMON (DOCUMENT_NUMBER asc, PVC_COMMON_ID asc) tablespace INDEXES

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.PVC_COMMON add constraint PFXPK_PVC_COMMON primary key (DOCUMENT_NUMBER, PVC_COMMON_ID)

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.PVC_COMMON add constraint PFXFK_PVC_COM__ACC_SERV_REQ foreign key (DOCUMENT_NUMBER) references ACCESS_SERVICE_REQUEST (DOCUMENT_NUMBER)

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.PVC_COMMON add constraint PFXFK_PVC_COM__NE_CH_OP foreign key (NETWORK_CHANNEL_SERVICE_CODE,NETWORK_CHANNEL_OPTION_CODE) references NETWORK_CHANNEL_OPTION (NETWORK_CHANNEL_SERVICE_CODE,NETWORK_CHANNEL_OPTION_CODE)

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.PVC_COMMON add constraint PFXFK_PVC_COM__NCI foreign key (NETWORK_CHANNEL_INTERFACE_CODE) references NETWORK_CHANNEL_INTERFACE (NETWORK_CHANNEL_INTERFACE_CODE)

6.2.1.b914

20954197.SQL

New Sequence

CREATE SEQUENCE ASAP.SQ_PVC_COMMON MINVALUE 10000 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 15469 CACHE 20 NOORDER NOCYCLE

6.2.1.b914

20954197.SQL

New Synonym

CREATE PUBLIC SYNONYM SQ_PVC_COMMON FOR ASAP.SQ_PVC_COMMON

6.2.1.b914

20954197.SQL

New Synonym

create public synonym PVC_COMMON for ASAP.PVC_COMMON

6.2.1.b914

20954197.SQL

New Table

CREATE TABLE ASAP.PVC_CIRCUIT_DETAIL (

PVC_CIRCUIT_DETAIL_ID NUMBER(9,0) not null,

DOCUMENT_NUMBER NUMBER(9,0) not null,

PVC_COMMON_ID NUMBER(9,0) not null,

PVC_NBR VarChar2(4) not null,

PVC_ACTIVITY Char(1) null,

PVC_ID VarChar2(28) null,

VPN_NAME VarChar2(30) null,

DATA_LINK_CONN_IDENTIFIER Varchar2(4) null,

AUTONOMOUS_SYSTEM_NUMBER Varchar2(10) null,

PVC_CKR VarChar2(53) null,

EGRESS_PROFILE_SECTION VarChar2(30) null,

LAST_MODIFIED_USERID VarChar2(8) not null,

LAST_MODIFIED_DATE DATE not null) tablespace DATA

6.2.1.b914

20954197.SQL

New Index

create unique index ASAP.PFXPK_PVC_CKT_DETAIL on PVC_CIRCUIT_DETAIL (PVC_CIRCUIT_DETAIL_ID asc) tablespace INDEXES

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.PVC_CIRCUIT_DETAIL add constraint PFXPK_PVC_CKT_DETAIL primary key (PVC_CIRCUIT_DETAIL_ID)

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.PVC_CIRCUIT_DETAIL add constraint PFXFK_PVC_CKT_DET__ASR foreign key (DOCUMENT_NUMBER) references ACCESS_SERVICE_REQUEST (DOCUMENT_NUMBER)

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.PVC_CIRCUIT_DETAIL add constraint PFXFK_PVC_CKT_DET__PVC_COM foreign key (DOCUMENT_NUMBER, PVC_COMMON_ID) references PVC_COMMON (DOCUMENT_NUMBER, PVC_COMMON_ID)

6.2.1.b914

20954197.SQL

New Sequence

CREATE SEQUENCE ASAP.SQ_PVC_CIRCUIT_DETAIL MINVALUE 10000 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 15469 CACHE 20 NOORDER NOCYCLE

6.2.1.b914

20954197.SQL

New Synonym

CREATE PUBLIC SYNONYM SQ_PVC_CIRCUIT_DETAIL FOR ASAP.SQ_PVC_CIRCUIT_DETAIL

6.2.1.b914

20954197.SQL

New Synonym

create public synonym PVC_CIRCUIT_DETAIL for ASAP.PVC_CIRCUIT_DETAIL

6.2.1.b914

20954197.SQL

New Table

CREATE TABLE ASAP.PVC_LVL_SERV (

PVC_LVL_SERV_ID NUMBER(9,0) not null,

PVC_CIRCUIT_DETAIL_ID NUMBER(9,0) not null,

DOCUMENT_NUMBER NUMBER(9,0) not null,

LVL_OF_SERV_REF_NBR Char(1) null,

LVL_OF_SERV_ACT_CD Char(1) null,

LVL_OF_SERV_NM Varchar2(20) null,

SERVICE_AND_PRODUCT_ENHANC_COD Varchar2(7) null,

BANDWIDTH Varchar2(6) null,

BANDWIDTH_UOM Char(1) null,

LAST_MODIFIED_USERID VarChar2(8) not null,

LAST_MODIFIED_DATE DATE not null) tablespace DATA

6.2.1.b914

20954197.SQL

New Index

create unique index ASAP.PFXPK_PVC_LVL_SERV on PVC_LVL_SERV (PVC_LVL_SERV_ID asc) tablespace INDEXES

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.PVC_LVL_SERV add constraint PFXPK_PVC_LVL_SERV primary key (PVC_LVL_SERV_ID)

6.2.1.b914

20954197.SQL

New Constraint

alter table ASAP.PVC_LVL_SERV add constraint PFXFK_PVC_LV_SER__PVC_CKT_DET foreign key (PVC_CIRCUIT_DETAIL_ID) references PVC_CIRCUIT_DETAIL (PVC_CIRCUIT_DETAIL_ID)

6.2.1.b914

20954197.SQL

New Sequence

CREATE SEQUENCE ASAP.SQ_PVC_LVL_SERV MINVALUE 10000 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 15469 CACHE 20 NOORDER NOCYCLE

6.2.1.b914

20954197.SQL

New Synonym

CREATE PUBLIC SYNONYM SQ_PVC_LVL_SERV FOR ASAP.SQ_PVC_LVL_SERV

6.2.1.b914

20954197.SQL

New Synonym

create public synonym PVC_LVL_SERV for ASAP.PVC_LVL_SERV

6.2.1.b914

20954197.SQL

Modify Columns

alter table ASAP.ASR_GUIDELINE_RULE modify RULE Varchar2(1500)

6.2.1.b914

20661032.SQL

New Table

CREATE TABLE ASAP.ASR_Audit_History (

ASR_Audit_history_Id NUMBER(10,0) not null,

DOCUMENT_NUMBER NUMBER(9,0) not null,

PON Varchar2(16) Not null,

Version Varchar2(2) Not null,

Form_name Varchar2(50) Not null,

Form_Reference_Number VarChar2(15) null,

Field_name Varchar2(50) Not null,

Current_Field_Value Varchar2(256) null,

Previous_Field_Value Varchar2(256) null,

Last_Modified_Date Date Not null,

Last_Modified_Userid VarChar2(8) Not null ) tablespace DATA

6.2.1.b914

20661032.SQL

New Synonym

create public synonym ASR_Audit_History for ASAP.ASR_Audit_History

6.2.1.b914

20661032.SQL

New Index

CREATE INDEX ASAP.IDX_AUDIT_DOCUMENT_NO ON ASR_AUDIT_HISTORY (DOCUMENT_NUMBER) tablespace INDEXES

6.2.1.b914

20661032.SQL

New Constraint

alter table ASAP.ASR_Audit_History add constraint PFXPK_audt_hist_id primary key (ASR_Audit_history_Id)

6.2.1.b914

20661032.SQL

New Table

CREATE TABLE ASAP.ASR_Supplement_History (

ASR_SUPPLEMENT_HISTORY_ID NUMBER(10) not null,

DOCUMENT_NUMBER NUMBER(9,0) not null,

PON Varchar2(16) Not null,

Current_Version Varchar2(2) Not null,

Previous_Version Varchar2(2) Not null,

SUPP_TYPE char(1) Not null,

Form_name Varchar2(50) Not null,

Form_Reference_Number VarChar2(15) null,

Field_name Varchar2(50) Not null,

Current_Field_Value Varchar2(256) null,

Previous_Field_Value Varchar2(256) null,

Supplemented_Date Date Not null,

Supplemented_By VarChar2(8) Not null) tablespace DATA

6.2.1.b914

20661032.SQL

New Synonym

create public synonym ASR_SUPPLEMENT_HISTORY for ASAP.ASR_SUPPLEMENT_HISTORY

6.2.1.b914

20661032.SQL

New Constraint

alter table ASAP.ASR_SUPPLEMENT_HISTORY add constraint PFXPK_ASHD_id primary key (ASR_SUPPLEMENT_HISTORY_ID)

6.2.1.b914

20661032.SQL

New Sequence

create sequence ASAP.SQ_ASR_AUDIT_HISTORY

INCREMENT BY 1

START WITH 0

MINVALUE 0

MAXVALUE 999999999999999999999999999

NOCYCLE

NOORDER

CACHE 20

6.2.1.b914

20661032.SQL

New Synonym

CREATE PUBLIC SYNONYM SQ_ASR_AUDIT_HISTORY FOR ASAP.SQ_ASR_AUDIT_HISTORY

6.2.1.b914

20661032.SQL

New Sequence

create sequence ASAP.SQ_ASR_SUPPLEMENT_HISTORY

INCREMENT BY 1

START WITH 0

MINVALUE 0

MAXVALUE 999999999999999999999999999

NOCYCLE

NOORDER

CACHE 20

6.2.1.b914

20661032.SQL

New Synonym

CREATE PUBLIC SYNONYM SQ_ASR_SUPPLEMENT_HISTORY FOR ASAP.SQ_ASR_SUPPLEMENT_HISTORY

6.2.1.b914

20661032.SQL

New Columns

alter table ASAP.SERV_REQ add SR_AUDIT_IND Char(1) null

6.2.1.1005

21958448.sql

New Columns

alter table ASAP.ACCESS_SERVICE_REQUEST add WIRELESS_SITE_IND_PRILOC Char(1) null

6.2.1.1005

21958448.sql

Modify Columns

alter table ASAP.ACCESS_SERVICE_REQUEST modify BILLING_ACCOUNT_NUMBER Varchar2(13)

6.2.1.1005

21958448.sql

New Columns

alter table ASAP.SWITCHED_ETHERNET_SERVICE add COLOR_IDENTIFIER Varchar2(3) null

6.2.1.1005

21958448.sql

New Columns

alter table ASAP.SWITCHED_ETHERNET_SERVICE add MULTI_CHAS_LINK_AGGR_GROUP Char(1) null

6.2.1.1005

21958448.sql

New Columns

alter table ASAP.SWITCHED_ETHERNET_SERVICE add MULTI_CHAS_LINK_AGGR_GROUP_ID VarChar2(24) null

6.2.1.1005

21958448.sql

New Columns

alter table ASAP.SWITCHED_ETHERNET_SERVICE add MULTI_CHAS_LINK_AGGR_GROUP_P VarChar2(2) null

6.2.1.1005

21958448.sql

Modify Columns

alter table ASAP.FIRM_ORDER_CONFIRMATION modify BILLING_ACCOUNT_NUMBER Varchar2(13)

6.2.1.1005

21958448.sql

New Columns

alter table ASAP.FIRM_ORDER_CONFIRMATION add MULTI_CHAS_LINK_AGGR_GROUP_ID VarChar2(24) null

6.2.1.1005

21958448.sql

Modify Columns

alter table ASAP.END_USER_LOCATION_USAGE modify ALT_ACC_TEL_NBR VarChar2(17)

6.2.1.1005

21958448.sql

Modify Columns

alter table ASAP.END_USER_LOCATION_USAGE modify ALT_CONTACT_TEL_NBR VarChar2(17)

6.2.1.1005

21958448.sql

Modify Columns

alter table ASAP.END_USER_LOCATION_USAGE modify ADDL_ALT_CONTACT_TEL_NBR VarChar2(17)

6.2.1.1005

21958448.sql

New Columns

alter table ASAP.EVC_LVL_SERV add PRIORITY_BIT_COLOR_INGRESS VarChar2(8) null

6.2.1.1005

21958448.sql

New Columns

alter table ASAP.EVC_LVL_SERV add PRIORITY_BIT_COLOR_EGRESS VarChar2(2) null

6.2.1.1005

21958448.sql

Modify Columns

alter table ASAP.ACCESS_PROVIDER_ROLE modify BILLING_ACCOUNT_NUMBER VarChar2(13)

6.2.1.1005

21958448.sql

Modify Columns

alter table ASAP.ACCESS_BILLING_CIRCUIT_DATA modify CABS_BILLING_NUMBER VarChar2(13)

6.2.1.1005

21958448.sql

Modify Columns

alter table ASAP.ACCESS_BILLING_DATA modify BILLING_ACCOUNT_NUMBER VarChar2(13)

6.2.1.1039

22239114.sql

New Columns

ALTER TABLE ASAP.TEL_NUM_CATEGORY_TYPE_SUBTYPE ADD ASSIGNABLE_IND CHAR(1) DEFAULT 'Y'

6.2.1.1067

23220010.sql

New Columns

alter table ASAP.ACI_SRSI add RELATED_CIRCUIT_ID VarChar2(28) null

6.2.1.1067

23220010.sql

New Columns

alter table ASAP.ACI_SRSI add POWER_TYPE_AND_VOLTAGE

6.2.1.1067

23220010.sql

New Columns

alter table ASAP.SPECIAL_ACCESS add RELATED_CIRCUIT_ID Varchar2(28) null

6.2.1.1067

23220010.sql

New Columns

alter table ASAP.SPEC_ACCESS_AND_LINE_DETAIL add RELATED_CIRCUIT_ID Varchar2(28) null

6.2.1.1067

23220010.sql

New Columns

alter table ASAP.SWITCHED_ETHERNET_SERVICE add POWER_TYPE_AND_VOLTAGE VarChar2(5) null

6.2.1.1135

24786270.sql

New Columns

alter table ASAP.ASR_CONTACT_INFORMATION add SITE_CONTACT_NAME VarChar2(15) null

6.2.1.1135

24786270.sql

New Columns

alter table ASAP.ASR_CONTACT_INFORMATION add SITE_PHONE_NMBR Varchar2(17) null

6.2.1.1135

24786270.sql

New Columns

alter table ASAP.ASR_CONTACT_INFORMATION add SITE_EMAIL_ADDR Varchar2(60) null

6.2.1.1135

24921842.sql

Modify Columns

ALTER TABLE ASAP.EQUIPMENT MODIFY WORK_ORDER_NUMBER VARCHAR2(17)

6.2.1.1135

24756742.sql

Drop Index

DROP INDEX ASAP.SYS_C0054464

6.2.1.1182

25509095.sql

New Columns

ALTER TABLE ASAP.EQUIPMENT_SPEC ADD EQUIP_SPEC_CREATE_DATE DATE

6.2.1.1182

25529139.sql

Modify Columns

ALTER TABLE ASAP.CHECKPOINT_RESTART MODIFY (LAST_ROW_SAVED VarChar2(7))

6.2.1.1182

25542417.sql

New Columns

ALTER TABLE ASAP.DESIGN ADD ACCESS_CUST_TERMINAL_LOCATION VarChar2(20) null

6.2.1.1182

25542417.sql

New Columns

ALTER TABLE ASAP.DESIGN ADD ADDITIONAL_POINT_OF_TERMINATIO VarChar2(20)

6.2.1.1182

25542417.sql

New Columns

ALTER TABLE ASAP.DESIGN ADD NETWORK_CHANNEL_CODE VarChar2(4)

6.2.1.1182

25542417.sql

New Columns

ALTER TABLE ASAP.DESIGN ADD NETWORK_CHANNEL_OPTION_CODE VarChar2(2)

6.2.1.1182

25542417.sql

New Columns

ALTER TABLE ASAP.DESIGN ADD NETWORK_CHANNEL_INTERFACE_CODE VarChar2(12)

6.2.1.1182

25542417.sql

New Columns

ALTER TABLE ASAP.DESIGN ADD SEC_NETWORK_CHANNEL_INTERFACE VarChar2(12)

6.2.1.1182

25962277.sql

Modify Columns

alter table asap.circuit_position modify (ADDITIONAL_ASSIGNMENT_SEQ_NBR number(3))

6.2.1.1182

25962277.sql

Modify Columns

alter table asap.dlr_notes modify (DLR_NOTES_SEQUENCE_NBR number(5))

2 Database Changes in 6.2.1 GA

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)

)

/

3 Database Changes in 6.2

Table 3-1 lists the database changes that were included in 6.0.15 and 6.0.16 patches, and the 6.2.0 release. For changes delivered in patches, the build number where the change was first introduced is referenced. If you have installed 6.0.x, refer to the build number to determine if you have already implemented the changes that are listed.

Table 3-1 Database Changes in 6.0.15 and 6.0.16 Patches, and the 6.2.0 Release

Release

Prodfixsql File

Change

SQL

6.0.15.b256

CR119347.sql

New Table

alter table INTEGRATION_EVENT_STATUS drop constraint FK_IN_EV_ST__SR_GA_EV

/

alter table INTEGRATION_EVENT_STATUS add constraint FK_IN_EV_ST__SR_GA_EV

foreign key (SRSI_GATEWAY_EVENT_ID, SRSI_DOCUMENT_NUMBER, SRSI_SERV_ITEM_ID,SRSI_TASK_NUMBER)

references SRSI_GATEWAY_EVENT

(GATEWAY_EVENT_ID, DOCUMENT_NUMBER,SERV_ITEM_ID, TASK_NUMBER) ON DELETE CASCADE'

/

6.0.15.b645

9462631.sql

Modify Columns

alter table ASSIGNED_TEL_NUM modify (ATN_ID Number(10,0))

/

alter table ATN_CNAM modify (ATN_ID Number (10,0))

/

alter table ATN_LIDB modify (ATN_ID Number (10,0))

/

alter table ATN_PIC modify (ATN_ID Number (10,0))

/

alter table ATN_RCF_NP_INFO modify (ATN_ID Number (10,0))

/

alter table INTERCEPT_INFO modify (ATN_ID Number (10,0))

/

alter table SPLIT_INTERCEPT modify (ATN_ID Number (10,0))

/

alter table NI_ASSIGNED_ITN modify (NI_ATN_ID NUMBER(10,0))

/

6.0.15.b714

10041045.sql

Modify

Columns

alter table NI_IP_RULE modify (NI_USE_NBR_CD Number(4))

/

alter table NI_USE_GRP_NBR_INV modify (NI_USE_NBR_CD Number(4))

/

alter table NI_USE_GRP_FUNCT_AREA modify (NI_USE_NBR_CD Number(4))

/

alter table NI_USE modify (NI_USE_NBR_CD Number(4))

/

6.0.15.b736

8374339.sql

Modify

Columns

alter table ASAP.SERV_REQ

add NPA VarChar2(3) null

/

alter table ASAP.SERV_REQ

add NXX VarChar2(3) null

/

6.0.16.b226

Bug7632057.sql

New

Columns

alter table ACI_SRSI

add TELECOM_SERVICE_PRIORITY VarChar2(12) null

/

6.0.16.b309

B8200289.sql

New

Columns

alter table NS_NETWORK_SYSTEM

add NS_PROTECT_TYPE

VarChar2(15) null

/

6.0.16.b317

8448397.sql

New

Columns

alter table SPECIAL_ACCESS

add SWITCHED_ETHERNET_INDICATOR Char(1) null

/

alter table TQ_SAC_ACTIVITY_INFORMATION

add SERVICE_ACCESS_CODE

Number(3) null

/

6.0.16.b348

8760811.sql

New Table

create table DEFAULT_OPA_CRITERIA

(

GA_INSTANCE_ID_ORIG Number(9) not null,

GA_INSTANCE_ID_TERM Number(9) not null,

INCLUDE_CRITERIA VarChar2 (200) null,

EXCLUDE_CRITERIA VarChar2 (200) null,

LAST_MODIFIED_USERID VarChar2 (8) not null,

LAST_MODIFIED_DATE Date not null

) Tablespace DATA

/

6.0.16.b348

8760811.sql

New

Constraint

alter table DEFAULT_OPA_CRITERIA

add constraint PFXPK_DEFAULT_OPA_CRITERIA primary key (GA_INSTANCE_ID_ORIG, GA_INSTANCE_ID_TERM)

/

alter table DEFAULT_OPA_CRITERIA

add constraint PFXFK_DEF_OPA_CRIT__GA_INST1 foreign key (GA_INSTANCE_ID_ORIG) references GA_INSTANCE (GA_INSTANCE_ID)

/

alter table DEFAULT_OPA_CRITERIA

add constraint PFXFK_DEF_OPA_CRIT__GA_INST2 foreign key (GA_INSTANCE_ID_TERM) references GA_INSTANCE (GA_INSTANCE_ID)

/

6.0.16.b348

8760811.sql

New Synonym

Create Public Synonym DEFAULT_OPA_CRITERIA for asap.DEFAULT_OPA_CRITERIA

/

6.0.16.b384

9023783.sql

New Table

create table PARTITION_GROUP

(

PARTITION_GROUP_ID Number(9) not null,

PARTITION_GROUP_NAME VarChar2 (30) not null,

PARTITION_GROUP_DESC VarChar2 (100) null,

SYSTEM_IND Char (1) not null,

LAST_MODIFIED_USERID VarChar2 (32) not null,

LAST_MODIFIED_DATE Date not null

) Tablespace DATA

/

create table PARTITION_SECURITY_USERS

(

PARTITION_GROUP_ID Number(9) not null,

NAME VarChar2 (16) not null,

STATUS Char (1) not null,

LAST_MODIFIED_USERID VarChar2 (32) not null,

LAST_MODIFIED_DATE Date not null

) Tablespace DATA

/

6.0.16.b384

9023783.sql

New

Columns

alter table CIRCUIT

add PARTITION_GROUP_ID

Number(9) null

/

alter table NS_NETWORK_SYSTEM

add PARTITION_GROUP_ID

Number(9) null

/

alter table EQUIPMENT

add PARTITION_GROUP_ID

Number(9) null

/

alter table TFC_NETWORK

add PARTITION_GROUP_ID

Number(9) null

/

6.0.16.b384

9023783.sql

New

Constraint

alter table PARTITION_GROUP

add constraint PFXPK_PARTITION_GROUP

primary key (PARTITION_GROUP_ID)

/

alter table PARTITION_SECURITY_USERS

add constraint PFXFK_PAR_SECU__SECU_USERS

foreign key (NAME) references SECURITY_USERS (NAME)

/

alter table PARTITION_SECURITY_USERS

add constraint PFXFK_PAR_SECU__PART_GROUP

foreign key (PARTITION_GROUP_ID) references PARTITION_GROUP (PARTITION_GROUP_ID)

/

alter table CIRCUIT

add constraint PFXFK_CIRCUIT__PART_GROUP

foreign key (PARTITION_GROUP_ID) references PARTITION_GROUP (PARTITION_GROUP_ID)

/

alter table NS_NETWORK_SYSTEM

add constraint PFXFK_NS_NETW_SYS__PART_GROUP

foreign key (PARTITION_GROUP_ID) references PARTITION_GROUP (PARTITION_GROUP_ID)

/

alter table EQUIPMENT

add constraint PFXFK_EQUIPMENT__PART_GROUP

foreign key (PARTITION_GROUP_ID) references PARTITION_GROUP (PARTITION_GROUP_ID)

/

alter table TFC_NETWORK

add constraint PFXFK_TFC_NETW__PART_GROUP

foreign key (PARTITION_GROUP_ID) references PARTITION_GROUP (PARTITION_GROUP_ID)

/

6.0.16.b384

9023783.sql

New sequence

create sequence SQ_PARTITION_GROUP

INCREMENT BY 1

START WITH 10000

MINVALUE 10000

MAXVALUE 999999999999999999999999999

NOCYCLE NOORDER CACHE 20

/

6.0.16.b384

9023783.sql

New Synonym

Create Public Synonym PARTITION_GROUP for ASAP.PARTITION_GROUP

/

Create Public Synonym PARTITION_SECURITY_USERS for ASAP.PARTITION_SECURITY_USERS

/

Create Public Synonym SQ_PARTITION_GROUP for ASAP.SQ_PARTITION_GROUP

/

6.0.16.b484

9559056.sql

New Table

create table FOC_EVC_DETAIL

(

DOCUMENT_NUMBER Number(9) not null,

EVC_NBR VarChar2 (4) not null,

FOC_DESIGN_ID Number(9) not null,

EVC_ID VarChar2 (28) null,

EVC_ORD VarChar2 (17) null,

EVC_CKR VarChar2 (53) null,

LAST_MODIFIED_USERID VarChar2 (32) not null,

LAST_MODIFIED_DATE Date not null

) Tablespace DATA

/

6.0.16.b484

9559056.sql

New

Columns

alter table ACCESS_SERVICE_REQUEST

add SERVICE_RESERVATION_NUMBER VarChar2 (15) null

/

alter table ACCESS_SERVICE_REQUEST

add SECONDARY_CONNECT_FAC_USE Char (1) null

/

alter table SPECIAL_ACCESS

add DIVERSE_CIRCUIT_ID VarChar2(36) null

/

alter table SPECIAL_ACCESS

add DIVERSE_PON VarChar2(16) null

/

alter table ACI_SRSI

add SECONDARY_CONNECT_FAC_USE Char(1) null

/

alter table ACI_SRSI

add DIVERSE_CIRCUIT_ID VarChar2(36) null

/

alter table ACI_SRSI

add DIVERSE_PON VarChar2(16) null

/

alter table ACI_SRSI

add IP_ADDRESS VarChar2(15) null

/

alter table ACI_SRSI

add SUBNET_MASK VarChar2(15) null

/

alter table ACR_SRSI

add IP_ADDRESS VarChar2(15) null

/

alter table ACR_SRSI

add SUBNET_MASK VarChar2(15) null

/

alter table FIRM_ORDER_CONFIRMATION

add SERVICE_RESERVATION_NUMBER VarChar2(15) null

/

alter table EVC_DETAIL

add EVC_CKR VarChar2(53) null

/

alter table EVC_UNI_MAP

add ASSOC_UNI_NNI_TERM Char(1) null

/

6.0.16.b484

9559056.sql

New

Constraint

alter table FOC_EVC_DETAIL

add constraint PFXPK_FOC_EVC_DETAIL

primary key (DOCUMENT_NUMBER, EVC_NBR)

/

alter table FOC_EVC_DETAIL

add constraint PFXFK_EVC_DETAIL__FOC_EVC_DET

foreign key (DOCUMENT_NUMBER, EVC_NBR)

references EVC_DETAIL (DOCUMENT_NUMBER, EVC_NBR)

/

6.0.16.b484

9559056.sql

New Synonym

Create Public Synonym FOC_EVC_DETAIL for ASAP.FOC_EVC_DETAIL

/

6.0.16.b495

9692262_SAC.sql

Modify

Columns

alter table TQ_SAC_ACTIVITY_INFORMATION modify SERVICE_ACCESS_CODE Number(3) NOT NULL

/

alter table TQ_SAC_NXX add SERVICE_ACCESS_CODE Number(3) not null

/

alter table TQ_SAC_ACTIVITY_INFORMATION modify (SAC_ACTIVITY_NUMBER NULL)

/

alter table TQ_SAC_NXX modify (SAC_ACTIVITY_NUMBER NULL)

/

6.0.16.b495

9692262_SAC.sql

Modify

Constraints

alter table TQ_SAC_ACTIVITY_INFORMATION Drop constraint PK_TQ_SAC_ACTIVITY_INFORMATION

/

alter table TQ_SAC_ACTIVITY_INFORMATION Add constraint PK_TQ_SAC_ACTIVITY_INFORMATION

primary key (DOCUMENT_NUMBER, SERVICE_ACTIVITY_ACTION, SERVICE_ACCESS_CODE)

/

alter table TQ_SAC_NXX Drop constraint FK_TSN_SAC_NXX

/

alter table TQ_SAC_NXX add constraint FK_TSN_SAC_NXX foreign key (DOCUMENT_NUMBER, SERVICE_ACTIVITY_ACTION, SERVICE_ACCESS_CODE) references TQ_SAC_ACTIVITY_INFORMATION (DOCUMENT_NUMBER, SERVICE_ACTIVITY_ACTION, SERVICE_ACCESS_CODE)

/

alter table TQ_SAC_NXX Drop constraint PK_TQ_SAC_NXX

/

alter table TQ_SAC_NXX Add constraint PK_TQ_SAC_NXX primary key (DOCUMENT_NUMBER, SERVICE_ACTIVITY_ACTION, SAC_NXX, SERVICE_ACCESS_CODE)

/

alter table TQ_SAC_NXX Drop constraint CK_FK_TSN_SAC_NXX

/

alter table TQ_SAC_NXX add constraint CK_FK_TSN_SAC_NXX check

((DOCUMENT_NUMBER is null and SERVICE_ACTIVITY_ACTION IS NULL AND SAC_NXX is null and SERVICE_ACCESS_CODE is null) or

(DOCUMENT_NUMBER is not null AND SERVICE_ACTIVITY_ACTION is not null AND SAC_NXX is not null AND SERVICE_ACCESS_CODE is not null))

/

6.0.16.b495

9692262_SAC.sql

Modify

Index

drop index TQ_SAC_ACTIVITY_INFORMATION_PK

/

create unique Index TQ_SAC_ACTIVITY_INFORMATION_PK on TQ_SAC_ACTIVITY_INFORMATION (DOCUMENT_NUMBER, SERVICE_ACTIVITY_ACTION, SERVICE_ACCESS_CODE)

/

6.0.16.b526

9436758.sql

New

Type

Create Type ASAP.TY_TABLE_VC4_STRINGS as table of Varchar2(4)

/

6.0.16.b527

9414461.sql

Modify

Columns

alter table NS_COMPONENT modify

NS_COMP_ACRONYM VarChar2(50)

/

6.0.16.b528

10062929.sql

Add

Columns

alter table CIRCUIT_XREF add

LOCATION_ID Number(9)

/

6.0.16.b542

9812149.sql

New Table

create table PORT_ADDR_CA_VALUE

(

PORT_ADDR_CA_VALUE_ID Number(10,0) not null,

EQUIPMENT_ID Number(10,0) not null,

PORTADDR_SEQ Number(10,0) not null,

CA_VALUE Varchar2(1500) not null

CA_VALUE_LABEL Varchar2 (50) not null,

CA_VALUE_UOM Varchar2 (32) null,

CA_USAGE_ID Number(10,0) not null,

CA_USAGE_VV_ID Number (10,0) null,

MS_BB_ID Number (10,0) not null,

CURRENT_ROW_IND Char(1) not null,

CA_ID Number(10,0) not null,

LAST_MODIFIED_DATE Date not null

LAST_MODIFIED_USERID VarChar2 (32) not null,

) Tablespace DATA

/

6.0.16.b542

9812149.sql

New

Columns

alter table EQUIPMENT_SPEC add MS_BB_ID_PA Number(10,0) null

/

6.0.16.b542

9812149.sql

New sequence

create sequence SQ_PORT_ADDR_CA_VALUE

INCREMENT BY 1

START WITH 10000

MINVALUE 10000

MAXVALUE 999999999999999999999999999

NOCYCLE NOORDER CACHE 20

/

6.0.16.b542

9812149.sql

New Synonym

Create Public Synonym SQ_PORT_ADDR_CA_VALUE for SQ_PORT_ADDR_CA_VALUE

/

Create Public Synonym PORT_ADDR_CA_VALUE for ASAP.PORT_ADDR_CA_VALUE

/

6.0.16.b542

9812149.sql

New Index

create unique index PFXPK_PORT_ADDR_CA_VALUE on PORT_ADDR_CA_VALUE (PORT_ADDR_CA_VALUE_ID asc)

/

create index PFXI_PA_CA_VA__PA on PORT_ADDR_CA_VALUE (EQUIPMENT_ID asc, PORTADDR_SEQ asc)

/

create index PFXI_PA_CA_VA__CA_ID on PORT_ADDR_CA_VALUE (CA_ID asc, CA_VALUE asc)

/

create index PFXI_PA_CA_VA__CA_US on PORT_ADDR_CA_VALUE (CA_USAGE_ID asc)

/

create index PFXI_PA_CA_VA__MS_BU_BL on PORT_ADDR_CA_VALUE (MS_BB_ID asc)

/

create index PFXI_PA_CA_VAL__CA_US_ID on PORT_ADDR_CA_VALUE (CA_USAGE_ID asc, CA_VALUE asc, MS_BB_ID asc)

/

create index PFXI_PA_CA_VA__CA_US_VA_VA on PORT_ADDR_CA_VALUE (CA_USAGE_VV_ID asc)

/

6.0.16.b542

9812149.sql

New

Constraint

alter table PORT_ADDR_CA_VALUE add constraint PFXPK_PORT_ADDR_CA_VALUE primary key (PORT_ADDR_CA_VALUE_ID)

/

alter table PORT_ADDR_CA_VALUE add constraint PFXFK_PA_CA_VA__CA_US foreign key (CA_USAGE_ID) references CA_USAGE (CA_USAGE_ID)

/

alter table PORT_ADDR_CA_VALUE add constraint PFXFK_PA_CA_VA__CA_US_VA_VA foreign key (CA_USAGE_VV_ID) references CA_USAGE_VALID_VALUE (CA_USAGE_VV_ID)

/

alter table PORT_ADDR_CA_VALUE add constraint PFXFK_PA_CA_VA__PA foreign key (EQUIPMENT_ID, PORTADDR_SEQ)

references PORT_ADDRESS (EQUIPMENT_ID, PORTADDR_SEQ)

/

alter table PORT_ADDR_CA_VALUE add constraint PFXFK_PA_CA_VA__MS_BU_BL foreign key (MS_BB_ID) references MS_BUILDING_BLOCK (MS_BB_ID)

/

alter table PORT_ADDR_CA_VALUE add constraint PFXFK_PA_CA_VALUE__CA_CU_AT foreign key (CA_ID) references CA_CUSTOMIZED_ATTRIBUTE (CA_ID)

/

6.0.16.b586

10234378.sql

Add

Columns

alter table SPECIAL_ACCESS add IP_ADDRESS Varchar2(15) null

/

alter table SPECIAL_ACCESS add SUBNET_MASK Varchar2(15) null

/

6.0.16.b586

10234378.sql

Modify

Columns

alter table EVC_LVL_SERV modify

DIFF_SERV_CD_POINT VarChar2(12)

/

6.2.0 GA

9677791. sql

New

Index

Create Index IDX_TA_JE_WH__DA_CL on TASK_JEOPARDY_WHYMISS (DATE_CLOSED asc, JEOPARDY_TYPE_CD asc, ORDER_JEOP_DOC_NUM asc) Tablespace INDEXES

/

6.2.0 GA

8637316. sql

New

Table

Create Table CREDENTIAL_STORE (CRED_NAME Varchar2(100 BYTE) NOT NULL ENABLE,

CRED_WORD RAW(32), CONSTRAINT CREDENTIAL_STORE_PK PRIMARY KEY (CRED_NAME))

/

Create PUBLIC SYNONYM CREDENTIAL_STORE FOR ASAP.CREDENTIAL_STORE

/

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2017, Oracle and/or its affiliates. All rights reserved.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

Hazardous Applications Notice

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

Third-Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Pre-General Availability Draft Documentation Notice

If this document is in public or private pre-General Availability status:

This documentation is in pre-General Availability status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

Private Pre-General Availability Draft Documentation Notice

If this document is in private pre-General Availability status:

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your pre-General Availability trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has been executed by you and Oracle and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.