Pricemodel Field In IFW_RATEPLAN_CNF Is Missing Constraint
Last updated on JANUARY 25, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
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)
((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);
The result of (SELECT PRICEMODEL FROM IFW_PRICEMODEL WHERE CODE = 'KB-0.00010') is NULL
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