Duplicate Sales Orders (Which Have the Same Value in OE_ORDER_HEADERS_ALL.ORIG_SYS_DOCUMENT_REF) Are Created via PROCES_ORDER API (Doc ID 2076064.1)

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.

Symptoms

Actual Behavior
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:

 

Expected Behavior

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.

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