Pcm_Op_Ar_Bill_Adjustment Fails Due To Search Template Too Big
Last updated on FEBRUARY 23, 2017
Applies to:
Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.5.0.0.0 [Release 7.4.0 to 7.5.0]Information in this document applies to any platform.
Symptoms
PCM_OP_AR_BILL_ADJUSTMENT was erroring out as the IN clause of the search
template was exceeding the limitation of the dm_oracle buffer.
Errors:
E Thu Dec 16 18:25:27 2010 XXXX dm:29362 dm_ops.c(209):6320 1:ACN7440R8XFPTX:UnknownProgramName:0:AWT-EventQueue-0:1323:1292528227:0
search TEMPLATE too big (" select sum ( F1 ) from /event where event_bal_impacts_t.item_obj_id0 in (20101012068132,20101012068133,20101012068134, .....
search TEMPLATE too big (" select sum ( F1 ) from /event where event_bal_impacts_t.item_obj_id0 in (20101012068132,20101012068133,20101012068134, .....
1. Create two accounts with ip/email service, made one of the accounts as child account and build up an hierarchical relation between these two accounts
2. Move pin_virtual_time to March 1st, 2005
3. Run billing using pin_bill_day
4. Execute the opcode to perform bill_adjustment for parent account as below
Opcode: PCM_OP_AR_BILL_ADJUSTMENT
Input Flist
===========
0 PIN_FLD_POID POID [0] 0001 /bill 1409594 0
0 PIN_FLD_AMOUNT DECIMAL [0] -2
0 PIN_FLD_DESCR STR [0] "Customer unaware of charges"
0 PIN_FLD_FLAGS INT [0] 2
0 PIN_FLD_PROGRAM_NAME STR [0] "Customer Center"
0 PIN_FLD_REASON_DOMAIN_ID INT [0] 16
0 PIN_FLD_REASON_ID INT [0] 2
0 PIN_FLD_AMOUNT DECIMAL [0] -2
0 PIN_FLD_DESCR STR [0] "Customer unaware of charges"
0 PIN_FLD_FLAGS INT [0] 2
0 PIN_FLD_PROGRAM_NAME STR [0] "Customer Center"
0 PIN_FLD_REASON_DOMAIN_ID INT [0] 16
0 PIN_FLD_REASON_ID INT [0] 2
Changes
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