7.2.1 To 7.3 Upgrade Scripts Sets Cycle_end_details Field Incorrectly
Last updated on FEBRUARY 03, 2014
Applies to:Oracle Communications Billing and Revenue Management - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 7.3.0]
Information in this document applies to any platform.
The upgrade scripts set the field cycle_end_details on deal_products_t to 1 if the product does not expire.
As per the documentation, 1 stands for PIN_VALIDITY_IMMEDIATE and should be used to the cycle_start_details. The user would expect the field to be set to PIN_VALIDITY_NEVER (2) instead.
This can also be proved that when the products are loaded via the loadpricelist application, the flag PIN_VALIDITY_NEVER is set.
Please review the following lines in the upgrade script (upgrade_configurable_validity_pricing.sql):
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