Plan Transition Entry Is Not Removed in BRM (Doc ID 2859638.1)

Last updated on FEBRUARY 06, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
-----------------------

After removing plan transition entry in Pricing Design Center (PDC), which is successfully submitted to Billing and Revenue Management (BRM) from Realtime Rating Engine (RRE) transformation engine, but BRM is still allowing for plan transition.
It is seen that entry for plan transition still exists in BRM table transition_t, even after removing it from PDC.
After manually deleting entry from transition_t (for sake of testing), plan transition fails as expected.

EXPECTED BEHAVIOR
-----------------------

Plan transition should be removed from BRM as well.

STEPS
-----------------------

1. create a package_1 in PDC
2. create a package_2 in PDC
3. in PDC, open package_1, go to Transition tab, add package_2
4. submit changeset
5. go to BRM database and check:
   
   select * from transition_t;
   1 113978 /transition 0 1631642444 1631643618 B S 1 1 /account 0 /service/telco/gsm/telephony 28800 0 1 107558 /plan 2 1 119240 /plan 0 2 3
   
   
6. in PDC, open package_1, go to Transition tab, remove the package_2 and submit changeset
7. go to BRM database and check:
   
   select * from transition_t;
   1 113978 /transition 1 1631642444 1631643618 B S 1 1 /account 0 /service/telco/gsm/telephony 28800 0 1 107558 /plan 2 1 119240 /plan 0 2 3
   
   
8. only the POID_REV changed from 0 to 1, nothing else.
9. it is expected that this row is deleted from this table.

Cause

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