Search 800 + Posts

Jun 10, 2010

Internal Requisition and Internal Sales Order changes in R12.

In this post I will explain in short about the Change Management that Oracle has introduced for IR and ISO in R12.

  1. IR   - Internal Requisition
  2. ISO -  Internal Sales Order
Oracle in R12 introduced the features where if you made changes in approved IR and it got reflected in ISO and also if you made changes in ISO it got reflected in IR.
But it doesn't mean that we can change any /everything in IR/ISO. Change Management is not available for all the fields.
As of Now Oracle support change to following attribute at OM side
1 Order Quantity
2 Request Date
3 Schedule date
4 Arrival date

It means if you change any of these values in Internal Sales Order (ISO), requester of IR will get a Notification and also quantity and Need by Date in IR will changes.

Similarly if we make changes in following fields in Approved IR
1 Quantity
2 Need by Date
These changes will got reflected in ISO

Apart from this if we cancel the Internal Order line or Internal requisition line, the corresponding line in IR or ISO will also got cancelled.
Also If we cancel ISO , then it will cancel the corresponding IR.

Please Note that for these changes to work in OM we have to disable some of the processing constraints

Like for Internal Sales Order these are 

  • Update Ordered Quantity
  • Update Requested date

Query for these 2 in Processing Constraint UI and then
  1. For Request Date Disable the Processing Constraint (Constraint and not Condition )
  2. For Update Ordered Quantity  Query it and then disable the Condition where Validate Template is "Internal Order"

This is really a very good feature offered by Oracle.