Rem
Rem $Header: whdev/2.0/owb/shiphome/owb/patches/bug12679023/fix12679023.sql /main/1 2011/06/24 07:21:57 yuanzha Exp $
Rem
Rem fix12679023.sql
Rem
Rem Copyright (c) 2011, Oracle and/or its affiliates. All rights reserved. 
Rem
Rem    NAME
Rem      fix12679023.sql - This script is used to fix SAP module missing platform info after upgrading to 11.2
Rem
Rem    NOTES
Rem      1. This script should be executed by OWBSYS
Rem      2. Before executing this script, It is better to close all sessions connected to owb.
Rem  
Rem     Usage: 
Rem        1. Connect to Repository with OWBSYS 
Rem             e.g. SQLPLUS> connect OWBSYS/<OWBSYS Password>
Rem        2. Call this script:
Rem            e.g. SQLPLUS>@fix12679023.sql
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    yuanzha     06/23/11 - Created
Rem


begin
    update cmpwbsapinstalledmodule_r set platform = (select elementid from cmpplatform_r where name='SAP' and workspaceid = 1) where platform is null;
    commit;
end;

/