8.4.4 Upgrade Script for Release 8.1 to Release 8.1.2 Upgrade (Optional)

Run the following upgrade SQL script before upgrading the IPA, RPA, and EFPA applications if you are upgrading from Release 8.1.0.0.0.0 to Release 8.1.2.0.0. This step is optional.

CREATE TABLE BAK81_OFSA_OAM AS (SELECT * FROM OFSA_OBJECT_APPLICATION_MAP)
/
DELETE FROM OFSA_OBJECT_APPLICATION_MAP
WHERE MD_FOLDER <> 'DEFAULT' and MD_CODE in
(
SELECT MD_CODE from
(
SELECT APP_ID, MD_CODE from OFSA_OBJECT_APPLICATION_MAP
WHERE APP_ID in ('OFS_IPA','OFS_RPA','OFS_EFPA')
group by APP_ID, MD_CODE having count(*) > 1
) T1
)
/
COMMIT
/