Overview
Within Oracle ERP Cloud, transformation rules can be used to automatically add a promotional item to an order whenever a certain quantity of any item is added.
The quantity on the new line can be set as a fixed value which is derived from the original ordered quantity, Example: for every x items ordered then y promotional goods will be added to the order. Here are the steps that can be used during an Oracle ERP Cloud implementation
Configuration Steps
1. Navigate to Setup and Maintenance in Oracle Fusion Cloud. Search for “Manage Product Transformation Rules”
2. Click on Create New Rule. See the screen below.
a. If Statement is
OrderTransformationRules.FulfillLineVO.InventoryItemId – is – “XYZ”
where “XYZ” is the inventory item Id for the item that will trigger the promotion.
OrderTransformationRules.FulfillLineVO.OrderedQty – is – XXX, where XXX is the quantity of the item that will trigger the promotion.
b. Then Statement is
assert new – OrderTransformationRules.AddNewOrderLine – ( newItemId:ABC, viewRowImpl:OrderTransformationRules.FulfillLineVO.ViewRowImpl ),
where ABC is the inventory item id for the item that will be added to the order.
3. Navigate to Setup and Maintenance. Search for “Manage Posttransformation Defaulting Rules”
4. Click on New Condition to add a new rule wherein
Oracle ERP Cloud – Auto add promotional item to Order-Tangenz Corporation
a. If Statement is:
Header – is a – PostTransformationRules.HeaderVO
and
Fline – is a – PostTransformationRules.FulfillLineVO
FLine.InventoryItemId – is – ABC
where ABC is the inventory item id for the item that will be added to the order.
FLine.ProductType – isn’t – “GOODS”
b. Then Statement is
assert new – PostTransformationRules.ModifyEntity – ( attrName:”OrderedQty”, attrValue:ZZZ, viewRowImpl:FLine.ViewRowImpl ) , where ZZZ is the quantity of the new item that is being offered on the promotion.
5. User can try to create a sales order and verify that the Promotional item is getting added as per the condition.
If you need any help with your Oracle ERP Cloud Implementations, Please drop a line here. Our Oracle ERP Cloud experts will contact you promptly.
