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 SEPTEMBER 17, 2022

Applies to:

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


On : 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.


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


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

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