OTM Transmission To Oracle AP Is Failing with the following error: ORA-00001: unique constraint (AP.AP_INVOICES_INTERFACE_U1) violated (Doc ID 1464108.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version 6.1.0 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Dec-2013***

Symptoms

When attempting to send invoice data from OTM, the BPEL process is not able to update Oracle AP and is not receiving transmission back and the following issue occurs:

-- Error
ORA-00001: unique constraint (AP.AP_INVOICES_INTERFACE_U1) violated

-- Expected Behavior
That the AP Invoice transmission would be processed correctly when sending the transmissions back to OTM.

-- Steps
1. Voucher invoice is sent using External System from OTM.
2. Middleware which is BPEL works as communicator and transmits invoice information to Oracle AP.
3. Oracle invoice AP interface table is populated with OTM invoice data
4. BPEL should then receive acknowledgement that the transmission is successful.
5. OTM transmission status is updated accordingly.

However during step number 4 the transmission errors out and th AP_INVOICE table is not upldated correctly.

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