Cannot Add More Than One Standard Invoice To A Parent Invoice At The Same Time. The Following Error Is Displayed: "Unable to create InvoiceInvolvedParty for InvoiceInvolvedPartyData" (Doc ID 1414754.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Freight Payment, Billing, and Claims - Version: 5.5.05.08 to 6.2.5 - Release: 5.5 to 6.2
Information in this document applies to any platform.

Symptoms

On OTM versions 5.5, 6.1 and 6.2.4

When several Invoices have been selected and you carry out the Action to Add them to a Parent Invoice, if two or more of the Invoices have the same Involved Party the following error is seen:

Error:
------

ErrorErrorStack TraceStack Trace Unable to create InvoiceInvolvedParty for InvoiceInvolvedPartyData: invoiceGid: LEE.20120210-0001 involvedPartyQualGid: BILL-TO involvedPartyContactGid: LEE.LEE comMethodGid: BY CONTACT domainName: LEE

The INVOICE_INVOLVED_PARTY BY CONTACT LEE.20120210-0001 LEE.LEE BILL-TO cannot be created because a duplicate already exists

Cannot add the INVOICE_INVOLVED_PARTY record. [INVOICE_GID, INVOLVED_PARTY_QUAL_GID, INVOLVED_PARTY_CONTACT_GID, COM_METHOD_GID] must be unique.

java.sql.SQLException: ORA-00001: unique constraint (GLOGOWNER.PK_INVOICE_INVOLVED_PARTY) violated






View Log

glog.util.remote.CreateDuplicateRecord
Cannot add the INVOICE_INVOLVED_PARTY record. [INVOICE_GID, INVOLVED_PARTY_QUAL_GID, INVOLVED_PARTY_CONTACT_GID, COM_METHOD_GID] must be unique.
java.sql.SQLException: ORA-00001: unique constraint (GLOGOWNER.PK_INVOICE_INVOLVED_PARTY) violated


java.sql.SQLException: ORA-00001: unique constraint (GLOGOWNER.PK_INVOICE_INVOLVED_PARTY) violated

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1262)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3345)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3429)
at oracle.oc4j.sql.proxy.PreparedStatementBCELProxy.executeUpdate(PreparedStatementBCELProxy.java:37)
at glog.util.jdbc.noserver.SqlPreparedStatement.executeUpdate(SqlPreparedStatement.java:29)
at glog.util.jdbc.SqlUpdate.executeUpdate(SqlUpdate.java:135)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:113)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:62)
at glog.util.remote.BeanManagedEntityBean.executeUpdate(BeanManagedEntityBean.java:793)
at glog.util.remote.BeanManagedEntityBean$1.execute(BeanManagedEntityBean.java:195)
at glog.util.remote.BeanManagedEntityBean.dbModify(BeanManagedEntityBean.java:1066)
at glog.util.remote.BeanManagedEntityBean.doCreate(BeanManagedEntityBean.java:191)
at glog.util.remote.BaseEntityBean$1.doIt(BaseEntityBean.java:455)
at glog.util.remote.BaseEntityBean.ejb(BaseEntityBean.java:798)
at glog.util.remote.BaseEntityBean.ejbCreator(BaseEntityBean.java:453)
at glog.ejb.invoice.db.InvoiceInvolvedPartyBeanDB.ejbCreate(InvoiceInvolvedPartyBeanDB.java:55)
at InvoiceInvolvedPartyHome_EntityHomeWrapper2332.create(InvoiceInvolvedPartyHome_EntityHomeWrapper2332.java:864)
at glog.business.invoice.InvoiceUpdateSessionBean.makeInvoiceInvolvedParties(InvoiceUpdateSessionBean.java:1941)
at glog.business.invoice.InvoiceUpdateSessionBean.addInvoicesToConsolidation(InvoiceUpdateSessionBean.java:1823)
at glog.business.invoice.InvoiceUpdateSessionServerSideEJBWrapper.addInvoicesToConsolidation(InvoiceUpdateSessionServerSideEJBWrapper.java:1212)
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:324)
at com.evermind.server.ejb.interceptor.joinpoint.EJBJoinPointImpl.invoke(EJBJoinPointImpl.java:35)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.TxRequiredInterceptor.invoke(TxRequiredInterceptor.java:50)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.SecurityRoleInterceptor.invoke(SecurityRoleInterceptor.java:47)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.InvocationContextPool.invoke(InvocationContextPool.java:55)
at com.evermind.server.ejb.StatelessSessionEJBObject.OC4J_invokeMethod(StatelessSessionEJBObject.java:87)
at InvoiceUpdateSessionHome_RemoteProxy_6kkjd7f.addInvoicesToConsolidation(Unknown Source)
at glog.business.action.invoice.InvoiceActionExecutor.addInvoicesToConsolidation(InvoiceActionExecutor.java:1273)
at glog.business.invoice.InvoiceServerActionSessionBean.addInvoicesToConsolidation(InvoiceServerActionSessionBean.java:811)
at glog.business.invoice.InvoiceServerActionSessionServerSideEJBWrapper.addInvoicesToConsolidation(InvoiceServerActionSessionServerSideEJBWrapper.java:1026)
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:324)
at com.evermind.server.ejb.interceptor.joinpoint.EJBJoinPointImpl.invoke(EJBJoinPointImpl.java:35)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.TxNotSupportedInterceptor.invoke(TxNotSupportedInterceptor.java:43)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.SecurityRoleInterceptor.invoke(SecurityRoleInterceptor.java:47)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.InvocationContextPool.invoke(InvocationContextPool.java:55)
at com.evermind.server.ejb.StatelessSessionEJBObject.OC4J_invokeMethod(StatelessSessionEJBObject.java:87)
at InvoiceServerActionSessionHome_RemoteProxy_6kkjd7f.addInvoicesToConsolidation(Unknown Source)
at glog.business.invoice.gen.InvoiceServerActionSessionSkel.addInvoicesToConsolidation(InvoiceServerActionSessionSkel.java:986)
at glog.business.invoice.gen.InvoiceServerActionSessionSkel.exec(InvoiceServerActionSessionSkel.java:186)
at glog.webserver.wrapper.SkelImpl.execDispatch(SkelImpl.java:15)
at glog.server.wrapper.WrapperSessionBean.execDispatch(WrapperSessionBean.java:57)
at glog.server.wrapper.WrapperSessionServerSideEJBWrapper.execDispatch(WrapperSessionServerSideEJBWrapper.java:42)
at sun.reflect.GeneratedMethodAccessor1205.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.evermind.server.ejb.interceptor.joinpoint.EJBJoinPointImpl.invoke(EJBJoinPointImpl.java:35)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.TxNotSupportedInterceptor.invoke(TxNotSupportedInterceptor.java:43)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.SecurityRoleInterceptor.invoke(SecurityRoleInterceptor.java:47)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.InvocationContextPool.invoke(InvocationContextPool.java:55)
at com.evermind.server.ejb.StatelessSessionEJBObject.OC4J_invokeMethod(StatelessSessionEJBObject.java:87)
at WrapperSessionHome_RemoteProxy_6c6hndi.execDispatch(Unknown Source)
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:324)
at com.evermind.server.rmi.RmiMethodCall.run(RmiMethodCall.java:53)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:534)


