Event Table Full Scan During PCM_OP_AR_RESOURCE_AGGREGATION (Triggered By Adjustment) (Doc ID 1288137.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.1.0.0 to 7.3.1.0.1 - Release: 7.3.1 to 7.3.1
Information in this document applies to any platform.

Symptoms

When running adjustments it calls this opcode PCM_OP_AR_RESOURCE_AGGREGATION and one of the internal searches is done in such a way that results in an event table full scan resulting in unacceptable performance degradation.

Steps to Reproduce

1. Create an account with any OOB plan
2. Run billing
3. Select an charge event from the balance tab
4. Adjust the event
5. Grab the search input flists from source code lines 951 and 1348 (see below sample input flist)
6. Run the searches in testnap while turning DB trace on to capture execution plans for "select" statements.

Sample Input FLists that result in TABLE SCAN:

D 2010-08-20 15:29:37.077 xxx.com cm:14629.-146556160 fm_ar_resource_aggregation.c:951 1:jt26340:CustomerCenter:0:AWT-EventQueue-0:4510:1282343377:0
   Dispute Search
# number of field entries allocated 20, used 6
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 256
0 PIN_FLD_TEMPLATE STR [0] "select X from /event where F1 = V1 and F2 like V2 "
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1   PIN_FLD_SESSION_OBJ POID [0] 0.0.0.1 /event/billing/product/fee/cycle/cycle_forward_monthly 259977325862407759 0
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1   PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/dispute/% -1 0
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 3
1   PIN_FLD_START_T TSTAMP [0] (0) <null>
1   PIN_FLD_END_T TSTAMP [0] (0) <null>
1   PIN_FLD_BAL_IMPACTS ARRAY [*] allocated 20, used 4
2     PIN_FLD_AMOUNT DECIMAL [0] NULL pin_decimal_t ptr
2     PIN_FLD_DISCOUNT DECIMAL [0] NULL pin_decimal_t ptr
2     PIN_FLD_RESOURCE_ID INT [0] 0
2     PIN_FLD_IMPACT_TYPE ENUM [0] 0

and

D 2010-08-20 15:30:26.478 xxx.com cm:14629.-146556160 fm_ar_resource_aggregation.c:1348 1:jt26340:CustomerCenter:0:AWT-EventQueue-0:4510:1282343377:0
   Adjustment Search
# number of field entries allocated 20, used 6
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 256
0 PIN_FLD_TEMPLATE STR [0] " select X from /event where F1 = V1 and F2 like V2 "
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1   PIN_FLD_SESSION_OBJ POID [0] 0.0.0.1 /event/billing/product/fee/cycle/cycle_forward_monthly 259977325862407759 0
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1   PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/adjustment/% -1 0
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 1
1   PIN_FLD_BAL_IMPACTS ARRAY [*] allocated 20, used 4
2     PIN_FLD_AMOUNT DECIMAL [0] NULL pin_decimal_t ptr
2     PIN_FLD_DISCOUNT DECIMAL [0] NULL pin_decimal_t ptr
2     PIN_FLD_RESOURCE_ID INT [0] 0
2     PIN_FLD_IMPACT_TYPE ENUM [0] 0

Note - Patch 8621210 is installed.

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