3 Replies Latest reply on Sep 15, 2016 8:18 AM by $ameer

    FDMEE Metadata Load to EPMA Fails




      We are trying to do metadata load using FDMEE, the source is Oracle EBS release 12 and the target is ESSBASE cube deployed via EPMA.

      We have followed the following steps

      1. Registered Source and Target applications

      2. Ensured all generic target dimension type is associated with data table (UD1, UD2...)

      3. Created the import format

      4. Created Location, Period, Category

      5. Create Metadata Rule


      No while executing the metadata rule we get error saying

      java.lang.Exception: javax.xml.rpc.soap.SOAPFaultException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Invalid object name 'IM_Dimension'


      We had created a EPMA data source but had not chosen the create tables options as it is documented not to choose the option if loading via FDMEE. For this error we checked the underlying tables in FDMEE and see this object 'IM_Dimension' available there.


      Any help regarding the same would be great.