Business Parameter to Enable or Disable Rounding of Purchase Event Grant Validity to Midnight (Doc ID 1903675.1)

Last updated on JUNE 14, 2022

Applies to:

Symptoms

The sub-balance valid_from is getting rounded to midnight with the purchase fee event balance impact.

Currently, if the timestamp rounding is enabled, - fm_bill timestamp_rounding 1, all non-currency resources which are granted through the cycle forward event, bal_grp_sub_bals_t.valid_from is getting rounded to mid night.

A business requirement is that if users need to create one time product, which will grant resources on daily or hourly basis, resource validity should start immediately when the product purchased and end after the specified hours or days.

For example:
Granting 100KB for 10 Hrs validity
Purchase a product on 06-May-2014 07:00:00 AM

Expected result:
Resource validity should be 06-May-2014 07:00:00 AM to 06-May-2014 05:00:00 PM.

Actual result:
Resource validity is 06-May-2014 00:00:00 AM to 06-May-2014 10:00:00 AM.

This behavior is due to the reason that the valid_from is getting rounded to midnight.

In Billing and Revenue Management (BRM) document, BRM Documentation -> Setting Up Pricing and Rating ->About tracking resources in account sub-balances, it is specified that:
If the timestamp_rounding entry in the CM pin.conf file is enabled,
the start time of the resources granted by cycle events is rounded to midnight.
However, the start time of the resources granted by purchase events is not rounded to midnight.

Cause

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