9 Replies Latest reply on Aug 23, 2010 4:23 PM by 670573

    ERPi (ODI) EBS to HFM

    739418
      I need help, I am able to configure EBS with HFM using ERPi (ODI), I followed all the steps mentioned to configure like creating dataserver, physical and logical connections and configuration is successful. I am able to initialize source also , but I am not able to see the data from source in ERPi.

      Do I need to perform any ETL part in ODI?????. Thank you.

      Edited by: micro_sri on Mar 31, 2010 7:24 AM
        • 1. Re: ERPi (ODI) EBS to HFM
          Sandeep Reddy
          Hi,

          1. When you initialize the source system ( in your case EBS0) , Did you get process id and extract id

          2. If you have got, go to agent screen and see if any error is there

          3. Now, go to operator of ODI and chekc if you execution has been succesful or failed

          Sandeep Reddy Enti
          HCC
          http://hyperionconsultancy.com/
          • 2. Re: ERPi (ODI) EBS to HFM
            763810
            Hi,

            Thanks for your response.

            1. When you initialize the source system ( in your case EBS0) , Did you get process id and extract id
            Yes I did get process id but no extract id

            2. If you have got, go to agent screen and see if any error is there
            no errors found

            3. Now, go to operator of ODI and chekc if you execution has been succesful or failed

            NO I could not find any.

            I have one more question to ask, do we need to perform any other thing apart from configuration of EBS to EPM

            Edited by: user12694254 on Mar 31, 2010 1:11 AM
            • 3. Re: ERPi (ODI) EBS to HFM
              Sandeep Reddy
              Hi,

              Let me try in steps

              1. After source system initialization, you go to target application registration and provide information of your target application

              2. Next , you would add rule within the target application ,here you select source system and also Ledger. Are you getting this ?

              Sandeep Reddy Enti
              HCC
              http://hyperionconsultancy.com/
              • 4. Re: ERPi (ODI) EBS to HFM
                user8702914
                When you created source system (via the source system registration) did you get a successful (green check mark) within the Operator when you initialized?

                Edited by: user8702914 on Apr 1, 2010 9:02 PM
                • 5. Re: ERPi (ODI) EBS to HFM
                  763810
                  HI


                  1. After source system initialization, you go to target application registration and provide information of your target application

                  Yah thats correct , I did it.

                  2. Next , you would add rule within the target application ,here you select source system and also Ledger. Are you getting this ?

                  NO I am not getting this.

                  FYI...

                  I tested the source registration by giving dummy values and it accepted with out throwing any error.

                  But the values that I entered earlier are correct but seems the connection is not happening between ERPi(EPM) and ODI

                  EPM+ERPi are installed on one machine and ODI on other machine , but as per your earlier question I am not able to find any logs in Agent and Server.

                  Very much confused now,

                  I went through many docs and finally understood that we need to create just configure all applications and then to create work repository in Execution mode. I followed the steps as mentioned below.

                  http://www.oracle.com/technology/obe/hyp_fc/ERPI_Config_11.1.1.3/ConfigERPI.htm

                  Can you please help me in resolving this problem.

                  regards,
                  • 6. Re: ERPi (ODI) EBS to HFM
                    763810
                    HI ,

                    Yah I am able to see, even if I give dummy values for Source registration and its not throwing any error.


                    I am not able to find any thing in Select Source Accounting Entity for Integration.

                    When I try to create Datarule I am not able to find Ledger there.

                    regards

                    Edited by: micro_sri1 on Apr 7, 2010 11:03 PM

                    Edited by: micro_sri1 on Apr 7, 2010 11:18 PM
                    • 7. Re: ERPi (ODI) EBS to HFM
                      763810
                      HI All,

                      I am now able to see the extract id and am able to see messages in session list, but now the process fails at ODI and below is the error, Can you please help me out.
                      SELECT source_system_id
                      FROM AIF_processes
                      WHERE process_id = #AIF.p_process_id




                      update aif_processes
                      set status = CASE 'FAILED'
                      WHEN 'SUCCESS' THEN
                      CASE (
                      SELECT COUNT(*)
                      FROM AIF_PROCESS_DETAILS pd
                      WHERE pd.PROCESS_ID = aif_processes.PROCESS_ID
                      AND pd.STATUS IN ('FAILED','WARNING')
                      )
                      WHEN 0 THEN 'SUCCESS'
                      ELSE (
                      SELECT MIN(pd.STATUS)
                      FROM AIF_PROCESS_DETAILS pd
                      WHERE pd.PROCESS_ID = aif_processes.PROCESS_ID
                      AND pd.STATUS IN ('FAILED','WARNING')
                      )
                      END
                      ELSE 'FAILED'
                      END
                      ,error_message = (
                      select 'Connection to AIF Target Failed' #AIF.p_concat_operator ': ' #AIF.p_concat_operator ps.step_name
                      from aif_process_steps ps
                      where ps.process_id = aif_processes.process_id
                      and ps.status <> 'SUCCESS'
                      and ps.step_seq = (
                      select min(ps2.step_seq)
                      from aif_process_steps ps2
                      where ps2.process_id = ps.process_id
                      and ps2.status <> 'SUCCESS'
                      )
                      )
                      ,last_updated_by = '#AIF.p_last_updated_by'
                      ,last_update_date = CURRENT_TIMESTAMP
                      where process_id = #AIF.p_process_id


                      thanks in Advance,
                      • 8. Re: ERPi (ODI) EBS to HFM
                        user8702914
                        What was the sql returned when you ran this sql statement (check the ODI Operator)?

                        Does the database user used to execute this statement have update privileges on this table?

                        I am thinking possibly two things could have happened. First, the user does not have update privileges on the table or #AIF variables (i.e. #AIF.p_process_id) are not getting populated correctly. It could help to bring the DBA on board and tell him to do a sql trace to see what sql statements are executed.

                        HTH
                        • 9. Re: ERPi (ODI) EBS to HFM
                          670573
                          Hi,
                          It looks like you were able to resolve this issue. Can you provide details on what steps you took to resolve the issue?

                          Thanks in advance!