My Oracle Support Banner

PCM_OP_CUST_UPDATE_SERVICES Fails To Update Alias On A Multi-DB Environment (Doc ID 1293988.1)

Last updated on JUNE 29, 2022

Applies to:

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


A call to PCM_OP_CUST_UPDATE_SERVICES to update an alias on Multi-DB environment fails.

On Multi-DB environment, when the services to be updated are on secondaries databases and the uniqueness table entries are kept on the primary database, PCM_OP_CUST_UPDATE_SERVICES fails to update alias with an error : PIN_ERR_TRANS_ALREADY_OPEN.

A read obj of the /uniqueness entry (on primary database) is done while a transaction is already open on a secondary database, which is causing the opcode to fail.


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.