Unable To Purchase A Deal And Cancel An Existing Service In One Transaction: fm_subs_find_rp_using_act_usage() Error (Doc ID 558427.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.0.0.0 [Release 7.3.0]
Information in this document applies to any platform.
checked for relevance on 11th aug 2010
Checked for relevance on 20-Feb-2012.
***Checked for relevance on 28-November-2015***

Symptoms

Not able to purchase a deal AND cancel an existing service in one transaction.

A user has upgraded from 6.0.3 to 7.3. A custom Java code performs purchasing a new plan (with new services) and cancels an existing service in one transaction. The existing service is associated with monthly cycle arrear event which uses rate plan selector. Depending on the value of a service attribute, it has different rate plans configured. Proration is set on the cycle arrear product.

The purchase and cancellation operations work however, in the following cases:
1. In two transactions: Purchase the plan and cancel the service with cycle arrear event separately
2. In one transaction: When the service is associated with monthly cycle forward event instead of cycle arrear event

cm.pinlog snippet with the error:

D Wed Jan 30 13:28:54 2008 myhost cm:9888 fm_act_usage.c:795 1:myhost:UnknownProgramName:0:main:86:1201717734:0
   op_act_usage output flist
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 2425437 0
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 16
1    PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/product/fee/cycle/cycle_arrear -1 0
1    PIN_FLD_NAME STR [0] "Billing Event Log"
1    PIN_FLD_USERID POID [0] 0.0.0.1 /service/pcm_client 1 3
1    PIN_FLD_SESSION_OBJ POID [0] 0.0.0.1 /event/session 244672123516397800 0
1    PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 2425437 0
1    PIN_FLD_PROGRAM_NAME STR [0] "Service Upgrade Process: Purchase New Plan"
1    PIN_FLD_START_T TSTAMP [0] (1201717734) Wed Jan 30 13:28:54 2008
1    PIN_FLD_END_T TSTAMP [0] (1201717734) Wed Jan 30 13:28:54 2008
1    PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/ip/connectivity/bandwidth 10660970 0
1    PIN_FLD_FLAGS INT [0] 33554448
1    PIN_FLD_SYS_DESCR STR [0] "Cycle Arrears Fees (srvc): 100mb Dual - with Cycle Arrears"
1    PIN_FLD_CYCLE_INFO SUBSTRUCT [0] allocated 20, used 5
2       PIN_FLD_CYCLE_START_T TSTAMP [0] (1201842000) Fri Feb 01 00:00:00 2008
2       PIN_FLD_CYCLE_END_T TSTAMP [0] (1201669200) Wed Jan 30 00:00:00 2008
2       PIN_FLD_FLAGS INT [0] 33554448
2       PIN_FLD_ORIGINAL_SCALE DECIMAL [0] 1
2       PIN_FLD_SCALE DECIMAL [0] 0.00000000000000000000
1    PIN_FLD_PRODUCT SUBSTRUCT [0] allocated 20, used 2
2       PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 10611327 0
2       PIN_FLD_OFFERING_OBJ POID [0] 0.0.0.1 /purchased_product 10661482 1
1    PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 10260488 1
1    PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 10255845 0
1    PIN_FLD_RATING_STATUS ENUM [0] 10
E Wed Jan 30 13:28:54 2008 myhost cm:9888 fm_subscription_cycle_utils.c:10006 1:myhost:UnknownProgramName:0:main:86:1201717734:0
   fm_subs_find_rp_using_act_usage() error
   <location=PIN_ERRLOC_FLIST:6 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1 errno=PIN_ERR_NOT_FOUND:3>
   <field num=PIN_FLD_RATE_PLANS:9,2237 recid=0 reserved=0 reserved2=0 time (sec:usec)=0:0>
   <facility=0 msg_id=0 version=0>
E Wed Jan 30 13:28:54 2008 myhost cm:9888 fm_subscription_cycle_utils.c:9662 1:myhost:UnknownProgramName:0:main:86:1201717734:0
   fm_subs_utils_get_rateplan() error
   <location=PIN_ERRLOC_FLIST:6 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1 errno=PIN_ERR_NOT_FOUND:3>
   <field num=PIN_FLD_RATE_PLANS:9,2237 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
   <facility=0 msg_id=0 version=0>
E Wed Jan 30 13:28:54 2008 myhost cm:9888 fm_subscription_apply_rate.c:3082 1:myhost:UnknownProgramName:0:main:86:1201717734:0
   fm_subs_arrears_add_rate error
   <location=PIN_ERRLOC_FLIST:6 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1 errno=PIN_ERR_NOT_FOUND:3>
   <field num=PIN_FLD_RATE_PLANS:9,2237 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
   <facility=0 msg_id=0 version=0>


-- Steps To Reproduce:
1.  Before migration to 7.3, create a product with monthly cycle arrear event, use rateplan selector based on any attribute of the service
2.  Create an account with this product
3.  After upgrade, create another product/deal/plan with another service
4.  Create a custom program to be able to purchase the new plan/service and cancel the old service in one transaction
5.  Call PCM_OP_CUST_MODIFY_CUSTOMER to purchase the new plan created in step 3 and PCM_OP_CUST_UPDATE_SERVICES to close the service purchased before upgrade in one transaction.

Cause

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