Issue in Moving an Existing Account to a New Account Heirarchy

(Doc ID 2022737.1)

Last updated on JUNE 24, 2015

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Goal

Qn1: We are getting an Issue in moving an existing account to a new Account Hierarchy when both the accounts are residing in different Database schemas,
We have replicated the above scenario using Customer Center and also by using opcode "PCM_OP_CUSTCARE_MOVE_ACCT",but we are getting the below error (specified in ERROR_CODE field)

There are 2 customer Accounts with the below structure:
Account1 -->Billinfo1 --> Service1(MSISDN along with its own Balance Group).(Lies in Schema 7)
Account2 -->Billinfo2 --> Service2(MSISDN along with its own Balance Group).(Lies in Schema 2)
When I try move account 2 in heirarchy under account 1 using PCM_OP_CUSTCARE_MOVE_ACCT there is a TRANS_ALREADY_OPEN error thrown by the opcode.
Note that this is a Rapid Offer Design and Order Delivery (RODOD) implementation and the opcode is being invoked by Oracle Fusion Middleware ( FMW).
 
Qn2: Can you please suggest and alternative mechanism by which we can achieve the desired results?
 
Qn3: Can you please let us know how does somebody move an account into the new schema?
Is there some API or utility to do this?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms