Cycle Fold Product Started to Behave Incorrectly When Cost-Based Optimizer Used (Doc ID 407532.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version: 6.1.0.1.1 and later   [Release: 6.1.0 and later ]
Information in this document applies to any platform.
Checked for relevance on 21-Aug-2008.
Checked for relevance on 17-Jan-2012.

Symptoms

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.

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