Pricemodel Field In IFW_RATEPLAN_CNF Is Missing Constraint
(Doc ID 1417234.1)
Last updated on DECEMBER 05, 2019
Applies to:Oracle Communications Billing and Revenue Management - Version 126.96.36.199.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 there is a 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
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