My Oracle Support Banner

Status Remains 1 in EVENT_BILLING_PRODUCT_ACTION_T After Product is Cancelled (Doc ID 1592762.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.5.0]
Information in this document applies to any platform.


When inactivating a service or cancelling a product, status of associated product cancellation event is not set to 3 (INACTIVATED) in the table EVENT_BILLING_PRODUCT_ACTION_T as per documentation under "Storable Class Reference" :

Definition of Class /event/billing/product/action, and check definition of PIN_FLD_STATUS :
"Status of this product. Legal values are NOT_SET(0), ACTIVE(1), INACTIVE(2), CANCELLED(3). Only active products are assessed for cycle fees and participate in usage rating. For delayed usage events, Cancelled products are also considered."

For more information about BRM, please refer to Billing and Revenue Management 7.5 Documentation here

Steps to reproduce:

1- Create product/deal/plan ( example, product with MCF event)
2- Using Customer Center (CC) create account and purchase the product.
3- Check generated events from table EVENT_BILLING_PRODUCT_ACTION_T  (STATUS value is 1)
4- Cancel the prodcut/deal using CC.
5- Check event in table EVENT_BILLING_PRODUCT_ACTION_T. Status value remains 1 instead of 3.




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

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