Pricemodel Field In IFW_RATEPLAN_CNF Is Missing Constraint (Doc ID 1417234.1)

Last updated on JANUARY 25, 2016

Applies to:

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

Goal

While inserting records to the IFW_RATEPLAN_CNF table, the PRICEMODEL field is accepting null values. As a result, records matching the Impact Category with the null pricemodel are being rejected.

Would like to know if this is a known issue and if a patch exist to solve the problem or if we need to create the constraint directly in the database.

Insert into IFW_RATEPLAN_CNF
(RATEPLAN, VERSION, SERVICECODE, SERVICECLASS, IMPACT_CATEGORY, TIMEMODEL, TIMEZONE, PRICEMODEL, PASSTHROUGH, ADDON_TYPE, ADDON_CHARGE, ENTRYBY, ENTRYDATE, MODIFDATE, MODIFIED, RECVER)
Values
((SELECT RATEPLAN FROM IFW_RATEPLAN WHERE CODE = 'ATT_RP'), (SELECT MAX(VERSION) FROM IFW_RATEPLAN_VER WHERE RATEPLAN = (SELECT RATEPLAN FROM IFW_RATEPLAN WHERE CODE = 'ATT_RP')), 'GPRS', 'DEF', 'GPRS',
20004, 20007, (SELECT PRICEMODEL FROM IFW_PRICEMODEL WHERE CODE = 'KB-0.00010'),
0, 'P', 0, 100,
SYSDATE, SYSDATE, 1, 0);

Note:
The result of (SELECT PRICEMODEL FROM IFW_PRICEMODEL WHERE CODE = 'KB-0.00010') is NULL


Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms