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 184.108.40.206.0 to 220.127.116.11.0 [Release 7.4.0 to 7.5.0]
Information in this document applies to any platform.
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.
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
0 PIN_FLD_AMOUNT DECIMAL  -2
0 PIN_FLD_DESCR STR  "Customer unaware of charges"
0 PIN_FLD_FLAGS INT  2
0 PIN_FLD_PROGRAM_NAME STR  "Customer Center"
0 PIN_FLD_REASON_DOMAIN_ID INT  16
0 PIN_FLD_REASON_ID INT  2
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