My Oracle Support Banner

Upgrade 7.0 To 7.5PS4: Relative Offset Unit Of deal_products_t Changed From Days To Minutes In upgrade_configurable_validity_pricing.sql (Doc ID 1585072.1)

Last updated on MARCH 21, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.0.0.0.0 to 7.5.0.0.0 [Release 7.0.0 to 7.5.0]
Information in this document applies to any platform.

Purpose

 After the upgrade from 7.0 -> 7.5 PS4, the relative offset of the deal_products_t has been converted from days to minutes.
 
The values are being updated in the upgrade_configurable_validity_pricing.sql file in the 7.0 -> 7.3 upgrade package. The value in minutes is still correct, but this would be unacceptable to the user.

The description of the upgrade_configurable_validity_pricing.sql:

  

Questions and Answers

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
Purpose
Questions and Answers
 It appears that the data falls into the 1048576 to 31457220 range (i.e CYCLE_START_T, CYCLE_END_T, etc...), which is the # of seconds (i.e. in this case 62 days = 5356800 seconds). However, the user needs this data in # of days, as it was in 7.0, and not as it is in # of minutes post-upgrade.
 The user has configured some products to start 365 days in the future. In the converted 7.5PS4 data, the cycle_start_details are negative values.
In the upgrade_configurable_validity_pricing.sql, the values are hitting the next range, For example:
 Is this value 525600 correct? 
References


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