How To Extract Complete Information Regarding Discount Model Using "LoadIfwConfig"
Last updated on MARCH 27, 2018
Applies to:
Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.1.0 [Release 7.4.0]Information in this document applies to any platform.
Checked for relevance on 03-Feb-2015.
Goal
LoadIfwConfig doesn't extract complete information regarding discount model. There are about 10 tables for discount related data, but the utility doesn't export the data from the following ones:
IFW_DISCOUNTDETAIL
IFW_DISCOUNTSTEP
IFW_DSCBALIMPACT
IFW_DISCOUNTSTEP
IFW_DSCBALIMPACT
Steps to reproduce :
1) create an input.xml file with:
<?xml version="1.0" encoding="UTF-8"?>
<IFW xsi:noNamespaceSchemaLocation="LoadIfwConfig.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<RecordSet>
<IFW_DSCMDL_VER DISCOUNTMODEL ="DM10%OFF" />
</RecordSet>
</IFW>
<IFW xsi:noNamespaceSchemaLocation="LoadIfwConfig.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<RecordSet>
<IFW_DSCMDL_VER DISCOUNTMODEL ="DM10%OFF" />
</RecordSet>
</IFW>
2) Run the command:
LoadIfwConfig -r -i input.xml -o output.xml
3) Check content of output xml:
<?xml version="1.0" encoding="UTF-8"?>
<IFW xsi:noNamespaceSchemaLocation="LoadIfwConfig.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<RecordSet>
<IFW_DSCTRIGGER CODE ="DT10%OFF" DISCOUNTTRIGGER ="DT10%OFF" NAME ="Discount Trigger For Taking 10% Off" >
<IFW_DSCCONDITION COND_EXPRESSION ="TotalC" COND_OPERATOR ="GE" CONDITION_VALUE ="0" DISCOUNTTRIGGER ="DT10%OFF" />
</IFW_DSCTRIGGER>
<IFW_DISCOUNTMASTER CODE ="DA10%OFF" DISCOUNTMASTER ="DA10%OFF" NAME ="Discount Master For Taking 10% Off" />
<IFW_DISCOUNTRULE CODE ="DR10%OFF" DISCOUNTMASTER ="DA10%OFF" DISCOUNTRULE ="DR10%OFF" DRUM_EXPRESSION ="TotalQ" DRUM_TYPE ="Q" NAME ="Discount Rule for Taking 10% Off" RULE_TYPE ="1" />
<IFW_DISCOUNTMODEL CHARGESHARE_FLAG ="0" CODE ="DM10%OFF" DISCOUNTMODEL ="DM10%OFF" NAME ="Discount Model for Taking 10% Discount" />
<IFW_DSCMDL_VER DISCOUNTMODEL ="DM10%OFF" STATUS ="A" VALID_FROM ="1999-01-01T00:00:00" VERSION ="1" >
<IFW_DSCMDL_CNF DISCOUNTMODEL ="DM10%OFF" DISCOUNTRULE ="DR10%OFF" DISCOUNTTRIGGER ="DT10%OFF" DSC_MODE ="0" RANK ="1" VERSION ="1" />
</IFW_DSCMDL_VER>
</RecordSet>
</IFW>
<IFW xsi:noNamespaceSchemaLocation="LoadIfwConfig.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<RecordSet>
<IFW_DSCTRIGGER CODE ="DT10%OFF" DISCOUNTTRIGGER ="DT10%OFF" NAME ="Discount Trigger For Taking 10% Off" >
<IFW_DSCCONDITION COND_EXPRESSION ="TotalC" COND_OPERATOR ="GE" CONDITION_VALUE ="0" DISCOUNTTRIGGER ="DT10%OFF" />
</IFW_DSCTRIGGER>
<IFW_DISCOUNTMASTER CODE ="DA10%OFF" DISCOUNTMASTER ="DA10%OFF" NAME ="Discount Master For Taking 10% Off" />
<IFW_DISCOUNTRULE CODE ="DR10%OFF" DISCOUNTMASTER ="DA10%OFF" DISCOUNTRULE ="DR10%OFF" DRUM_EXPRESSION ="TotalQ" DRUM_TYPE ="Q" NAME ="Discount Rule for Taking 10% Off" RULE_TYPE ="1" />
<IFW_DISCOUNTMODEL CHARGESHARE_FLAG ="0" CODE ="DM10%OFF" DISCOUNTMODEL ="DM10%OFF" NAME ="Discount Model for Taking 10% Discount" />
<IFW_DSCMDL_VER DISCOUNTMODEL ="DM10%OFF" STATUS ="A" VALID_FROM ="1999-01-01T00:00:00" VERSION ="1" >
<IFW_DSCMDL_CNF DISCOUNTMODEL ="DM10%OFF" DISCOUNTRULE ="DR10%OFF" DISCOUNTTRIGGER ="DT10%OFF" DSC_MODE ="0" RANK ="1" VERSION ="1" />
</IFW_DSCMDL_VER>
</RecordSet>
</IFW>
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