Billing Contracts: Purchased_products Are Searched Again From Database (After Been All Read Initiall)
(Doc ID 1288594.1)
Last updated on APRIL 03, 2023
Applies to:
Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and laterInformation 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 <HOST> cm_billing:4436 fm_subscription_get_purchased_offerings.cpp:693 1:<HOST>: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 <HOST> cm_billing:4436 fm_subscription_get_purchased_offerings.cpp:743 1:<HOST>: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).
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |