1. Release Readiness Guide
  2. Feature Summary
  3. Duplicate Order and Item Check

Duplicate Order and Item Check

Attention:

With this update, Order Broker now always checks for a duplicate order and line before creating the order in the database or returning the SubmitOrder response message. This enhanced duplicate checking catches multiple requests if the originating system sends more than one request at the same time. Duplicate order lines are not created; however, a record is created in a new duplicate order item table for tracking purposes.

SubmitOrder error response: The 2040 error response returned when a submitted order and line number is a duplicate of an existing order line now indicates Validation Error - Duplicate order/line is not allowed for system_cd: [SYSTEM]. duplicate_request_id: 123456, line_item_no:3 where SYSTEM is the system code, 123456 is the existing request ID, and 3 is the existing order line number.

Note:

The Routing Engine does not evaluate any other information on the order, such as product code, quantity, or customer name and address, when checking for duplicates. The check takes place only during the SubmitOrder process, and only for duplicate orders submitted by the same system.

The duplicate order check applies regardless of the version specified in the SubmitOrder message.

New tables: The following new tables are used for the duplicate order check:

  • XOM_ITEM_DUPLICATE: Contains a record for each order line that was not created in Order Broker because a duplicate was found. Duplicate records are retained for 180 days for troubleshooting by Oracle Support.

  • XOM_ITEM_DUP_CHECK: Used temporarily only for the duplicate checking process before order creation.

The Daily Cleanup job purges records from these new tables:

  • XOM_ITEM_DUPLICATE: Records older than 180 days are purged.

  • XOM_ITEM_DUP_CHECK: Records older than 2 days are purged.

Removed setting from System screen: The Use Duplicate Order Checking flag at the Orders tab of the System screen is no longer used, and has been removed.

Note:

Duplicate checking does not take place for drop ship purchase orders.