My Oracle Support Banner

Payments Failed Due to Database Error on Item_t Table for Event Poid List Column (Doc ID 2905541.1)

Last updated on FEBRUARY 21, 2024

Applies to:

Oracle Communications Billing and Revenue Management - Version 12.0.0.2.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Communications Billing and Revenue Management (BRM) 12.0.0.2.0 version, while posting payment for one of the Business Accounts, below error is found on item_t table for event poid list column.

The billing account is having large pending items to allocate. The payment allocation failed to update the /item event poid list, as it is exceeding event poid list column size.

ERROR
-----------------------

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Take a Billing account having large number of pending items to allocate, post payment via Payment Tool
2. Check if it is getting failed during the allocation while trying to update /item event poid list and reports the mentioned Error

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.