My Oracle Support Banner

Product Spec Characteristic Attribute Is Getting Deleted During Rate Plan Sync (Doc ID 3012767.1)

Last updated on MAY 09, 2024

Applies to:

Oracle Communications Pricing Design Center - Version 12.0.0.7.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
In Pricing Design Center (PDC), the user observes that while synching the rate plan in the charge offer, then automatically product spec characteristic attribute is getting deleted.

EXPECTED BEHAVIOR
-----------------------
Product spec characteristic attribute should not be deleted automatically

 

The issue can be reproduced at will with the following steps:

1. Copied the file ProductSpecCharacteristicTemplate.xml in cd ${PDC_HOME}\apps\bin

---> cd ${PDC_HOME}\apps\bin
--->./ImportExportPricing -ow -import -config ProductSpecCharacteristicTemplate.xml -appsvruser ##### -pdcuser ##### 

2. Created a Charge Offer ::C2_ChargeOffer
Event --->Cycle Forward Event
Service ---> /service/ip
Amount Credit :85 USD
--
select poid_id0,poid_type,name,permitted,attribute_obj_id0,attribute_obj_type
from product_t
where permitted ='/service/ip'
and name = 'C2_ChargeOffer';

POID_ID0 POID_TYPE NAME PERMITTED ATTRIBUTE_OBJ_ID0 ATTRIBUTE_OBJ_TYPE
2312790 /product C2_ChargeOffer /service/ip 2310742 /offer_attribute_group

3. Create a ChargeSelector :CS_NT_ChargeSelector_01 ..In Rules tab for Charge I select chargeOffer 'C2_ChargeOffer'

4. Run the below commands
./ImportExportPricing -export CHARGE_RATE_PLAN -appsvruser weblogic -pdcuser pdcuser

The below three files are getting created

-->CHARGE_RATE_PLAN_brm_object.xml
-->CHARGE_RATE_PLAN_profile.xml
-->CHARGE_RATE_PLAN_pricing.xml

4. Check the attached xml files

<priceTier>

<lowerBound>NO_MIN</lowerBound>
<tierBasis>
<rumTierExpression/>
</tierBasis>
<rumName>Occurrence</rumName>
<enforceCreditLimit>NORMAL</enforceCreditLimit>
<tierRange>
<upperBound>NO_MAX</upperBound>
<recurringCharge>
<price>-85.0</price>              ------------------------> change this to 8 USD
<unitOfMeasure>NONE</unitOfMeasure>
<balanceElementNumCode>840</balanceElementNumCode>
<discountable>true</discountable>
<priceType>GRANT</priceType>
<priceValidity>
<startValidityMode>IMMEDIATE</startValidityMode>
<endValidityMode>NEVER</endValidityMode>
<validityRange>0/inf</validityRange>
<relativeStartOffset>-1</relativeStartOffset>
<relativeEndOffset>-1</relativeEndOffset>


5. Run the below commands
./ImportExportPricing -import -ow -pricing CHARGE_RATE_PLAN_pricing.xml -appsvruser weblogic -pdcuser pdcuser

 After re-loading the modified chargeRatePlan, then offer attribute spec object is getting deleted in /offer_attribute_group.



Cause

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
Symptoms
Cause
Solution
References


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