1 person found this helpful
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.
Please can you attached:
- utility log
- screenshot of the ODI operator step failing (with details)
- the query
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.
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.
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.