7 Replies Latest reply on Jan 9, 2014 12:47 PM by Praveen. A

    FDMEE 11.1.2.3 FDM not visible in Target Applications

    Praveen. A

      Hi

       

      In FDMEE 11.1.2.3 when i clicked in target applications i am not getting FDM Applications  there.

       

      I am able to see only below applications

      1.Plannning

      2.Essbase

      3.Financial Management

      4. Account Reconcilation Manager

       

       

      How can i get FDM applications there in Target Applications.

       

      Thanks,

      Praveen

        • 1. Re: FDMEE 11.1.2.3
          JeffJon

          FDM will not show as a target application in the list.

           

          You would need to register the FDM application under "FDM Applications"

           

          May I ask the reason that you are doing this? 

          1 person found this helpful
          • 2. Re: FDMEE 11.1.2.3
            Praveen. A

            Hi Jeff

             

            I Have already registered 2 FDM Applications   in Application Group in shared services

             

            Still i am not able to see FDM in target application list

             

            i want to load file data from FDM TO Essbase

             

            File - >through  FDMEE   ( in target i want to register FDM Applications )->ESSBASE

             

            Thanks,

            Praveen

            • 3. Re: FDMEE 11.1.2.3
              Praveen. A

              Hi Jeff

               

              this is mentioned in FDMEE admin Guide , But our FDM applications are registered in shared services .

               

              You can enable applications registered in FDM to be registered as target applications in FDMEE.

              Use this for Oracle Hyperion Strategic Finance or Oracle Hyperion Enterprise® are registered

              in FDM, but are not registered in Oracle Hyperion Shared Services. After you enable the

              applications, define import formats, locations, and data load rules in FDMEE.

              Note: FDMEE supports loading data and drill through for FDM applications, but does not

              support loading metadata or writing-back data for applications registered in FDM.

              ä To enable FDM applications:

              1 In the Tasks pane, select FDM Application.

              The FDM Application page is displayed.

              2 Click Add.

              3 In the Name field, enter the FDM application schema name.

              4 Enter the User Name and Password for the application schema.

              5 Optional: Select Remote Database.

              If FDM accesses a database that is different from the FDMEE database, select Remote.

              If FDM accesses the same database as FDMEE, do not select Remote Database since FDMEE

              obtains the connection information from the Oracle Hyperion Shared Services Registry.

              Note: FDM and FDMEE must be on the same database platform. Either on Oracle or SQL

              Server.

               

              6 For SQL Server databases only: Enter the SQL Server Database Name.

              7 If you selected Remote Database, click to select a generic JDBC URL address. Then, modify the

              <host>, <port>, and <SID>. For example, server.oracle.com:1521:orcl.

              8 To test the connection, click Test Connection.

              9 Click Save.

               

              Thanks,

              • 4. Re: FDMEE 11.1.2.3
                JeffJon

                If you would like to load data form FDM to Essbase you would use the following setup:

                 

                A) Import and register the Essbase adapter in FDM

                B) Configure the Essbase Adapter in FDM to point to the proper Essbase Application/DB you would like to load data to

                C) Import and register the ERPi source system adapter in the FDM application

                D) Create an import format in FDM for the ERPI Source System Adapter

                E) Assign the Source System adapter import format to the location in FDM to be used to load to Essbase

                F) Update Integration Option 1 with the data load rule to execute in FDMEE

                G) Run the import in FDM to execute the DL Rule in FDMEE and pull the data into FDM

                H) Proceeed to validate/export/load to move the data to Essbase.

                 

                As it mentions in the guide, the registration of a FDM application in FDMEE is only for an FDM application loading to HSF or Hyperion Enterprise.

                 

                NOTE: You can use FDMEE to load a flat file to Essbase directly.

                • 5. Re: FDMEE 11.1.2.3
                  Praveen. A

                  Hi Jeff

                  i have done all the below steps

                  1. I have Imported and Registered Essbase Adaptor in FDM

                  2. I have Configure the Essbase Adapter in FDM to point to the proper Essbase Application/DB you would like to load data to

                  3. Import and register the ERPi source system adapter in the FDM application

                  4.Create an import format in FDM for the ERPI Source System Adapter

                    ImportGroup:

                     Import Group       FileType         Delimiter

                      Imp                    Adaptor           NA

                   

                  Import Format:

                    Source Adaptor

                    Adaptor=ERPI-FINE-1

                  5.Assigned  the Source System adapter import format to the location in FDM to be used to load to Essbase

                  6.ERPI Data Rule Name i have given Data rule name which i have defined in FDMEE

                  7.Run the import in FDM to execute the DL Rule in FDMEE and pull the data into FDM


                  when i tried to click import i am getting error  " Import failed.Invalid data or Empty content." Connect failed. See adapter log.


                  Thanks,

                  Praveen

                   

                  • 6. Re: FDMEE 11.1.2.3
                    JeffJon


                    What shows in the adapter log?  It will be located in outbox\Logs for the FDM application folder.

                     

                    ERPi-Fin-E1.log    

                    • 7. Re: FDMEE 11.1.2.3 FDM not visible in Target Applications
                      Praveen. A

                      Hi Jeff

                       

                      this is the  log  which is there in Outbox\Logs in FDM application folder

                      -----------------------------------------------------------------------------

                      *** clsGetFinData.fConnect @ 1/8/2014 2:26:19 AM ***

                      -----------------------------------------------------------------------------

                      INTEGRATED SECURITY: FDM DB User not specified.

                      -----------------------------------------------------------------------------

                       

                       

                      -----------------------------------------------------------------------------

                      *** clsGetFinData.fConnect @ 1/8/2014 2:27:09 AM ***

                      -----------------------------------------------------------------------------

                      INTEGRATED SECURITY: FDM DB User not specified.

                      -----------------------------------------------------------------------------

                       

                       

                      -----------------------------------------------------------------------------

                      *** clsGetFinData.fConnect @ 1/8/2014 2:31:53 AM ***

                      -----------------------------------------------------------------------------

                      INTEGRATED SECURITY: FDM DB User not specified.

                      -----------------------------------------------------------------------------

                       

                       

                      -----------------------------------------------------------------------------

                      *** clsGetFinData.fConnect @ 1/8/2014 2:54:39 AM ***

                      -----------------------------------------------------------------------------

                      INTEGRATED SECURITY: FDM DB User not specified.

                      -----------------------------------------------------------------------------

                       

                       

                      -----------------------------------------------------------------------------

                      *** clsGetFinData.fConnect @ 1/8/2014 2:57:05 AM ***

                      -----------------------------------------------------------------------------

                      INTEGRATED SECURITY: FDM DB User not specified.

                      -----------------------------------------------------------------------------

                       

                       

                      -----------------------------------------------------------------------------

                      *** clsGetFinData.fConnect @ 1/8/2014 3:34:59 AM ***

                      -----------------------------------------------------------------------------

                      INTEGRATED SECURITY: FDM DB User not specified.

                      -----------------------------------------------------------------------------

                       

                       

                      -----------------------------------------------------------------------------

                      *** clsGetFinData.fConnect @ 1/8/2014 3:42:48 AM ***

                      -----------------------------------------------------------------------------

                      INTEGRATED SECURITY: FDM DB User not specified.

                      -----------------------------------------------------------------------------

                       

                       

                      -----------------------------------------------------------------------------

                      *** clsGetFinData.fConnect @ 1/8/2014 3:48:43 AM ***

                      -----------------------------------------------------------------------------

                      INTEGRATED SECURITY: FDM DB User not specified.

                      -----------------------------------------------------------------------------

                       

                       

                      -----------------------------------------------------------------------------

                      *** clsGetFinData.fConnect @ 1/8/2014 3:53:25 AM ***

                      -----------------------------------------------------------------------------

                      INTEGRATED SECURITY: FDM DB User not specified.

                      -----------------------------------------------------------------------------

                       

                       

                      -----------------------------------------------------------------------------

                      *** clsGetFinData.fConnect @ 1/8/2014 4:56:58 AM ***

                      -----------------------------------------------------------------------------

                      INTEGRATED SECURITY: FDM DB User not specified.

                      -----------------------------------------------------------------------------

                       

                       

                      -----------------------------------------------------------------------------

                      *** clsGetFinData.fConnect @ 1/8/2014 4:58:23 AM ***

                      -----------------------------------------------------------------------------

                      INTEGRATED SECURITY: FDM DB User not specified.

                      -----------------------------------------------------------------------------

                       

                       

                      -----------------------------------------------------------------------------

                      *** clsGetFinData.fConnect @ 1/8/2014 5:07:53 AM ***

                      -----------------------------------------------------------------------------

                      INTEGRATED SECURITY: FDM DB User not specified.

                      -----------------------------------------------------------------------------

                       

                       

                       

                      Do we need to apply any patch for getting FDM application in target

                      because our is FDMEE 11.1.2.3.000.0029