Hello

In standard Oracle RLM, changing the customer item cross-reference from X to Y will not make the existing open sales order lines for X turn into Y through the interface tables alone. The Demand Processor loads schedules into the RLM interface tables and reconciles them against existing demand, but its matching logic uses mandatory attributes including Customer Item and Inventory Item. When those key attributes do not match, the new demand line is treated as a new requirement record, not an update to the old line.

Oracle also states that whether an incoming change/replacement can update an existing sales order line depends on the line’s workflow status, the schedule type, and Order Management processing constraints. If the change cannot be applied, Oracle raises warning exceptions and manual intervention is needed.

So the practical answer is:

• Use the inbound 862 so that the customer item A resolves to the new internal item Y by activating the new cross-reference and deactivating X. Oracle Inventory supports updating and deactivating customer item cross references, and Release Management uses preference ranking/cross references for the item mapping.

If the trading partner’s inbound purpose code means a replacement, map that external code to internal Replacement through the RLM code conversion for RLM_TRX_PURP; Oracle explicitly documents this use case.

• Even then, RLM interface loading alone will not reliably change open OM lines from X to Y if the item itself changes, because inventory item is part of the matching logic and a mismatch becomes a new record.

If the business truly needs “take open line X and change it to Y,” the supported path is to update the existing Oracle Order Management line, not to rely on the RLM interface tables to do the item swap. Oracle Order Import supports changes to existing orders/lines through the open interface using OPERATION_CODE = UPDATE, and the line can then be changed subject to processing constraints.

So the answer is: you generally cannot achieve this by only populating the RLM interface tables. Standard RLM will usually create a new Y line. To get the old X line replaced by Y, you need a custom OM update/reconciliation step keyed to the existing open order line, or a controlled change process that updates the OM line directly after the schedule is received.

Thank you,
Bobbi