Purchasing Approval Sending Duplicate Objects To Oracle Transportation Management - Duplicate Transmissions

(Doc ID 1523669.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.


Using Purchasing, when entering a transportation arranged purchase order - upon approving the purchase order - it is passing duplicate data into the OTM queue.

Replication Steps:

1. Login to the E-Business Suite and choose the Purchasing Module.
2. Create and approve a purchase order which has transportation arranged.
3. Find it has inserted two records into the interface


As the purchase order was approved, the following sql was then run to confirm that two records were inserted - when one was expected.

Prior to approval engage this sql statement:

select count(*) from po.po_otm_out

Submit the document for approval - and again engage the statement:

select count(*) from po.po_otm_out


It was found the count incremented by 2 - when it was expected to increment by 1.


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