5 Replies Latest reply on Jun 4, 2016 1:24 AM by jaygop

    FDM to FDMEE

    jaygop

      Using the utility 1.1 and stuck with several issues executing the FDMC_extract_setup. Tried the previous version of the utility as well and still the same issues. Columns missing on the backend tables that I tried to create manually and moved to next steps. But, stuck at step #111 with ORA-12704 character set mismatch. It is a tedious query with several parameters for me to find the mismatch column. Did anyone run into this ? I have been waiting for Oracle to respond back to my ticket for over a week now and no movement. We are in a time crunch and trying to see alternatives. Do anyone have the steps to migrate it old fashioned way without the utility ? We are migrating from 11.1.2.3.500 to 11.1.2.4.100. Any help is much appreciated.

        • 1. Re: FDM to FDMEE
          975839

          Hi,

          Where you are created columns manually in classic or FDMEE schema? If you are getting the error on target schema table, please check database table of target schema from  location

          C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\database\Common\Oracle folder whether tables are created properly in configuration.

           

          Regards,

          Madhu K

          1 person found this helpful
          • 2. Re: FDM to FDMEE
            Francisco Amores

            Please can you attached:

             

            - utility log

            - screenshot of the ODI operator step failing (with details)

            - the query

            • 3. Re: FDM to FDMEE
              jaygop

              Madhu, thanks for the sql location. This is helpful. I was manually adding the columns to the FDMEE schema.

               

              Francisco, I was fishing in your blog yesterday for some clue.I am hoping this reconfiguration resolves the issue. I was using one of the classic FDM app's (not being in use) schema. In my mind, it should've still created the required columns when reused !

               

              I am re-configuring FDMEE with a fresh new schema now. I will keep you posted. Thanks for the quick response and guidance. This community is much useful than the service requests.

              • 4. Re: FDM to FDMEE
                jaygop

                I will be damned. All issues because of using an old FDM schema. Even though you say drop and recreate while configuration, it doesn't create the necessary columns in the necessary tables. I am moving forward to the data_extract step. Thanks for the responses.

                • 5. Re: FDM to FDMEE
                  jaygop

                  Anyone knows how to migrate the users and object maintenance from FDM to FDMEE ? I am not that familiar with FDM Hope there is an easier way.