14 Replies Latest reply: Nov 7, 2012 11:16 PM by User578264 RSS

    Webcenter Imaging and AXF Integration

    User578264
      Hi,

      I am implementing the solution accelerator solution (Imaging and EBS R12 integration). I have followed the steps given in the document and at the end of the integration to check if AXF is integration is done successfully or not , I need to execute a command.

      The steps taken to do the integration is -

      Configuring the EBS Adapter for ECM

      Configuring the EBS Adapter has two aspects – the server or AXF has to be configured with the invoice processing solution and the EBS plug-in has to be configured to match. The solution accelerator includes SQL scripts that can be used as a starting point for this configuration.

      Configuring AXF

      1.Locate and open AXF_SOLUTION_CONFIGURATION.sql, contained in the dbscripts directory of the accelerator distribution, in a text editing program.
      2.Perform a search and find the “AXF_SOLUTION_ATTRIBUTES” table insert statements, replace all occurrences of the BPEL connection name ”test” with the BPEL connection name configured in IPM. Save all changes to AXF_SOLUTION_CONFIGURATION.sql.
      3.Perform a search and find the “AXF_SOLUTION_PARAMETERS” table insert statements, replace all occurrences of “MyIPMServer:Port” with the server and port of your IPM server. Save all changes to AXF_SOLUTION_CONFIGURATION.
      4.4.Connect to your database with the AXF Schema created during AXF Installation.

      5.Execute AXF_SOLUTION_CONFIGURATION.sql and verify that the insertion was successful. (NOTE: If you have already run the insertHelloWorldBpelData.sql script you may see constraint errors when running this script. These can be ignored).

      Configuring the EBS Plug-In


      1.Locate and open AXF_EBS_SOLUTION_DATA.sql in a text editing program (this SQL script is located in the EBS directory of the solution accelerator zip).

      2.Perform a Search and Replace action on “http://MyIPMServer:Port”, replacing it with the fully-qualified machine name and port of the server where IPM/AXF is deployed. Save all changes to AXF_EBS_SOLUTION_DATA.sql.

      3.Connect to your database with the EBS Schema created during AXF Installation.

      4.Execute AXF_EBS_SOLUTION_DATA.sql and verify that the insertion was successful.

      Configuring Coding Form Lookups

      Locate the AXF_LOOKUPS.sql script. Execute the scripts as the E-Business Suite configuration schema user (APPS). To execute the script, enter:
      @AXF_LOOKUPS.sql


      To verify the installation of the Invoice accelerator, perform the following steps:
      1.     Access the driver page using the following URL:
      http://host:port/imaging/faces/Driver.jspx
      2.     After logging in, enter the following values:
      1.     Solution Namespace: InvoiceProcessing
      2.     Command Namespace: StartInvoiceProcessing
      3.     User Name: (set according to your configuration)
      3.     Select the Execute Command button
      4.     The AXF Response should be displayed in Response Commands table:
      NOTE: Your Conversation ID will be different than the one displayed
      5.     Select the Execute Response button.

      6.     The AXF Task list should be displayed with the My Saved Tasks, Manual Entry, Validation Failures and Pending Verification views that you configured in the BPM Worklist.

      I am able to generate the conversation ID. But when I hit the "Execute Response" button, I am getting a 500 error page.

      Any pointers would be really helpful. Please let me know, if I need to post this query on any other forum to get any responses as well.

      Regards
      Avi
        • 1. Re: Webcenter Imaging and AXF Integration
          VikrantKorde 1
          Hi avi,

          Ideally it shoulod work as driver.jspx and URL of "Execute response" both are pointing to same server. few possibilities are like
          - Check if hostname is proper and it has proper entry in hosts file
          - Check in the weblogic console (7001/console) if all ther servers are up and running

          also share both the URL i.e. drivers.jspx and the URL that gers generated after you click on "Execute reqquest"

          Regards,
          Vikrant Korde.
          • 2. Re: Webcenter Imaging and AXF Integration
            User578264
            Hi Vikrant,

            Thank you for your reply. There was an issue with provider URL in the "Invoices" application in IPM, I was not using a t3 protocol.

            Having said that, I am now able to access the various profiles in worklist like - "Manual Entry", "Validation Failure" etc. But, when I scan a document using ODC and push it to IPM , I have selected the processing group as "Manual Entry", but I am not able to see any tasks listed under "Manual Entry" profile in worklist.

            Can you please let me know, if I am missing anything, or this is the way it should work?

            Thanks in Advance

            Avi
            • 3. Re: Webcenter Imaging and AXF Integration
              Aditya
              Avi,

              You would have to check if a task has been initiated at all. You can check if the task has been initiated in the em console and the first process which would be fired is the document routing process. If that has been fired and then you would have the tasks being allocated.
              • 4. Re: Webcenter Imaging and AXF Integration
                VikrantKorde 1
                Hi Avi,

                As Aditya mentioned, you need to check in the EM console (http://{host}:7001/em), if the instance is getting generated.
                If it is getting generated then check in the BPM worklist if the instance is visible in the inbox. (http://{host}:8001/integration/worklistapp/)
                You will see the same view with the same name as that of profile in axf worklist. Click on that. see if the instance is available therer.
                If the instance is not available then you need to change the filter conditions for that view in BPM worklist.
                check the condition for processing group whethere it is "Manual Entry" or it is "ManualEntry" one has space and other doesn;t. Check what value you are sending.

                Regards,
                Vikrant Korde.
                • 5. Re: Webcenter Imaging and AXF Integration
                  User578264
                  Hey Guys,

                  Thank you for the reply. I checked EM console, I see a fault in the document routing instance -

                  Error Message: {http://schemas.oracle.com/bpel/extension}remoteFault


                  Fault ID default/DocumentRouting!1.0*soa_69af170c-7bad-4cfb-9a69-801164e9b544/DocumentRouting/10010-BpInv3-BpSeq4.5-3
                  Fault Time 06/11/2012 6:36:50 PM


                  Non Recoverable System Fault :

                  <bpelFault><faultType>0</faultType><remoteFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>oracle.fabric.common.FabricException: oracle.fabric.common.FabricException: Error in getting XML input stream: http://http://usatl01lt616.amer.lendlease.com:8001/soa-infra/services/default/InvoiceProcessing/invoiceprocessing_client_ep?WSDL: http: Error in getting XML input stream: http://http://usatl01lt616.amer.lendlease.com:8001/soa-infra/services/default/InvoiceProcessing/invoiceprocessing_client_ep?WSDL: http</summary></part><part name="detail"><detail>http</detail></part></remoteFault></bpelFault


                  I checked the BPM worklist view - the processing group view was set to "ManualEntry" , but my AXF profile has "Manual Entry". I have edited the BPM worklist view.

                  Please let me know, if you have any pointers for the error shown above.

                  Regards,
                  Avi
                  • 6. Re: Webcenter Imaging and AXF Integration
                    VikrantKorde 1
                    Hi Avi,

                    Goto the log files of Soa server on your server
                    /oracle/middleware/user_projects/domains/{domain name}/servers/soa_server1/logs

                    Copy the errro from this log and put it here. That will be helpful to understand the exact reason.

                    Regards,
                    Vikrant Korde.
                    • 7. Re: Webcenter Imaging and AXF Integration
                      VikrantKorde 1
                      Hi Avi,

                      I was referring to the condition present in the profile (i.e. view in BPM worklist). anyway the name of the profile (AXF task list) and the view (BPM work list) should be the same.

                      Regards,
                      Vikrant Korde.
                      • 8. Re: Webcenter Imaging and AXF Integration
                        User578264
                        Hi Vikrant,

                        Thank you. I will upload the error snippet from the SOA server log.

                        One more clarification I needed, when configuring the business rules, in SOA composer, do I need to use a specific user and group, or it can be any user and group for the rules , like Invoice Processing Assignment Rule Set etc.

                        Regards
                        Avi
                        • 9. Re: Webcenter Imaging and AXF Integration
                          VikrantKorde 1
                          Ideally specific user and group. Make sure that these users and groups are present in Weblogic or else that invoice will go in altered state and will not be visible in AXF work list (as BPM worklist goes hands in hand, it will not be visible in BPM work list also). For such cases you need to go in Administrative tasks in BPM worklist and look for alerted state instances.

                          Regards,
                          Vikrant Korde.
                          • 10. Re: Webcenter Imaging and AXF Integration
                            User578264
                            Hi Vikrant,

                            I do not have any errors logged in the SOA_server1.log. I only see info messages.

                            Coming back to the implementation -

                            I will check and update the user and group for all the SOA composer rules to point to weblogic.

                            Also, in my "Manual Entry" profile view in worklist , the processing group is set to "ManualEntry". Do I need to match this processing group to the AXF tasklist profile name?

                            Regards,
                            Avi
                            • 11. Re: Webcenter Imaging and AXF Integration
                              VikrantKorde 1
                              Always check soa_server1-diagnostic.log file for errors.

                              there are 2 things
                              - The value in the condition of view (BPM worklist). This is a filter for the instances to be shown. Do not relate this with Name of the view.
                              - the name of view (BPM worklist) should match to the name of the profile entered in Solution Editor i.e. log in to imaging then tools ->Solution Editor
                              select solution name space, in this case it will be InvoiceProcessing then check the General -> List of profiles over here name should match.

                              Regards,
                              Vikrant Korde.
                              • 12. Re: Webcenter Imaging and AXF Integration
                                User578264
                                Hi Vikrant,

                                I have got the error snippet from the diagnoistic log for SOA.
                                I think I have found the error - if you see below, the XML input stream points to : http://http://://usatl01lt616.amer.lendlease.com:8001/soa-infra/services/default/InvoiceProcessing/invoiceprocessing_client_ep?WSDL: http: Error in getting XML input stream

                                Do you think this can be an issue? Also, to resolve this, I was thinking of modifying the BPEL processes and re-deploying them via Jdeveloper. Do you have a better option to get around this?

                                [2012-11-07T00:15:00.580-05:00] [soa_server1] [ERROR] [] [oracle.soa.bpel.engine.dispatch] [tid: orabpel.invoke.pool-4.thread-1] [userId: <anonymous>] [ecid: 865998f9aeeaf3b0:4c89f4a:13acd705e0b:-8000-00000000000092ed,1:31958] [APP: soa-infra] failed to handle message[[
                                com.oracle.bpel.client.BPELFault: faultName: {{http://schemas.oracle.com/bpel/extension}remoteFault}
                                messageType: {{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage}
                                parts: {{
                                summary=<summary>oracle.fabric.common.FabricException: oracle.fabric.common.FabricException: Error in getting XML input stream: http://http://usatl01lt616.amer.lendlease.com:8001/soa-infra/services/default/InvoiceProcessing/invoiceprocessing_client_ep?WSDL: http: Error in getting XML input stream: http://http://usatl01lt616.amer.lendlease.com:8001/soa-infra/services/default/InvoiceProcessing/invoiceprocessing_client_ep?WSDL: http</summary>
                                ,detail=<detail>http</detail>}

                                Regards
                                Abhilash
                                • 13. Re: Webcenter Imaging and AXF Integration
                                  Aditya
                                  Abhilash,

                                  I think the issue is pretty apparent, when you have updated the BPEL processes specifically the invoice processing process you seem to have the URI replaced by the http protocol twice.

                                  Check this :

                                  http://http//://usatl01lt616.amer.lendlease.com:8001/soa-infra/services/default/InvoiceProcessing/invoiceprocessing_client_ep?WSDL

                                  When it should be

                                  http://usatl01lt616.amer.lendlease.com:8001/soa-infra/services/default/InvoiceProcessing/invoiceprocessing_client_ep?WSDL -- without the extra http.

                                  I would suggest that you change the same in JDev, redeploy the process/es and re-initiate the process.


                                  Aditya

                                  Edited by: Aditya on Nov 7, 2012 8:35 PM
                                  • 14. Re: Webcenter Imaging and AXF Integration
                                    User578264
                                    Hi Aditya,

                                    Thanks a lot for this.

                                    Cheers
                                    Avi