UseLatestProductAndDiscont Does Not Work As Documented (Doc ID 1070342.1)

Last updated on FEBRUARY 24, 2021

Applies to:

Goal

Pipeline document 7.3.1 mentioned if set UseLatestProductAndDiscont as true, pipeline will only check start_t and end_t. But rating result is not as expected.

online documents says:
You can use the DAT_Account module UseLatestProductAndDiscount registry entry to configure validity checking for account products and discounts.
If you enable this entry, when rating EDRs, DAT_AccountBatch retrieves account product and discount information based only on their start and end dates.

Example
On 1,Jan, 2010, customer purchase plan A.
On 15,Jan, 2010, customer cancelled the plan with future data to 1,Feb, 2010.
In purchased_product_t, the record is as (effective_t 2010/2/1, usage_start_t 2010/1/1, usage_end_t 2010/2/1).

On 16,Jan, a cdr with data of 16, Jan, comes and be rejected.

If pipeline only checkes start/end dates, the CDR shall be rated. As Start_t is 2010/1/1, and end_t is 2010/2/1. But the result is the CDR be rejected.

If UseLatestProductAndDiscount is set, does it check effective_t also ?

Solution

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