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

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

Consider another scenario reported with the same issue :

Scenario :

• Scenario involves testing of Backout pipeline using the following test cases:

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

• It is expected that the invoice of Test case 1 and 2 show same amounts but they are not the same.
• There seems to be a difference in the tax calculation.
• For example, below is the difference found between the tax computation :
         The tax computed in Test case 2 is correct (20% tax) : (5.824999 + 0.83333) * 0.20 = 1.331666
         The tax computed in Test case 2 is incorrect: (5.824999 + 0.83333 + 0.83333) * 0.20 = 1.498332
• It means that in Test case 1, the tax was not cancelled when the the usage of Jul 17th was cancelled (using backout pipeline)

Question :

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

Solution

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