My Oracle Support Banner

PIN_REL Failure Due to Value Too Large for ITEM_POID_LIST (Doc ID 2922203.1)

Last updated on JANUARY 27, 2023

Applies to:

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

Goal

While executing pin_rel, the user is seeing failure for one account where the field ITEM_POID_LIST in account_t has reached value of 4029 .
There are many accounts which have 15 Discount sharing groups (DSG), as a result, there are many item/sponsor created and ITEM_POID_LIST in pin.account_t has reached maximum limit, hence during pin_rel process, below error is observed:

 
How to fix the above errors and provide the steps to update the ITEM_POID_LIST column size in account_t table?

 

Solution

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