My Oracle Support Banner

PCM_OP_PAYMENT_COLLECT Fails Due To Limitation In /item.PIN_FLD_EVENT_POID_LIST Field (Doc ID 2779811.1)

Last updated on MAY 28, 2021

Applies to:

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

Symptoms

On : 7.5.0.23.0 version, Payments

For bills with a large number of pending items, PCM_OP_PAYMENT_COLLECT fails with ERR_STORAGE because the payment is allocated to a large number of items, the resulting string to be stored in /item.PIN_FLD_EVENT_POID_LIST exceeds the varchar2 limit of 4000 characters.

How to bypass this design limitation? 

This is on a Billing and Revenue Management (BRM) 7.5 Patch Set (PS) 23 system.


ERROR
-----------------------
PIN_ERR_STORAGE

ORACLE error: do_sql_update: PINStmtExecute: code 1461, op 0
=ORA-01461: can bind a LONG value only for insert into a LONG column

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.