"validity_in_days" Attribute Not Set When Configuring Balance Elements In PDC (Doc ID 2150637.1)

Last updated on JUNE 08, 2022

Applies to:

Symptoms

On : 11.1.0.7.0 version, User Interface

The default value of "validity_in_days" attribute has not been set when configuring Balance Elements in PDC; however, ECE needs it to properly load data to cache.

The below SQL from customer updater logs when ECE loads to cache sub-balances:

Note that: 1459858369 = sysdate (05 Apr 2016 12:12:49 GMT; system time zone is +2)

In case of validity_in_days is set to zero, ECE reads only sub-balances with valid_to greater than now. This means all sub-balances that have valid_to set but expired (sysdate < valid_to) are not loaded to ECE cache.

There would be issues in case of late calls or rerating after migration or ECE restart. Missing attribute is also used by ECE, but it cannot be set it in PDC.

ACTUAL BEHAVIOR
-----------------------
The default value of "validity_in_days" attribute has not been set when configuring Balance Elements in PDC

EXPECTED BEHAVIOR
---------------------------
It should be possible to override default "validity_in_days" value for selected balance element.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) configure new balance element 'Sample BE'
2) create offer 'Sample Offer' that grants number of resources on balance element 'Sample BE' with validity date 1 day
3) create customer and purchase 'Sample Offer'; check 'Sample BE' sub-balance validity
4) two days after restart ECE and check if ECE cache has loaded customer's sub-balance for 'Sample BE'

Changes

Cause

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