Use this request to extract sourcing rules from R11i or R12 instances.
Here are the tables used in this query:
MRP_SR_SOURCE_ORG;
MRP_SOURCING_RULES;
MRP_SR_RECEIPT_ORG;
AP_VENDORS_V;
po_vendor_sites_all;
more
more
#1
: Can we track the Purchasing history by delivery lead times?
#2
Antonin: No not directly. You can track deliveries through purchasing module and see the difference in days betwen effective and expected receipt date.
Running simulation plans can help you understand how the supply chain may react when modifying the constraints.
Scenario:
Material constraint: Supplier can provide up to 70 units of a component item for each period. There is no ... more
When running unconstrained plan, The MRP generates a supply plan based on the supposed infinite availability of materials and resources.
When running a constrained plan, material and resources availability is limited, you can choose to enforce capacity constraints or to ... more
The following post will show you how to define constraints parameters for your plans. Simulations based on constrained plans can help you to understand better the stakes of your supply chain.
Plan constraints for materials and resources can be defined here:
&l... more
This post covers the "Order to Shipment" process in Oracle eBusiness suite using the Order Management module. We will show you how to create and book a sales order, how to release it and ship all materials to the customer.
Navigation: Order Org... more
This exception is displayed by the planning workbench.
It simply means that supply for one project has been allocated to the demand of a different project.
To resolve this issue, check the demand. If the demand is correct, you should:
- more
The planning engine issues exception messages to draw your attention to situations that may need you to perform an action. (e.g. check past due sales orders, release work orders or planned orders, etc.)
The most frequently used exceptions are listed below and sorted by exception types.
more
Planning is a key element in supply chain management. The manufacturing plan consists in creating work and material requirements based on product demand.
Building an accurate plan is vital to satisfy customers' requirements and reach equilibrium between supply and demand. Accurate plan ... more
Lead times is core element in supply chain management and optimization. Visit this page to understand better the lead-time concept.
To set up lead times, please naviguate as follow:
&... more
Lead Time is the time between the initiation of a process and its completion. In Supply Chain Management there are 2 types of lead times:
Manufacturing Lead Time
Information Lead Time
We will focus in this post on the manufactur... more
Last posts:
- Constraint-Based Planning concept
- Concept of lead time in supply chain
- Defining lead times in Oracle eBusiness Suite
- MRP most frequently used exceptions and recommendations from planning engine (ASCP)


