procedure p_upd_s_org_ext_master_ou_id is not properly updating MASTER_OU_ID column

@RowUpd

Hi All,

Upgrade from 8.0.0.10 SEA to 8.1.1.10 SIA.

The procedure (p_upd_s_org_ext_master_ou_id) should update the MASTER_OU_ID.

However this was not the case for all columns and also the data is inconsistent, many records where MASTER_OU_ID doesn't match PAR_OU_ID value.

Did anyone come across similar issues?

 

Thanks,
Sami

 

create proc p_upd_s_org_ext_master_ou_id
as
DECLARE @RowUpd int
begin
set nocount ON
  update S_ORG_EXT
    set MASTER_OU_ID = ROW_ID
  where not exists (select 'x' from S_ORG_EXT PAR
where PAR.ROW_ID = S_ORG_EXT.PAR_OU_ID)