3 Replies Latest reply on May 25, 2017 4:58 PM by BhaskarKoniki

    OKL upgrade

    JimT

      Does anyone upgraded 11i having only Oracle Leasing + Financials to R12?  We are planning to upgrade and project is ready to kick-off.

      If anyone has experience, could you post some helpful tips. The reason, the database is very huge and the OKL tables are already having millions of data.

        • 1. Re: OKL upgrade
          BhaskarKoniki

          Yes we did similar upgrade.  There are very few customers having Oracle Leasing OKL module implemented, so you might not get direct hits in metalink.  The upgrade scripts run forever due to the volume of data stored in OKL/AP tables.  you might have to work with Oracle support closely to get the scripts tuned. 

           

          Have a close look at the tables examples like OKL_CNSLD_AP_INVS_ALL and try to purge data as much as possible before upgrade. according to oracle some of the tables are not allowed to purge. Disable all customer code, triggers , custom indexes, and custom constraints before starting for the upgrade. allocate some flash drive storage for the upgrade.

          • 2. Re: OKL upgrade
            JimT

            If you possible can you provide more info or Oracle notes.

            • 3. Re: OKL upgrade
              BhaskarKoniki

              Look at

              2267089.1

              2255151.1