Errors SBL-DAT-00496, SBL-DBC-00111 or Missing 'SELF' records in S_PARTY_RPT_REL When Updating Parent Position or Parent Organization (Doc ID 729020.1)

Last updated on OCTOBER 28, 2022

Applies to:

Symptoms

When trying to update the parent position or parent organization of a record which has its own children via Administration - Group > Positions or Administration - Group > Organizations you will see the following error message:

Cannot update Parent because this will introduce recursive reporting relationship or such relationship already exists for the given Parent.(SBL-DAT-00496).

Other symptoms include missing 'SELF' records from the S_PARTY_RPT_REL table.

The issue can be reproduced in the following ways:

Positions:
There is a position hierarchy as follows:

Pos B reports to Pos A

Pos C, Pos D and Pos E reports to Pos B

e.g.
              Pos A
                  |
              Pos B
      ________|_____
    |            |          |
Pos C     Pos D     Pos E

In Administration - Group > Positions, change the Parent Position of B to another position (e.g. Pos X) and you will see the error:

Cannot update Parent because this will introduce recursive reporting relationship or such relationship already exists for the given Parent.(SBL-DAT-00496).

Organizations:
You have an organization structure as below:

          Org A
              |
Default Organization
     _____|_____
    |                  | 
Org B           Org C
                       |
                    Org D
                   __|__
                  |        |
             Org E   Org F

Change the parent organization of Org D from Org C to Org B and save it:

You will either see:
[1] An error has occurred writing to a record. Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00111)
[2][Microsoft][SQL Native Client][SQL Server]Cannot insert duplicate key row in object 'dbo.S_PARTY_RPT_REL' with unique index 'S_PARTY_RPT_REL_U1'.
[3][Microsoft][SQL Native Client][SQL Server)The statement has been terminated.
[4][Microsoft][SQL Native Client][SQL Server]Cannot insert duplicate key row in object 'dbo.S_PARTY_RPT_REL' with unique index 'S_PARTY_RPT_REL_U1'.
[5][Microsoft][SQL Native Client][SQL Server)The statement has been terminated.

OR

Cannot update Parent because this will introduce recursive reporting relationship or such relationship already exists for the given parent (SBL-DAT-00496)

Changes

Cause

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