4 Replies Latest reply on Sep 20, 2011 5:14 AM by pr921

    drill through

    pr921
    pr921 Sep 17, 2011 12:31 AM
      To drill through to EBS do you need to configure ODI w/ FDM?

      Jz
      • 61 Views
      • Tags:
        • 1. Re: drill through
          SH_INT
          SH_INT Sep 19, 2011 10:54 AM (in response to pr921)
          You always need to configure ODI to enable drillthrough with ERPI regardless of whether you use FDM or not as that is the undrlying integration technology that facilitates drillback
          • 2. Re: drill through
            pr921
            pr921 Sep 19, 2011 4:04 PM (in response to SH_INT)
            In what schema do you put the user defined interface tables?

            Jz
            • 3. Re: drill through
              JeffJon
              JeffJon Sep 19, 2011 6:11 PM (in response to pr921)
              In order to drill through to EBS you need to configure ERPI to use a data load rule to retrieve data from EBS and use the data load rule name in the ERPi-Fin adapter in the FDM application. From FDM you can then drill through to ERPi and then drill from ERPi to EBS.

              ERPi does require use of ODI. There are a few different KM Articles out in My Oracle Support that outline the process to setup ERPi and configure ODI on the back end for proper use.

              Please refer to the following KM Documents

              951369.1 for 11.1.1.3.0
              1169565.1 for 11.1.2.x
              • 4. Re: drill through
                pr921
                pr921 Sep 20, 2011 5:14 AM (in response to JeffJon)
                thank you..

                I couldn't find any articles on how to load metadata into interface tables for loading to EPMA Shared Library...have you seen any?

                We are on 11.1.2.1

                Thanks a lot!
                Jz