My Oracle Support Banner

Is It Possible To Configure Pipeline To Use usage_start_t For Rating Instead Of effective_t (Doc ID 2056831.1)

Last updated on SEPTEMBER 05, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Goal

On : BRM Pipeline Manager / Main rating module

When purchasing a product, the Pipeline is taking the effective_t value instead the usage_start_t for rating.

For example:

SQL> select EFFECTIVE_T, USAGE_START_T, USAGE_END_T from purchased_product_t where poid_id0 = 38291263032;

     EFFECTIVE_T           USAGE_START_T           USAGE_END_T
     -------------------   ----------------------  ------------------------
     1439000135            1438927200              0


From the memory dump of Pipeline manager:
    For Product Info that is valid from 1438927200 to 0
      Effective from 1439000135 to 2147483647 Status 1
      Plan Id 0 Deal Id 0 Package Id 16747378
      First Usage Indicator FALSE FirstUsage Validity Set TRUE GroupBy Resource FALSE
      Purchase Instantiated Time 1438927200
      Product Video LLLLL, created  1310697786  valid from 1262322000  to 0
      Product Video LLLLL, created  1310148349  valid from 1262322000  to 0
      Product Video LLLLL, created  1308817447  valid from 1262322000  to 0

      Service 32086472247 Service type /service/telco/gsm/telephony valid from 1429920493 to 1439000135
        needsProfUpdM: FALSE

Is there a way to configure the Pipeline to use the usage_start_t for rating instead of the effective_t?

Solution

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
Goal
Solution
References


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