Not Able To Cancel The Old Products After Upgrading To 7.3 (Doc ID 471378.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.0.0.1 [Release 7.3.0]
Information in this document applies to any platform.
The solution applies to upgrade from any release to 7.3 or 7.3.1 release.
***Checked for relevance on 15-Feb-2010***


Symptoms

After upgrading to 7.3, Not able to cancel the old products.  The following example log is from upgrading from 6.5_SP1 to 7.3.

An account has purchased a deal before migrating to 7.3.   After upgrading, the user cannot cancel the
deal from Customer Center.  Therefore, the product still remains in the account. cm.pinlog file and
dm_oracle logged error.  However, if the same deal is purchased after upgrade, there is no problem
to cancel that deal newly purchased deal.

The cm.pinlog logged the following search which leads to the error:

W Wed Nov 28 23:45:31 2007 myhost cm_sen:193 cm_utils.c(111):1251
1:pc12345678:CustomerCenter:0:AWT-EventQueue-0:926:1196322348:0
     CM FM->DM opcode PCM_OP_SEARCH, opflags=0x0
# number of field entries allocated 20, used 11
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 256
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1    PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 434210 127
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1    PIN_FLD_POID POID [0] 0.0.0.1
/event/billing/product/fee/cycle/cycle_forward_monthly -1 0
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1    PIN_FLD_END_T TSTAMP [0] (1196322325) Wed Nov 28 23:45:25 2007
0 PIN_FLD_ARGS ARRAY [4] allocated 20, used 1
1    PIN_FLD_END_T TSTAMP [0] (1193644800) Mon Oct 29 00:00:00 2007
0 PIN_FLD_ARGS ARRAY [5] allocated 20, used 1
1    PIN_FLD_PRODUCT SUBSTRUCT [0] allocated 20, used 1
2       PIN_FLD_OFFERING_OBJ POID [0] 0.0.0.1 /purchased_product 20535633 41
0 PIN_FLD_ARGS ARRAY [6] allocated 20, used 1
1    PIN_FLD_PRODUCT SUBSTRUCT [0] allocated 20, used 1
2       PIN_FLD_NODE_LOCATION STR [0] "xyz#5192/1#20030930-111429.705:xyz#5192/1#20030930-111429.705"
0 PIN_FLD_ARGS ARRAY [7] allocated 20, used 1
1    PIN_FLD_CYCLE_INFO SUBSTRUCT [0] allocated 20, used 1
2       PIN_FLD_FLAGS INT [0] 0
0 PIN_FLD_TEMPLATE STR [0] " select X from /event/billing/product/fee/cycle where F1 = V1 and F2 like V2 and F3 <= V3 and F4 >= V4 and ( F5 = V5 or F6 = V6 ) and F7 in(256,2056, 1032, 65792, 262400, 327936, 524544, 525568, 8388636, 8389640) order by event_t.end_t desc, event_t.created_t desc "
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 0


This search resulted in cm.pinlog error:

W Wed Nov 28 23:45:31 2007 myhost cm_sen:193 cm_utils.c(111):1616
1:pc12345678:CustomerCenter:0:AWT-EventQueue-0:926:1196322348:0
      CM DM->FM opcode PCM_OP_SEARCH, opflags=0x0
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_ERR_BUF ERR [0]
      <location=PIN_ERRLOC_DM:4 class=PIN_ERRCLASS_APPLICATION:4 errno=PIN_ERR_BAD_SEARCH_ARG:18>
      <field num=PIN_FLD_NODE_LOCATION:5,1825 recid=0 reserved=4 reserved2=0 time(sec:usec)=0:0>
      <facility=0 msg_id=0 version=0>



dm_oracle.pinlog shows

E Wed Nov 28 23:45:31 2007 myhost dm:18697 dm_ops.c(144):4385
1:pc12345678:CustomerCenter:0:AWT-EventQueue-0:926:1196322348:0
     op_search: unknown arg, rec_id (0) in args list (field 5/1825)
E Wed Nov 28 23:45:31 2007 myhost dm:18697 dm_back.c(24):1389
1:pc12345678:CustomerCenter:0:AWT-EventQueue-0:926:1196322348:0
     DMbe #8: process_op: op 7, err 1



However, when cancelling a newly purchased deal, the search doesn't include the argument

0 PIN_FLD_ARGS ARRAY [6] allocated 20, used 1
1    PIN_FLD_PRODUCT SUBSTRUCT [0] allocated 20, used 1
2       PIN_FLD_NODE_LOCATION STR [0] "xyz#5192/1#20030930-111429.705:xyz#5192/1#20030930-111429.705"

Steps to reproduce:

  1. Create an account on old system before upgrade. The account purchased a deal with a product (cycle forward monthly for example)
  2. Upgrade to 7.3
  3. Open the same account with Customer Center, cancel the deal.

Expect result: being able to cancel the deal.
Actual result: receiving an error in Customer Center. Not able to cancel the deal.

.

Changes

Upgraded from any release to 7.3.

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