Oracle MRP integration with Purchasing
The three primary factors that determine how a requisition gets
released from the planners workbench are:
1. The item-sourcing type attribute located in the inventory
organization parameters form.
2. The source type attribute located in the general planning
section of the organization items form.
3. Are sourcing rules being used for the item and have they been
correctly setup?
If sourcing rules are NOT being used on the item, then the
requisition will get released by MRP using the following logic:
1. If ANY ONE of the two supplier type parameters at the organization parameters
or organization items level is set to Inventory,
then the requisition will released to the
PO_REQUISITIONS_INTERFACE_ALL table with a source_type_code of INVENTORY.
2. If BOTH of the supplier type parameters at the organization parameters and
organization items level is set to Inventory, then the requisition will get released to the PO_REQUISITIONS_INTERFACE_ALL table with a source_type_code
of INVENTORY. Oracle MRP will use the organization and subinventory
settings defined at the organization items level.
3. If NONE of the supplier type parameters at the organization parameters or
organization items level is set to INVENTORY then the requisition will get
released to the
PO_REQUISITIONS_INTERFACE_ALL table with a source_type_code
of NULL.
