1 Reply Latest reply: Apr 21, 2013 2:39 PM by Hussein Sawwan-Oracle RSS

    Obsolete Columns

    Walashkar
      Hai all,

      We are upgrading from r11 to r12.1.3 ,

      12.1. upgrade note says.

      During the upgrade process, the Oracle RDBMS DROP COLUMN command marks
      Oracle E-Business Suite columns as unused in the data dictionary, making it possible
      for the database administrator to drop the columns and reclaim the associated space. It
      Planning for an Upgrade is a good idea to plan this reclamation ahead of time because the process locks the
      associated tables. Once the space is reclaimed, the upgraded data model looks more like
      a fresh install (except for customizations). Note that DROP COLUMN has no effect on
      custom columns.

      So , How do I drop the column before the upgrade itself as mentioned above and how to identify the same
        • 1. Re: Obsolete Columns
          Hussein Sawwan-Oracle
          Please see the following links.

          Identifying Data Model Changes Between EBS 12.1.3 and Prior EBS Releases
          https://blogs.oracle.com/stevenChan/entry/ebs_data_model_1213

          EBS Seed Data Comparison Reports Now Available
          https://blogs.oracle.com/stevenChan/entry/ebs_seed_data_comparison_reports

          Thanks,
          Hussein