Introduce CREATE UPDATE Action Code for Order Interface

In the Order Interface, “CREATE” action code creates new order details and “UPDATE” action code modifies existing order details. Using “CREATE” for an existing order can replace existing order details with the new order details in Oracle WMS. Using “UPDATE” without all existing order details can overwrite the missing data and cause incomplete orders or data mismatches.

To improve interfacing efficiency and reduce integration complexity, we are now introducing a new action code “CREATEUPDATE” to the Order Interface. You can use this action code to create a new order or order detail if it does not exist or update it if it exists in Oracle WMS.

This prevents unintended deletion or modification of existing order details and provides a single action for creating or updating order details. You can use this action code in prebuilt or custom integrations for order interface when it is not clear whether to issue CREATE or UPDATE.

CREATE UPDATE ACTION CODE BEHAVIOR

You can use the “CREATEUPDATE” action code at both the Order Header and Order Detail level.

• If the referenced order or order line does not already exist, the system creates it.
• If the referenced order or order line exists, the system updates it based on the interfaced data.

For more details on action code behavior, refer Order interface in the WMS Interface Specification Formats file in the Oracle WMS Cloud Information Center (Documentation tab > click the link under Current Documentation > refer to the WMS Interface Specification Formats document).

ENHANCED ERROR MESSAGES

To enhance clarity, we have updated error messages in the stage tables for the following scenarios (Order Interface):

Scenario	Updated Error Message
Interfacing a non-existing order with “UPDATE” action code at Order Header	ORDER %order_number% does not exist cannot update
Interfacing a non-existing order detail with “UPDATE” action code at Order Detail	ORDER %order_number% does not have corresponding sequence number %seq_number%

Steps to enable and configure

You don't need to do anything to enable this feature.