AMOUNT_DEFERRED Is Incorrectly Derived During Manual Re-Rating Using Pin_event_extract And Backout Pipeline (Doc ID 1148633.1)

Last updated on JANUARY 30, 2015

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.1.0.0 [Release 7.3.0 to 7.3.1]
Information in this document applies to any platform.
***Checked for relevance on 28-Oct-2013***

Goal

Re-rated events have incorrect amount_deferred attribute set within their balance impacts for events with deferred taxation.
Balance impacts for re-rating events, which were identified as a shadow adjustment have incorrect sign for the amount_deferred attribute (adding the charge to the total sum instead of subtracting it).

Selected balance impact from the original event

0 PIN_FLD_BAL_IMPACTS ARRAY [0] allocated 22, used 22
1 PIN_FLD_AMOUNT DECIMAL [0] 0,0837
1 PIN_FLD_AMOUNT_DEFERRED DECIMAL [0] 0,0837
1 PIN_FLD_IMPACT_TYPE ENUM [0] 258
1 PIN_FLD_RESOURCE_ID INT [0] 978



Actual re-rating balance impact (shadow adjustment)

0 PIN_FLD_BAL_IMPACTS ARRAY [0] allocated 22, used 22
1 PIN_FLD_AMOUNT DECIMAL [0] -0,0837
1 PIN_FLD_AMOUNT_DEFERRED DECIMAL [0] 0,0837
1 PIN_FLD_IMPACT_TYPE ENUM [0] 288
1 PIN_FLD_RESOURCE_ID INT [0] 978


Expected re-rating balance impact (shadow adjustment)

0 PIN_FLD_BAL_IMPACTS ARRAY [0] allocated 22, used 22
1 PIN_FLD_AMOUNT DECIMAL [0] -0,0837
1 PIN_FLD_AMOUNT_DEFERRED DECIMAL [0] -0,0837
1 PIN_FLD_IMPACT_TYPE ENUM [0] 288
1 PIN_FLD_RESOURCE_ID INT [0] 978


Consider another scenario reported with the same issue :

Scenario :

Test case 1

Jun 15th : account creation (bdom = 15)
Jul 16th : accounting + billing
Jul 17th : rating usages worth total amount 0.833
Jul 17th : cancelling all the usages using Backout pipeline
Jul 18th : rating usages again worth total amount 0.833
Aug 18th : accounting + billing

Test case 2

Jun 15th : account creation (bdom = 15)
Jul 16th : accounting + billing
Jul 18th : rating usage worth amount 0.833
Aug 18th : accounting + billing


Question :

What is the reason for the above behavior and how can one get the correct tax calculation in Test case 1 ?

Solution

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