Billing Fails For Accounts Which Include A Cycle Fold Product With OP_ZONEMAP_POL_GET_LINEAGE Error (Doc ID 944117.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 12-Mar-2012.


Symptoms

When billing occurs with a specific product that has a cycle fold, an account owning this product fails to bill (with an error). The error indicates that the zone map cannot be found. But, there are no zonemaps in the system.

Error : op_zonemap_pol_get_lineage error: Can't find requested zonemap in DB
<location=PIN_ERRLOC_FM:5 class=PIN_ERRCLASS_APPLICATION:4 errno=PIN_ERR_NO_MATCH:2>


Steps To Reproduce:

1)  Create a Deal with a product ( containing fold )
     Let us assume that below is the XML file for the product :

<?xml version="1.0" encoding="UTF-8"?>
<price_list version="7.2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="price_list.xsd">
<plan ondemand_billing="no">
<plan_name>Migration Plan</plan_name>
<description>Created By Giovanni For Migration Purposes</description>
</plan>
<deal customization_flag="optional" ondemand_billing="no">
<deal_name>Web Hosting - Personal (Yearly)</deal_name>
<description>5Mb of personal web space. R27 per year per Mb</description>
<permitted>/service/web</permitted>
<deal_product status="active">
<product_name>Web Hosting - Personal (Yearly)</product_name>
<quantity>5.0</quantity>
<purchase_discount>0.0</purchase_discount>
<cycle_discount>0.0</cycle_discount>
<usage_discount>0.0</usage_discount>
</deal_product>
</deal>
<product partial="no" type="subscription">
<product_name>Web Hosting - Personal (Yearly)</product_name>
<priority>0.0</priority>
<description>Web Hosting - Personal (Yearly)</description>
<purchase_min>0.0</purchase_min>
<own_min>0.0</own_min>
<permitted>/service/web</permitted>
<provisioning>UX5TD</provisioning>
<event_rating_map incr_unit="none" min_unit="none" rounding_rule="down" timezone_mode="server" tod_mode="start_time">
<event_type>/event/billing/cycle/fold</event_type>
<rum_name>Fold</rum_name>
<min_quantity>1.0</min_quantity>
<incr_quantity>1.0</incr_quantity>
<rate_plan_selector>
<rate_plan_selector_name>Rate Plan Selector</rate_plan_selector_name>
<selector>
<column operator="in">
<field_name>PIN_FLD_FOLD.PIN_FLD_RESOURCE_ID</field_name>
</column>
<value_range>
<value>1000004</value>
<rate_plan_name>Fold1</rate_plan_name>
<impact_category>default</impact_category>
</value_range>
</selector>
</rate_plan_selector>
<rate_plan advance_billing_unit="day" tax_when="defer">
<rate_plan_name>Fold1</rate_plan_name>
<currency_id>710</currency_id>
<event_type>/event/billing/cycle/fold</event_type>
<tax_code>VAT</tax_code>
<advance_billing_offset>0</advance_billing_offset>
<cycle_fee_flags>0</cycle_fee_flags>
<rate_tier date_range_type="absolute">
<rate_tier_name>Fold1 rate tier 0 priority 0.000000</rate_tier_name>
<priority>0.0</priority>
<rate prorate_first="prorate" prorate_last="full" step_type="total_quantity_rated" type="normal">
<description>Remove unused web traffic</description>
<step_resource_id>0</step_resource_id>
<quantity_tier>
<balance_impact scaled_unit="none">
<resource_id>1000004</resource_id>
<glid>1009555</glid>
<fixed_amount>0.0</fixed_amount>
<scaled_amount>-1.0</scaled_amount>
</balance_impact>
</quantity_tier>
</rate>
</rate_tier>
</rate_plan>
</event_rating_map>
<event_rating_map incr_unit="none" min_unit="none" rounding_rule="down" timezone_mode="server" tod_mode="start_time">
<event_type>/event/billing/product/fee/cycle/cycle_forward_annual</event_type>
<rum_name>Occurrence</rum_name>
<min_quantity>1.0</min_quantity>
<incr_quantity>1.0</incr_quantity>
<rate_plan_name>cycle_forward_annual</rate_plan_name>
<rate_plan advance_billing_unit="day" tax_when="defer">
<rate_plan_name>cycle_forward_annual</rate_plan_name>
<currency_id>710</currency_id>
<event_type>/event/billing/product/fee/cycle/cycle_forward_annual</event_type>
<tax_code>VAT</tax_code>
<advance_billing_offset>0</advance_billing_offset>
<cycle_fee_flags>0</cycle_fee_flags>
<rate_tier date_range_type="absolute">
<rate_tier_name>cycle_forward_annual rate tier 0 priority 0.000000</rate_tier_name>
<priority>0.0</priority>
<rate prorate_first="full" prorate_last="full" step_type="total_quantity_rated" type="default">
<description>Web Hosting - Personal (Yearly)</description>
<step_resource_id>0</step_resource_id>
<quantity_tier>
<step_min>0.0</step_min>
<step_max>10000000</step_max>
<balance_impact flag="discountable" scaled_unit="none">
<resource_id>710</resource_id>
<impact_category>default</impact_category>
<glid>1009555</glid>
<fixed_amount>0.0</fixed_amount>
<scaled_amount>24.771929824561404</scaled_amount>
</balance_impact>
</quantity_tier>
</rate>
</rate_tier>
</rate_plan>
</event_rating_map>
</product>
</price_list>

2)  Purchase the above deal

3)  Run billing.

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