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

    FDMEE Metadata Load to EPMA Fails

    $ameer

      Hi,

       

      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.

       

      Thanks

      Sameer