9 Replies Latest reply: Nov 5, 2012 1:38 PM by Hussein Sawwan-Oracle RSS

    conversion  from 11..10.5.2 to R12.1.3

    user12094010
      Hussein,

      currently we are in 11.5.10.2, we are planning to use R12. we are using only oracle Assets.

      1. How to migrate the data from 11.5.10.2 to R12.1.2.3? could you please provide some idea or doc?

      2 . How to avoid the reimplementation?


      Thanks
      Prince
        • 1. Re: conversion  from 11..10.5.2 to R12.1.3
          Hussein Sawwan-Oracle
          currently we are in 11.5.10.2, we are planning to use R12. we are using only oracle Assets.

          1. How to migrate the data from 11.5.10.2 to R12.1.2.3? could you please provide some idea or doc?
          Please see these docs/links.

          Oracle E-Business Suite Upgrade Guide Release 11i to 12.1
          http://docs.oracle.com/cd/E18727_01/doc.121/e16342/toc.htm

          Oracle E-Business Suite Release 12.1.3 Now Available
          https://blogs.oracle.com/stevenChan/entry/ebs_1213_available

          11gR2 11.2.0.3 Database Certified with E-Business Suite
          https://blogs.oracle.com/stevenChan/entry/11gr2_11_2_0_3

          https://forums.oracle.com/forums/search.jspa?threadID=&q=11i+AND+R12+AND+Upgrade&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001
          2 . How to avoid the reimplementation?
          By upgrading from 11i to R12 and in this case you do not need to re-implement.

          https://forums.oracle.com/forums/search.jspa?threadID=&q=Upgrade+vs+Re-Implementation&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

          Thanks,
          Hussein
          • 2. Re: conversion  from 11..10.5.2 to R12.1.3
            user12094010
            Hussein,

            Thanks for the information.

            11i set of books and account will convert into R12 account structure(SLA) with upgrade.


            I could not see the books in SLA (Accounting Setup Screen).

            could you please give some idea on this?

            Thanks
            Prince
            • 3. Re: conversion  from 11..10.5.2 to R12.1.3
              Hussein Sawwan-Oracle
              Prince,
              Thanks for the information.

              11i set of books and account will convert into R12 account structure(SLA) with upgrade.

              I could not see the books in SLA (Accounting Setup Screen).

              could you please give some idea on this?
              Please mention the navigation path of the issue you are referring to?

              Did you run SLA pre-upgrade/post-upgrade as part of 11i to R12 upgrade? -- R12.0 and R12.1: FAQ for the SLA Upgrade: SLA Pre-Upgrade, Post-Upgrade, and Hot Patch [ID 604893.1]

              Thanks,
              Hussein
              • 4. Re: conversion  from 11..10.5.2 to R12.1.3
                user12094010
                Hussein,

                I did not run the pre-SLA. so , I would like to refresh the database from 11ii run with Pre-sla env to R12 environment.

                I don't want to restart all over again(New installation).

                how to refresh the database? IS there any document?

                Please give some advice.


                Thanks
                Prince
                • 5. Re: conversion  from 11..10.5.2 to R12.1.3
                  Hussein Sawwan-Oracle
                  user12094010 wrote:
                  Hussein,

                  I did not run the pre-SLA. so , I would like to refresh the database from 11ii run with Pre-sla env to R12 environment.
                  You can run Post SLA in this case which is a valid option.
                  I don't want to restart all over again(New installation).

                  how to refresh the database? IS there any document?

                  Please give some advice.
                  What do you mean by refresh the database? If you want to go back to 11i you can either restore from a backup or use Rapid Clone (which I believe you are familiar with).

                  Thanks,
                  Hussein
                  • 6. Re: conversion  from 11..10.5.2 to R12.1.3
                    user12094010
                    Hussien,

                    The reason I asked this question. After the R12 upgrade, I did not see the book value. So I created Tar with oracle.

                    oracle requested to execute the sql ,
                    select set_of_books_id,name,short_name,chart_of_accounts_id from GL_SETS_OF_BOOKS;
                    its shows only two records including ( I created new sob in R12). but correct sob value is not there. some how the book value removed but we did not run any sql scripts against any instances.

                    in R12

                    TA_GL_SET_OF_BOOKS TA 101 (old).

                    1027 NIST_GL_SET_OF_BOOKS NIST 101 ( i created recently)

                    where is our book value is hiding, If I run Post SLA will the those records?

                    In production
                    --------------------

                    1 NIST_GL_SET_OF_BOOKS NIST 101 missing
                    2 TA_GL_SET_OF_BOOKS TA 101


                    Please give some idea.

                    Oracle ask to me set up new test cycle.

                    Thanks
                    Prince
                    • 7. Re: conversion  from 11..10.5.2 to R12.1.3
                      Hussein Sawwan-Oracle
                      Hi Prince,

                      Please update the SR and ask Oracle support if the Post SLA is an option here or not (if you miss running SLA pre-upgrade, you can run SLA post-upgrade so I believe you can go with this approach instead of refreshing the database) -- R12.0 and R12.1: FAQ for the SLA Upgrade: SLA Pre-Upgrade, Post-Upgrade, and Hot Patch [ID 604893.1]

                      Thanks,
                      Hussein
                      • 8. Re: conversion  from 11..10.5.2 to R12.1.3
                        user12094010
                        Thanks Hussien,

                        I Just wondering, how come the one SOB is missing, IF I run the POST-upgrade , will it work without the SOB?

                        Thanks
                        Prince
                        • 9. Re: conversion  from 11..10.5.2 to R12.1.3
                          Hussein Sawwan-Oracle
                          Hi Prince,
                          I Just wondering, how come the one SOB is missing, IF I run the POST-upgrade , will it work without the SOB?
                          I cannot really add on this since it is functional -- Please ask Oracle support for an explanation.

                          Thanks,
                          Hussein