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

Last updated on FEBRUARY 19, 2024

Applies to:

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 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)
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

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