Unable To Update a Field Value To NULL Using The LoadIfwConfig Utility (Doc ID 751999.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.2.1.0.0 to 7.2.1.0.0 [Release 7.2.1]
HP-UX Itanium
Checked for relevance on 21-Dec-2010.


Symptoms

Unable to change a field value to NULL using the LoadIfwConfig utility. The change doesn't have impact
to the DB.

Steps To Reproduce:
For example, an input XML file has the following data:

<IFW xmlns="http://www.portal.com/tools/pricing"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.portal.com/tools/pricing ./IfwConfig.xsd">

<Discountmaster Code ="DSRG000004" Name = "LoadIfwConfig Test" />
<Discountdetail Discountmaster="DSRG000004" Rank="1" ValidFrom="20040101" ValidTo="20090101"
TimeFrom="" TimeTo="" Zonemodel=".*" ImpactCategory="INTE_MDA" Servicecode=".*" Serviceclass=".*"
Usagetype=".*" Usageclass=".*" Timemodel=".*" Timezone=".*" Pricemodel=".*" Ressource="32|0"
Rum=".*" Recordtype=".*" RatePlan=".*" RateTag=".*" Glid=".*" /></IFW>


1. Run the LoadIfwConfig command as following:

LoadIfwConfig -v -i <input_XML_file> -u -c


2. Do a query as following to verify the value

SQL> select disD.valid_to, disM.code from ifw_discountdetail disD, ifw_discountmaster disM where disD.discountmaster = disM.discountmaster;


3. Modify the above ValidTo="20090101" to ValidTo= "" in Discountdetail and the rest of the values unchanged.

4. Run the command again

LoadIfwConfig -v -i <input_XML_file> -u -c



5. Do the same query to verify the value again

SQL> select disD.valid_to, disM.code from ifw_discountdetail disD, ifw_discountmaster disM where disD.discountmaster = disM.discountmaster;


The value for valid_to does not change.


Cause

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