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.
Now Order management Provide a new UI in R12.1.1 to define the rule to restrict the Item order, this UI is name as Item Orderability Rules.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.
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.
- 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
- Item = AS54888
Try to save Order , System will Throw Error , because of the Item Order ability Rule as shown below.