During conversion from BCD to Biotics, any ET that was in the Managed Area Element list was converted at the Global level. If you would like to change these global elements to subnational elements, run this script, and don't forget to commit;

DECLARE
CURSOR EL_MA_CURSOR IS
SELECT
EL_MA.ELEMENT_MANAGED_AREA_ID EL_MA_ID,
EL_MA.ELEMENT_GLOBAL_ID EL_MA_EGT_ID,
EL_MA.ELEMENT_NATIONAL_ID EL_MA_ENT_ID,
EL_MA.ELEMENT_SUBNATIONAL_ID EL_MA_EST_ID,
EGT.ELEMENT_GLOBAL_ID EGT_ID,
ENT.ELEMENT_NATIONAL_ID ENT_ID,
EST.ELEMENT_SUBNATIONAL_ID EST_ID
FROM
ELEMENT_MANAGED_AREA EL_MA,
ELEMENT_GLOBAL EGT,
ELEMENT_NATIONAL ENT,
ELEMENT_SUBNATIONAL EST
WHERE
EL_MA.ELEMENT_GLOBAL_ID = EGT.ELEMENT_GLOBAL_ID(+) AND
EGT.ELEMENT_GLOBAL_ID = ENT.ELEMENT_GLOBAL_ID(+) AND
ENT.ELEMENT_NATIONAL_ID = EST.ELEMENT_NATIONAL_ID(+);
EL_MA_RECORD EL_MA_CURSOR%ROWTYPE;
BEGIN
FOR EL_MA_RECORD IN EL_MA_CURSOR LOOP
EXIT WHEN EL_MA_CURSOR%NOTFOUND;
UPDATE ELEMENT_MANAGED_AREA
SET ELEMENT_SUBNATIONAL_ID = EL_MA_RECORD.EST_ID,
REC_LAST_MOD_USER = USER
WHERE
ELEMENT_MANAGED_AREA_ID = EL_MA_RECORD.EL_MA_ID;
UPDATE ELEMENT_MANAGED_AREA
SET ELEMENT_GLOBAL_ID = NULL,
REC_LAST_MOD_USER = USER
WHERE
ELEMENT_MANAGED_AREA_ID = EL_MA_RECORD.EL_MA_ID;
END LOOP;
END;
.
/