13 Replies Latest reply on Sep 10, 2014 3:59 PM by Ken Peterka-Oracle

    How to configure Email process for Invoice  in Oracle Capture 11g

    2640019
    2640019 Aug 4, 2014 7:39 AM

      Hi,

       

      we are using using ODC 10g for Email invoice process through Email account into ODC. it is working fine.. we have configured all email related configuratins in ODC 10g import server.it is working fine.

       

      Same like, we are newly started working on Oracle Document Capture 11g, we have created workspace , client profiles, metadata etc.

       

      i have configured  for Email process invoice in Import jobs. Mail server a/c verified sucessfully. But  When i sent Email invoice to Email a/c which is not coming into Oracle Document Capture 11g. all the Email invoices not coming to Oracle Document Capture 11g. even i have separatly created Email index profile in Client profile and i have selected as 1- Index only option. even though Email invoices not coming into Capture 11g.

       

      Can anybody let me know, what would be the missed steps for Email configuration in Capture 11g.

       

      Please provide complete steps for Email configuration in Oracle Document Capture 11g.

       

      Help would be really appriciated.

       

      Thanks in advance.

      • 4365 Views
      • Tags:
        • 1. Re: How to configure Email process for Invoice  in Oracle Capture 11g
          Ryan Sullivan
          Ryan Sullivan Aug 4, 2014 10:35 PM (in response to 2640019)

          Have you checked the logs? You must check the logs as step #1 in all cases.

           

          I can tell you that the import processor works as documented on Linux and windows systems. If it's configured correctly, it'll be working.

           

          Let's see what your logs say before trying to guess at anything.

           

          -ryan

          • 2. Re: How to configure Email process for Invoice  in Oracle Capture 11g
            Vikrant Korde.
            Vikrant Korde. Aug 5, 2014 8:33 AM (in response to 2640019)

            Here are the details for configuring logging

            Configuring and Viewing Capture Log Files - 11g Release 1 (11.1.1)

             

            For detailed steps for Email configuration check this out

            Managing Import Processing - 11g Release 1 (11.1.1)

             

            Regards,

            Vikrant Korde.

            • 3. Re: How to configure Email process for Invoice  in Oracle Capture 11g
              2640019
              2640019 Aug 7, 2014 6:30 PM (in response to Ryan Sullivan)

              Hi,

               

              I am unable to process Emailed invoices into Oracle Capture 11g via Email. nothing is coming to Capture 11g.as we have configured email server sucessfully, by using verified option we have tested,

               

              but Invoices not able to process into Capture. Please find below logs and help us to get it resolve.

               

              The following data appears in the log :--

               

              [2014-08-07T09:50:46.669-04:00] [cw3120-16400] [ERROR] [] [oracle.odc.importprocessor.ImportJobSchedulerSessionBean] [tid: [ACTIVE].ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 813ca487ccd4603f:2f39f7de:147acccfeb5:-8000-0000000000003a23,0] [APP: capture] Error connecting to account[[

              • oracle.odc.exception.CaptureException: Error connecting to account

                              at oracle.odc.importprocessor.email.EmailSource.processAccount(EmailSource.java:193)

                              at oracle.odc.importprocessor.email.EmailSource.process(EmailSource.java:1017)

                              at oracle.odc.importprocessor.ImportProcessorBean.onMessage(ImportProcessorBean.java:167)

                              at sun.reflect.GeneratedMethodAccessor328.invoke(Unknown Source)

                              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                              at java.lang.reflect.Method.invoke(Method.java:597)

                              at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

                              at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)

                              at oracle.security.jps.ee.ejb.JpsAbsInterceptor$1.run(JpsAbsInterceptor.java:113)

                              at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

                              at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

                              at oracle.security.jps.ee.ejb.JpsAbsInterceptor.runJaasMode(JpsAbsInterceptor.java:100)

                              at oracle.security.jps.ee.ejb.JpsAbsInterceptor.intercept(JpsAbsInterceptor.java:154)

                              at oracle.security.jps.ee.ejb.JpsInterceptor.intercept(JpsInterceptor.java:113)

                              at sun.reflect.GeneratedMethodAccessor234.invoke(Unknown Source)

                              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                              at java.lang.reflect.Method.invoke(Method.java:597)

                              at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)

                              at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)

                              at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

                              at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)

                              at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

                              at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)

                              at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

                              at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)

                              at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

                              at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

                              at com.sun.proxy.$Proxy188.onMessage(Unknown Source)

                              at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:583)

                              at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:486)

                              at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:389)

                              at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659)

                              at weblogic.jms.client.JMSSession.execute(JMSSession.java:4345)

                              at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3822)

                              at weblogic.jms.client.JMSSession.access$000(JMSSession.java:115)

                              at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)

                              at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)

                              at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

                              at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

              Caused by: javax.mail.AuthenticationFailedException: AUTHENTICATE failed.

                              at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:566)

                              at javax.mail.Service.connect(Service.java:288)

                              at oracle.odc.importprocessor.email.EmailSource.processAccount(EmailSource.java:191)

                              ... 38 more

               

              Thanks in advance.

               

              • 4. Re: How to configure Email process for Invoice  in Oracle Capture 11g
                Ryan Sullivan
                Ryan Sullivan Aug 7, 2014 10:10 PM (in response to 2640019)

                Can you confirm that the email address validates successfully when configuring in the console? can you post a screenshot?

                 

                Where is your IMAP server hosted? For a test, if your system is open to the internet, you may want to attempt to connect to a gmail account. This is an easy way to see if the issue is with your Capture app or your IMAP server.

                 

                You may want to change your IMAP port. Port 993 is the typically preferred IMAP SSL port, but perhaps you don't have SSL enabled on your IMAP server. Or, there could be a limited set of Authentication methods allowed on your IMAP server.

                 

                Try to configure with gmail. that's confirmed as a working IMAP host. Chances are you'll need to get your email server admin involved to verify compatibility.

                 

                hope this helps,

                -ryan

                • 5. Re: How to configure Email process for Invoice  in Oracle Capture 11g
                  2640019
                  2640019 Sep 1, 2014 7:51 AM (in response to Ryan Sullivan)

                  Hi,

                   

                  we have resolved the issue email server configuration in Webcenter Capture 11g. when i verifies the Email address it is sucessfully connects.

                   

                  But, Invoices not able to imports in Webcenter Capture Client window. i have verified the logs alos. please fnd below log errors.

                   

                  the logs are appears to be in below -

                  [2014-09-01T03:32:26.777-04:00] [cw3120-16400] [WARNING] [] [oracle.odc.commitprocessor.CommitProcessor] [tid: [ACTIVE].ExecuteThread: '9' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 813ca487ccd4603f:-28e95dfb:1482339e0ef:-8000-000000000000d26b,0] [APP: capture] The following required fields do not have values: [Classification][[
                  oracle.odc.exception.CommitException: The following required fields do not have values: [Classification]
                  at oracle.odc.commitprocessor.CommitProcessor.processBatch(CommitProcessor.java:302)
                  at oracle.odc.batchprocessor.BatchProcessorBean.processMessage(BatchProcessorBean.java:135)
                  at oracle.odc.batchprocessor.CommitProcessorBean.onMessage(CommitProcessorBean.java:59)
                  at sun.reflect.GeneratedMethodAccessor4569.invoke(Unknown Source)
                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                  at java.lang.reflect.Method.invoke(Method.java:597)
                  at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                  at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)
                  at oracle.security.jps.ee.ejb.JpsAbsInterceptor$1.run(JpsAbsInterceptor.java:113)
                  at oracle.security.jps.ee.ejb.JpsAbsInterceptor.intercept(JpsAbsInterceptor.java:154)
                  at oracle.security.jps.ee.ejb.JpsInterceptor.intercept(JpsInterceptor.java:113)
                  at sun.reflect.GeneratedMethodAccessor234.invoke(Unknown Source)
                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                  at java.lang.reflect.Method.invoke(Method.java:597)
                  at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
                  at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)
                  at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                  at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                  at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                  at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
                  at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                  at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                  at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                  at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                  at com.sun.proxy.$Proxy240.onMessage(Unknown Source)
                  at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:388)
                  at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659)
                  at weblogic.jms.client.JMSSession.execute(JMSSession.java:4345)
                  at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3822)
                  at weblogic.jms.client.JMSSession.access$000(JMSSession.java:115)
                  at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)
                  at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
                  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
                  at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

                  ]]
                  [2014-09-01T03:32:26.824-04:00] [cw3120-16400] [NOTIFICATION] [] [oracle.odc.batchprocessor.BatchProcessorBean] [tid: [ACTIVE].ExecuteThread: '9' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 813ca487ccd4603f:-28e95dfb:1482339e0ef:-8000-000000000000d26b,0] [APP: capture]  [EMINV_80 (373)] No batch processor specified, batch will be unlocked and placed in a ready state.

                   

                  Plese help me resolve this issue for processing invoices into Capture client.

                   

                  Thanks in advance.

                  • 6. Re: How to configure Email process for Invoice  in Oracle Capture 11g
                    Sonal C
                    Sonal C Sep 1, 2014 1:29 PM (in response to 2640019)

                    In the Import job, when the Default Document Profile is set to something other than “(none)”, and then set back to “(none)”, the value stored in the job is an empty string. When the job is processed, it only checks if the ID of the default document profile is not null, and if it’s not null, it tries to look up the profile, which won’t exist because it’s an empty string.

                     

                    The current work around for this issue to to delete the Import Processor job and recreate it.

                    • 7. Re: How to configure Email process for Invoice  in Oracle Capture 11g
                      2640019
                      2640019 Sep 2, 2014 1:52 PM (in response to Sonal C)

                      Hi,

                       

                      I have tried the specified solution on above mentioned for Email issue in Webcenter Capture. it did not work out. i have deleted existing email import job and re created it. But  No batches importing into Webcenter Capture.

                       

                      Since i am new to upgraded version of Webcenter Capture,i am not able to find out the solution.

                       

                      please find below logs and any one help me to resolve this Email issue.

                      Same error appears to be in logs:-

                       

                      [2014-09-02T08:28:45.521-04:00] [cw3120-16400] [NOTIFICATION] [] [oracle.mds] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: 502295247] [ecid: 813ca487ccd4603f:-28e95dfb:1482339e0ef:-8000-0000000000013af1,0] [APP: capture] [DSID: 0000KWqL4_f4Iv9xZcK6wb1K0DDi00000f] PManager instance is created without multitenancy support as JVM flag "oracle.multitenant.enabled" is not set to enable multitenancy support.

                       

                      [2014-09-02T08:31:39.680-04:00] [cw3120-16400] [WARNING] [] [oracle.odc.commitprocessor.CommitProcessor] [tid: [ACTIVE].ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 813ca487ccd4603f:-28e95dfb:1482339e0ef:-8000-0000000000013b74,0] [APP: capture] The following required fields do not have values: [Classification][[

                       

                      oracle.odc.exception.CommitException: The following required fields do not have values: [Classification]

                       

                      at oracle.odc.commitprocessor.CommitProcessor.processBatch(CommitProcessor.java:302)

                       

                      at oracle.odc.batchprocessor.BatchProcessorBean.processMessage(BatchProcessorBean.java:135)

                       

                      at oracle.odc.batchprocessor.CommitProcessorBean.onMessage(CommitProcessorBean.java:59)

                       

                      at sun.reflect.GeneratedMethodAccessor4569.invoke(Unknown Source)

                       

                      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                       

                      at java.lang.reflect.Method.invoke(Method.java:597)

                       

                      at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

                       

                      at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)

                       

                      at oracle.security.jps.ee.ejb.JpsAbsInterceptor$1.run(JpsAbsInterceptor.java:113)

                       

                      at oracle.security.jps.ee.ejb.JpsAbsInterceptor.intercept(JpsAbsInterceptor.java:154)

                       

                      at oracle.security.jps.ee.ejb.JpsInterceptor.intercept(JpsInterceptor.java:113)

                       

                      at sun.reflect.GeneratedMethodAccessor234.invoke(Unknown Source)

                       

                      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                       

                      at java.lang.reflect.Method.invoke(Method.java:597)

                       

                      at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)

                       

                      at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)

                       

                      at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

                       

                      at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)

                       

                      at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

                       

                      at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)

                       

                      at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

                       

                      at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)

                       

                      at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

                       

                      at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

                       

                      at com.sun.proxy.$Proxy240.onMessage(Unknown Source)

                       

                      at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:388)

                       

                      at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659)

                       

                      at weblogic.jms.client.JMSSession.execute(JMSSession.java:4345)

                       

                      at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3822)

                       

                      at weblogic.jms.client.JMSSession.access$000(JMSSession.java:115)

                       

                      at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)

                       

                      at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)

                       

                      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

                       

                      at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

                       

                      ]]

                       

                      [2014-09-02T08:31:39.743-04:00] [cw3120-16400] [NOTIFICATION] [] [oracle.odc.batchprocessor.BatchProcessorBean] [tid: [ACTIVE].ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 813ca487ccd4603f:-28e95dfb:1482339e0ef:-8000-0000000000013b74,0] [APP: capture] [EMAIL_6 (386)] No batch processor specified, batch will be unlocked and placed in a ready state.

                       


                      Please help me to resolve this issue.

                       

                      Thanks in advance.

                      • 8. Re: How to configure Email process for Invoice  in Oracle Capture 11g
                        Ken Peterka-Oracle
                        Ken Peterka-Oracle Sep 2, 2014 5:22 PM (in response to 2640019)

                        Reference this error:  2014-09-02T08:31:39.680-04:00] [cw3120-16400] [WARNING] [] [oracle.odc.commitprocessor.CommitProcessor] [tid: [ACTIVE].ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 813ca487ccd4603f:-28e95dfb:1482339e0ef:-8000-0000000000013b74,0] [APP: capture] The following required fields do not have values: [Classification]

                         

                        The above error indicates that the Commit Processor is attempting to commit a batch and a required field (Classification) is empty. The following are potential solutions:

                         

                        a. Removed the required attribute from the Classification field.

                        b. Ensure the Classification field is populated.

                        c. Create a Document Profile that does not use the Classification field and ensure the document is assigned to the Document Profile.

                        • 9. Re: How to configure Email process for Invoice  in Oracle Capture 11g
                          2640019
                          2640019 Sep 2, 2014 8:25 PM (in response to Ken Peterka-Oracle)

                          Hi,

                           

                          I tried the above mentioned steps for importing emailed invoices into Capture. But it did not work out.

                           

                          Can you please explain the steps elobratly (in detailed manner). so that i will make it correctly.

                           

                          Please let me know the solution to resolve this issue.

                           

                          Thanks inadvance.

                          • 10. Re: How to configure Email process for Invoice  in Oracle Capture 11g
                            Ken Peterka-Oracle
                            Ken Peterka-Oracle Sep 2, 2014 8:40 PM (in response to 2640019)

                            At this point, please re-clarify the problem.  What isn't working?  How are you observing the problem?  Is Import Processor importing the email and moving the processed email to a different folder?

                            • 11. Re: How to configure Email process for Invoice  in Oracle Capture 11g
                              2640019
                              2640019 Sep 3, 2014 10:42 AM (in response to Ken Peterka-Oracle)

                              Hi,

                               

                              We are working with the new 11.1.1.8 version of Capture and trying to configure email processing. We have the import processor job created, and it logs into our exchange server and grabs the attachment. But there are no batches being created from the emails that we can find from our Client Profile, and I cannot find any information in the logs to determine what is going wrong.

                               

                              Please help us resolve this issue

                              • 12. Re: How to configure Email process for Invoice  in Oracle Capture 11g
                                2640019
                                2640019 Sep 4, 2014 11:40 AM (in response to 2640019)

                                Hi,

                                 

                                Can anybody help me on below issue.

                                 

                                We are working with the new 11.1.1.8 version of Capture and trying to configure email processing. We have the import processor job created, and it logs into our exchange server and grabs the attachment. But there are no batches being created from the emails that we can find from our Client Profile, and I cannot find any information in the logs to determine what is going wrong here.

                                 

                                Help would be really appricated.

                                Thanks in advance.

                                • 13. Re: How to configure Email process for Invoice  in Oracle Capture 11g
                                  Ken Peterka-Oracle
                                  Ken Peterka-Oracle Sep 10, 2014 3:59 PM (in response to 2640019)

                                  Firstly, I would ensure that you have applied Consolidated Patch Number 6.  On My Oracle Support, the Patch Number is:  19363640.