Overview of Transformation Rules

Write a business rule that populates order attributes before Order Management transforms a source order, while it transforms a source order, and after it transforms a source order.

A source system is a system in your implementation that captures the details of a sales order. The source orders that your source system captures probably use attributes, structures, and data that are different from what Order Management uses. If you use more than one source system, then the details across source systems might be different.

Order Management uses a specific structure in sales orders so it can fulfill each of them consistently and effectively. Transformation rules transform each source order into a structure that Order Management can use, such as the arrangement of attributes on the order header, order lines, and fulfillment lines, and the relationships between header, order lines, and fulfillment lines.

Transformation rules transform each source order into a structure that Order Management can use

When Do Rules Run?

Order Management runs transformation rules differently depending on where you manage your sales orders.

Manage Sales Orders in the Order Management Work Area

What You Do

What Rules Run

Create a sales order or copy a sales order.

Pretransformation rules run each time that you:

  • Modify an attribute that contains customer details.

  • Modify the order type.

  • Add an order line.

Copy a sales order and don't:

  • Modify an attribute that contains customer details.

  • Modify the order type.

  • Add an order line.

Pretransformation rules don't run.

Create a sales order and click Submit.

Transformation rules and posttransformation rules run one time after you click Submit.

Copy a sales order or create a return, then click Submit.

Transformation rules and posttransformation rules don't run on return lines after you click Submit.

Revise a sales order.

Transformation rules don't run.

Create a return and:

  • Modify attributes that contain customer details.

  • Modify the order type.

  • Add an order line.

Pretransformation rules run.

Order Management doesn't run transformation rules or posttransformation rules with returns. If you need to do transformation or posttransformation on a return line, then create an order management extension instead. For details, see Overview of Creating Order Management Extensions.

Import a Source Order

If you import a source order, then Order Management:

  • Runs transformation and posttransformation rules when it validates the draft sales order during import. It runs transformation rules and posttransformation rules only on order lines and not on return lines.

  • Doesn't run transformation rules on orders that you import through the Sales Orders for Order Hub REST API.

    For details and examples, go to REST API for Oracle Supply Chain Management Cloud, expand Order Management, then click Sales Orders for Order Hub.

If you import a source order through a SOAP web service, then Order Management runs rules in a sequence. You can't modify this sequence:

  1. Pretransformation rules.

  2. Transformation rules.

  3. Posttransformation rules.