Purchased_products Are Searched Again From Database (Doc ID 1267947.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

During billing of contracts, all purchased products for the contract are read initially
Later on, the following search is called, which reads once again purchased_products from the database with a only an extra filter this time:

D Thu Mar 18 15:25:06 2010 sisbico2v cm_billing:4436 fm_subscription_get_purchased_offerings.cpp:693 1:sisbico2v:cm_billing:2201:1:1301:1268922305:1
select X from /purchased_product where ( F1 = V1 OR F2 = V2 ) AND F3 = V3 AND F4 = V4
D Thu Mar 18 15:25:06 2010 sisbico2v cm_billing:4436 fm_subscription_get_purchased_offerings.cpp:743 1:sisbico2v:cm_billing:2201:1:1301:1268922305:1
DEBUG search input flist
# number of field entries allocated 20, used 9
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_STATUS ENUM [0] 1
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 PIN_FLD_STATUS ENUM [0] 2
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 228799169 0
0 PIN_FLD_ARGS ARRAY [4] allocated 20, used 1
1 PIN_FLD_OVERRIDDEN_OBJ POID [0] 0.0.0.1 /purchased_product 252043209 4
0 PIN_FLD_TEMPLATE STR [0] "select X from /purchased_product where ( F1 = V1 OR F2 = V2 ) AND F3 = V3 AND F4 = V4 "
0 PIN_FLD_INDEX_NAME STR [0] "purchased_product_acct_i"
0 PIN_FLD_RESULTS ARRAY [*] NULL array ptr

As all purchased_product for the contract were already read before, this step should reuse the result of the initial search (cache or move this functionality earlier).

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