My Oracle Support Banner

Impact of Disabling PK_IFW_STZ Constraint on IFW_STANDARD_ZONE Table (Doc ID 2504412.1)

Last updated on OCTOBER 02, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.17.0 and later
Information in this document applies to any platform.

Goal

On Oracle Communications Billing and Revenue Management version 7.5.0.17.0, as per business requirements, there is a need to use shared zone model for different rate plans, which implies creating same combination of "ZONEMODEL", "ORIGIN_AREACODE", "DESTIN_AREACODE", and "SERVICECODE" in IFW_STANDARD_ZONE table.

As there is a constraint PK_IFW_STZ on this table which does not allow having same combination of "ZONEMODEL", "ORIGIN_AREACODE", "DESTIN_AREACODE", "SERVICECODE" in IFW_STANDARD_ZONE table, this constraint has to be disabled.

Question: What is the impact if this constraint is disabled?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.