Unable To WriteOff /ITEM/ADJUSTMENT Items (Doc ID 1054430.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.2.1.0.0 and later   [Release: 7.2.1 and later ]
Information in this document applies to any platform.
Checked for relevance on 23-Dec-2011

Symptoms

Unable to writeoff /item/adjustments after applying Patch 6667496. The writeoff is taking a long time in production system.

Steps to Reproduce:
Call PCM_OP_AR_ITEM_WRITEOFF to writeoff /item/adjustment
# number of field entries allocated 20, used 5
0 PIN_FLD_POID POID [0] 0.0.0.1 /item/adjustment 6378913884
0 PIN_FLD_PROGRAM_NAME STR [0] "Testnap"
0 PIN_FLD_DESCR STR [0] "testnap"
0 PIN_FLD_STRING_ID INT [0] 1016020
0 PIN_FLD_STR_VERSION INT [0] 203
0 PIN_FLD_FLAGS INT [0] 0

 

Observed: the writeoff is taking long time This is due to the cycle tax query which is using bill_obj_id0 = 0.

D Mon Jan 05 12:17:50 2004 machine1 cm:26439 fm_ar_utils.cpp:1153 1:machine1:testnap:26436:1:127:1257758780:1
BILL_OBJ flist
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /item/adjustment 6378913884 1
0 PIN_FLD_BILL_OBJ POID [0] 0.0.0.0 0 0
D Mon Jan 05 12:17:50 2004 machine1 cm:26439 fm_ar_utils.cpp:1217 1:machine1:testnap:26436:1:127:1257758780:1
cycle tax 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] 0
0 PIN_FLD_TEMPLATE STR [0] "select 1.X from /item 1, /event 2 where 1.F1 like V1 and 1.F2 = V2 and 2.F3 like V3 and 1.F4 = 2.F5 "
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_POID POID [0] 0.0.0.1 /item/misc -1 0
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 PIN_FLD_BILL_OBJ POID [0] 0.0.0.0 0 0
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1 PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/cycle/tax -1 0
0 PIN_FLD_ARGS ARRAY [4] allocated 20, used 1
1 PIN_FLD_POID POID [0] NULL poid pointer
0 PIN_FLD_ARGS ARRAY [5] allocated 20, used 1
1 PIN_FLD_ITEM_OBJ POID [0] NULL poid pointer
0 PIN_FLD_RESULTS ARRAY [*] allocated 20, used 3
1 PIN_FLD_POID POID [0] NULL poid pointer
1 PIN_FLD_DUE DECIMAL [0] NULL pin_decimal_t ptr
1 PIN_FLD_ITEM_TOTAL DECIMAL [0] NULL pin_decimal_t ptr
D Mon Jan 05 12:17:50 2004 machine1 cm:26439 fm_ar_utils.cpp:1222 1:machine1:testnap:26436:1:127:1257758780:1
cycle tax output flist

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