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 22.214.171.124.0 to 126.96.36.199.0 [Release 7.0.0 to 7.5.0]
Information in this document applies to any platform.
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:
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
|Questions and Answers|
|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? |