Duplicate Sales Orders (Which Have the Same Value in OE_ORDER_HEADERS_ALL.ORIG_SYS_DOCUMENT_REF) Are Created via PROCES_ORDER API
Last updated on JULY 07, 2017
Applies to:Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
The duplicate sales orders (which have the same value in OE_ORDER_HEADERS_ALL.ORIG_SYS_DOCUMENT_REF) are created via Process Order API(OE_ORDER_PUB). The duplicate records can be confirmed by the below query:
Prevent from creating duplicate sales orders via API.
Steps to Reproduce
Run the Process Order API(OE_ORDER_PUB) with the same ORIG_SYS_DOCUMENT_REF value as API parameter.
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