Cycle Fold Product Started to Behave Incorrectly When Cost-Based Optimizer Used
Last updated on JUNE 22, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version: 188.8.131.52.1
Information in this document applies to any platform.
Checked for relevance on 21-Aug-2008.
Checked for relevance on 17-Jan-2012.
As a result of changing the Oracle database from 'RULE' based to 'COST' based configuration, cycle folds no longer applied correctly.
The pricing plan is based such that cycle_folds rely on resource IDs existing in numerical order (from lowest to highest) in order to apply correctly. Once the database is in 'COST' base, the resource IDs no-longer exist in numerical order. This is plainly seen in the PIN_FLD_BALANCE array of the account object. As a result, the product folds do not apply in the correct sequence, resulting in folds not applying at all.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms