My Oracle Support Banner

Find Back To Back Sales Order Has Two External Requisition Requests (Doc ID 1546369.1)

Last updated on JULY 05, 2022

Applies to:

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


On : 12.0.4 version, Transaction Fulfillment

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

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

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

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

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.