Find Back To Back Sales Order Has Two External Requisition Requests

(Doc ID 1546369.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.0.4 version, Transaction Fulfillment

ACTUAL BEHAVIOR
---------------
We are using back to back order function but there are a few sales orders have two external requisitions requests.
Looks like the first request produced the requisition/PO and then the second request override the first request which also produces requisition/PO.
The later is what is final linked to SO at reservation/supply, but at requisition we are seeing two requisitions linked to the same SO.
Since it is production we need to proceed we canceled the first requisition that is no longer at sales order reservation details

EXPECTED BEHAVIOR
-----------------------
Expect back-to-back order to be associated with single requisition/PO

STEPS
-----------------------
1. Run the following query to find the duplicate requisition:

SELECT ol.header_id
FROM oe_order_lines_all ol,
 po_requisition_headers_all rh
WHERE ol.line_id = rh.interface_source_line_id
AND rh.interface_source_code = 'CTO'
GROUP BY ol.header_id
HAVING COUNT(*)>1;

The issue happens intermittently.
The business did about 30 orders and two of them had issue. The process is same for all.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, this is production issue, since B2B order line produces 2 identical purchase orders to supplier, it double the supply which we do not need

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