"Could not retrieve VOUCHER_INVOICE_LINEITEM_JOIN(s)" Error When Trying To Approve Invoices (Doc ID 1532824.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Freight Payment, Billing, and Claims - Version 6.2.0 to 6.3.2 [Release 6.2 to 6.3]
Information in this document applies to any platform.

Symptoms

When approving two invoices related to one Shipment, where the Service Provider has 'Copy Invoice Delta to Shipment' set, the following error occurs.

ERROR
-----------------------
ejb.VoucherInvoiceLineitemJoin records not found: sql=select j.invoice_gid, j.lineitem_seq_no, j.voucher_gid from voucher_invoice_lineitem_join j, voucher v where v.invoice_gid = ? and v.voucher_gid = j.voucher_gid, sqlValues=[LEE.20130129-0002]
  Could not retrieve VOUCHER_INVOICE_LINEITEM_JOIN(s)

at glog.util.remote.BeanManagedEntityBean.executeFindAll(BeanManagedEntityBean.java:1048)
at glog.util.remote.BeanManagedEntityBean$12.execute(BeanManagedEntityBean.java:495)
at glog.util.remote.BeanManagedEntityBean.dbModify(BeanManagedEntityBean.java:1068)
at glog.util.remote.BeanManagedEntityBean.doFindMultipleSQL(BeanManagedEntityBean.java:499)
at glog.util.remote.BaseEntityBean$11.doIt(BaseEntityBean.java:765)
at glog.util.remote.BaseEntityBean.ejb(BaseEntityBean.java:799)
at glog.util.remote.BaseEntityBean.ejbFindSQL(BaseEntityBean.java:763)
at glog.ejb.invoice.VoucherInvoiceLineitemJoinServerSideEJBWrapper_8yfzim_Impl.ejbFindSQL(VoucherInvoiceLineitemJoinServerSideEJBWrapper_8yfzim_Impl.java:520)
at glog.util.remote.BaseEntityBean.ejbFindSQL(BaseEntityBean.java:787)
at glog.ejb.invoice.VoucherInvoiceLineitemJoinServerSideEJBWrapper_8yfzim_Impl.ejbFindSQL(VoucherInvoiceLineitemJoinServerSideEJBWrapper_8yfzim_Impl.java:535)
at glog.ejb.invoice.VoucherInvoiceLineitemJoinBean.ejbFindByInvoicePKOnVoucher(VoucherInvoiceLineitemJoinBean.java:34)
at glog.ejb.invoice.VoucherInvoiceLineitemJoinServerSideEJBWrapper_8yfzim_Impl.ejbFindByInvoicePKOnVoucher(VoucherInvoiceLineitemJoinServerSideEJBWrapper_8yfzim_Impl.java:265)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at weblogic.ejb.container.manager.BeanManagedPersistenceManager.enumFinder(BeanManagedPersistenceManager.java:120)
at weblogic.ejb.container.manager.BaseEntityManager.enumFinder(BaseEntityManager.java:2541)
at weblogic.ejb.container.internal.EntityEJBHome.finder(EntityEJBHome.java:1103)
at glog.ejb.invoice.VoucherInvoiceLineitemJoinServerSideEJBWrapper_8yfzim_HomeImpl.findByInvoicePKOnVoucher(VoucherInvoiceLineitemJoinServerSideEJBWrapper_8yfzim_HomeImpl.java:155)
at glog.business.invoice.InvoiceUpdateSessionBean.adjustShipmentDelta(InvoiceUpdateSessionBean.java:1072)
at glog.business.invoice.InvoiceUpdateSessionBean.makeVoucher(InvoiceUpdateSessionBean.java:3788)
at glog.business.invoice.InvoiceUpdateSessionServerSideEJBWrapper.makeVoucher(InvoiceUpdateSessionServerSideEJBWrapper.java:1380)
at glog.business.invoice.InvoiceUpdateSessionBean.approveLinePayment(InvoiceUpdateSessionBean.java:474)
at glog.business.invoice.InvoiceUpdateSessionServerSideEJBWrapper.approveLinePayment(InvoiceUpdateSessionServerSideEJBWrapper.java:396)
at glog.business.invoice.InvoiceUpdateSessionHome_d7thm7_EOImpl.approveLinePayment(InvoiceUpdateSessionHome_d7thm7_EOImpl.java:2996)
at glog.business.action.invoice.ApproveInvoiceByLineActionExecutor.approveLinePayment(ApproveInvoiceByLineActionExecutor.java:1272)
at glog.business.invoice.InvoiceServerActionSessionBean.approveLinePayment(InvoiceServerActionSessionBean.java:391)
at glog.business.invoice.InvoiceServerActionSessionServerSideEJBWrapper.approveLinePayment(InvoiceServerActionSessionServerSideEJBWrapper.java:361)
at glog.business.invoice.InvoiceServerActionSessionServerSideEJBWrapper_ncc51r_EOImpl.approveLinePayment(InvoiceServerActionSessionServerSideEJBWrapper_ncc51r_EOImpl.java:2345)
at glog.business.invoice.gen.InvoiceServerActionSessionSkel.approveLinePayment(InvoiceServerActionSessionSkel.java:476)
at glog.business.invoice.gen.InvoiceServerActionSessionSkel.exec(InvoiceServerActionSessionSkel.java:95)
at glog.webserver.wrapper.SkelImpl.execDispatch(SkelImpl.java:16)
at glog.server.wrapper.WrapperSessionBean.execDispatch(WrapperSessionBean.java:62)
at glog.server.wrapper.WrapperSessionServerSideEJBWrapper.execDispatch(WrapperSessionServerSideEJBWrapper.java:48)
at glog.server.wrapper.WrapperSessionHome_a06097_EOImpl.execDispatch(WrapperSessionHome_a06097_EOImpl.java:58)
at glog.server.wrapper.WrapperSessionHome_a06097_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:590)
at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:230)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:478)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:473)
at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:119)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Have a Service Provider set with 'Copy Invoice Delta to Shipment' .
2. Have one Shipment with two related Invoices.
3. Attempt to approve the Invoices.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms