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 22.214.171.124.0 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