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

    OKL upgrade


      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

          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

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

            • 3. Re: OKL upgrade

              Look at