Unable to remove brand account from hierarchy due to incorrect lineage (Doc ID 408965.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.0.0.0.1 to 7.0.0.0.1
Solaris Operating System (SPARC 32-bit)

Symptoms

Can not remove the accounts from the hierarchy while logged in as brand because the Lineage of the account is incorrect.

1. Login in customer center with brand login
2. Create two new accounts (account A and account B)
3. Make Account B the child of account A

After making Account B as child of Account A run the following query:

select poid_id0, lineage from account_t where poid_id0 in (80081,83472) ;

83472 /0.0.0.1:59860B/0.0.0.1:78227B/0.0.0.1:80081/0.0.0.1:83472/ --> Account B Child
80081 /0.0.0.1:59860B/0.0.0.1:78227B/0.0.0.1:80081/ --> Account A Parent

4. Remove Account B from the hierarchy (now they are both stand-alone)
5. Make Account A the child of Account B
6. Try to remove Account A from the hierarchy, the message says it is removed but it is not when checked in the database.

select poid_id0, lineage from account_t where poid_id0 in (80081,83472) ;

83472 /0.0.0.1:59860B/0.0.0.1:78227B/0.0.0.1:80081/0.0.0.1:83472/ --> Account B Parent
80081 /0.0.0.1:59860B/0.0.0.1:78227B/0.0.0.1:80081/ --> Account A Child

Cause

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