7.2.1 To 7.3 Upgrade Scripts Sets Cycle_end_details Field Incorrectly (Doc ID 1617873.1)

Last updated on FEBRUARY 03, 2014

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.0.0.0 [Release 7.3.0]
Information in this document applies to any platform.

Symptoms

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):

 

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