Pcm_Op_Ar_Bill_Adjustment Fails Due To Search Template Too Big (Doc ID 1307096.1)

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, .....



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

 

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