Item Orderability – This is new feature introduced in Oracle R12.1.1.This is rule that user can define to restrict the items that can be ordered from the Sales Order form.
Because of the complex business scenario in the Modern time organization want to control which customer are allowed to order which product.
It allow user to Order the Item to customer based on the Rules.
As of Now Oracle has provided rules to control only the 11 attributes – like you can ally the restriction based on
Customer category etc.
Below is Simple Flow
1. Define the Rules
2. Order the Item through UI/Order Import/Process Order API.
Below is Simple test case for Item Orderability feature.
Define the Item Orderability –
Define the Rules by selecting any of 11 attributes
Define the Criteria – Item or Category.
Define the Rule.
For Example – I want to define the Rule that Item AS54888 should not be Ordered for an Order with Item Type = Mixed.
For that I selected the
Criteria = Item
Rule level = Order Type
Rule Value = Mixed.
Please make sure that Enabled Flag = Yes for your Rule.
Once Rule is defined ,Entered Sales Order .
Customer ID = 1006
Order Type = Mixed
Try to save Order, System will Throw Error , because of the Item Order ability Rule as shown below.