Find Back To Back Sales Order Has Two External Requisition Requests
(Doc ID 1546369.1)
Last updated on JUNE 20, 2018
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:
FROM oe_order_lines_all ol,
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|