pin_bill_accts Fails When PIN_FLD_EVENT_POID_LIST Over String Limit (Doc ID 1166634.1)

Last updated on DECEMBER 15, 2013

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2013***

Symptoms

"pin_bill_accts" fails when running billing because the field event_poid_list in the billinfo table has the limitation of string length 2000.

It seems that the events get appended in this field with every cycle and it continues to grow until it exceeds the 2000 character limit.

This field also contains the rollover event poids for event service on the account. This introduces a limitation on the number of services with rollover minutes under a single account. A user has some large accounts with over 100 services. If these services all have rollover minutes, the user will not be able to bill these accounts.

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