Replication Steps:
---------------------

1 - Navigate to: Financials > Payment Invoice Management > Payment Invoice.

2 - Create three Invoices as follows:

ID: 20120210-0001 (PARENT)
Financial Consolidation Type: Parent.
ServProv Alias Qualifier: GLOG
Service Provider Alias: LJS_TL_CARRIER_1
Service Provider ID: LJS_TL_CARRIER_1
Amount Due: 100
Involved Party:
Involved Party Contact: LEE
Communication Method: BY CONTACT
Involved Party Qualifier: BILL-TO


ID: 20120210-0002 (CHILD_1)
Financial Consolidation Type: STANDARD
ServProv Alias Qualifier: GLOG
Service Provider Alias: LJS_TL_CARRIER_1
Service Provider ID: LJS_TL_CARRIER_1
Amount Due: 100
Involved Party:
Involved Party Contact: LEE
Communication Method: BY CONTACT
Involved Party Qualifier: BILL-TO


ID: 20120210-0003 (CHILD_2)
Financial Consolidation Type: STANDARD
ServProv Alias Qualifier: GLOG
Service Provider Alias: LJS_TL_CARRIER_1
Amount Due: 100
Service Provider ID: LJS_TL_CARRIER_1

3 - Navigate to: Financials > Payment Invoice Management > Payment Invoice.

4 - Search for the Invoice/Bill Numbers

5 - Select the two Standard Invoices returned (20120210-0002 and 20120210-0003)

6 - Click Actions > Add Child Invoice To Consolidated Invoice (for 6.2 go to Invoice in the Action menu)

7 - In the next screen enter the 'Consolidated Invoice' ID of: 20120210-0001 (which is the parent).

8 - Click OK.

9 - The error is shown:

NOTE: Adding the Standard Invoices one by one will successfully add the Standard Invoices to the Parent Invoice.

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