-
1. Re: How to configure Email process for Invoice in Oracle Capture 11g
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. 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 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 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 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 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 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 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 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 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 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 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 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.