# 
#  WARNING: Failure to carefully read and understand these requirements may
#  result in your applying a patch that can cause  your Oracle Server to
#  malfunction, including interruption of service and/or loss of data. 
# 
#  If you do not meet all of the following requirements, please email
#  prabuddha.biswas@oracle.com so that Development may review your situation. 
# 
#  Requirements: 
# 
#    - You must have located this patch via a Bug Database entry
#      and have approval to down load and use the kit
#
#    - THIS IS AN E-Business Oracle applications ONLY PATCH
# 
#    - Your system configuration (Oracle Server version and patch
#      level, OS Version) must exactly match those in the bug
#      database entry.
# 
#  If you do NOT meet these requirements, or are not certain that you meet
#  these requirements, please contact Applications support who will make a 
#  determination about whether you should apply this patch. 
# 
#  -----------------------------------------------------------------------
#  Interim Patch for Base Bugs: 4247037 - (Request bug 13057955)
#  -----------------------------------------------------------------------
#
#  DATE:  Tue Oct 04 01:58:00 2008
#  -------------------------------
#  Platform Patch for : ALL PLATFORMS - Generic patch
#  Product Version #  : 11.2.0.3
#  Product Patched    : RFID-EPC from Spatial TEAM
#
#  Bugs Fixed by this patch:
#  -------------------------
#  4247037:RFID-EPC GENERATION FEATURE FROM DATABASE SERVER. TO BE USED WITH APPS WMS R12
#  2008-Jan-08 Rollout of mdgapp schema name 
#              RE-ISSUE FOR Microsoft Windows Server 2003 (64-bit Itanium)
#              Check all platforms are available.
#  2007-DEC-18 There is a SCHEMA name change from mgdsys to mgdapp
#              RE-ISSUE FOR Microsoft Windows Server 2003 (64-bit Itanium)
#  2007-JUL-06 RE-ISSUE FOR NEW PLATFORMS
#  2008-APR-22 Taking the Patch to 11.1.0.6
#  2008-OCT-15 Taking the Patch to 11.1.0.7
#  2009-SEP-17 Taking the Patch to 11.2.0.1  Windows plaftoms id=100,268,232 withdrawn
#  2010-APR-30 11.2.0.1 <online_rac_installable>true</online_rac_installable>
#  2010-Oct-12 11.2.0.2 Moved to Generic patching and xml opatch files.
#  2011-Oct-04 11.2.0.3 No Changes based on 11.2.0.2
#  2011-Oct-26 11.2.0.3 No Code Changes all based on 11.2.0.2, Minor readme.txt changes
#
#  **** NOTE **** this is the Terminal Version of this patch
# 
#  Files contained in this patch
#               README.txt 
#     <DIR>            admin
#               Length Name
#               ------ ----
#                  794 catmgdidcode.sql
#                  906 catnomgdidcode.sql
#                 1641 mgdidcodetype.plb
#                 9283 mgdidcodetype.sql
#                 1927 mgdidcodeutl.plb
#                 7794 mgdidcodeutl.sql
#                 1427 mgdiddeinstall.sql
#                  854 mgdidepctype.plb
#                 3495 mgdidepctype.sql
#                  254 mgdidinstall.sql
#               105827 mgdidmetadata.sql
#                12290 mgdidmetatable.sql
#                 1721 mgdidprivs.plb
#                  612 mgdsys.sql
#                 3130 prvtmgdidcodetypeb.plb
#                31678 prvtmgdidcodeutlb.plb
#                 4612 prvtmgdidepctypeb.plb
#               
#       <DIR>          support
#            File size name
#               Length Name
#               ------ ----
#                 2379 patchset_mgdsys_validity.sql
#
#  Note There was an incorrect SCHEMA name change from mgdsys to mgdapp
#  in the patch issued on the 2007-DEC-18 for 10.2.0.3
# 
#  If you have a previous version of the patch installed, you must 
#  first deinstall from the database the previous patch be it the 18th of Dec
#  OR Eariler before installing this patch.
#  
#  You can use the deinstallation script supplied in the previous version to
#  deinstall the previous patch, before using opatch to deinstall the patch...
#
#  Deinstall an older version of this patch use 
#
#   connect to the database using sqlplus / as sysdba
#  
#   sqlplus>  @catnomgdidcode
#
#  this will drop the old mgdsys or mgdapp user and their objects
#  once complete you can check everything has been removed with
#  the script patchset_mgd*_validity.sql located in
#  /md/support this should show no objects.
#  
#  Patch Installation Instructions:
#  --------------------------------
#  To apply the patch, unzip the PSE container file:
#
#  p4247037_11202_GENERIC.zip
#
#  Set your current directory to the directory where the patch
#  is located:
#
#    % cd 4247037
#
#  Ensure that the directory containing the opatch script appears in
#  your $PATH; then enter the following command:
#
#    % opatch apply
#
#  Once applied with opatch, the files are located in $ORACLE_HOME/md/admin
#  and $ORACLE_HOME/md/support for patchset_mgdsys_validity.sql
#  
#  Patch Special Instructions:
#  ---------------------------
#  To install: 
#
#   connect to the database using sqlplus / as sysdba
#
#   sqlplus> @catmgdidcode
#
#   If checking with patchset_mgdapp_validity.sql you find invalid objects
#   please run $ORACLE_HOME/rdbms/admin/utlrp.sql which should resolve any issues.
#
#  The patchset_mgdsys_validity.sql script in support was written by
#  BDE engineer to check the status of the build not by development
#
#   To deinstall
#
#   connect to the database using sqlplus / as sysdba
#  
#   sqlplus>  @catnomgdidcode   (NOTE: file is located in $OH/md/admin)
#  
#  <eof>