Tools and information for freelances
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;
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: Advanced Supply Chain Planner: Supply Chain Plan > Options (select your plan) Plan considering…
Read More “How to define constraint-based plans in Oracle EBusiness Suite?” »
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: Perform project transfers if exception message is related to on hand quantities Update purchase and work orders if exception…
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. Projects/tasks related exceptions Items with a shortage in a…
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: Oracle Inventory > Organization items form > Item attributes > Lead-time tabbed region Please note: In Oracle eBusiness Suite, these attributes are controlled at the Organization level only! Preprocessing Processing Postprocessing: This attribute…
Read More “How to define lead times in Oracle EBusiness Suite?” »
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 Organizer > New Order Order Header Enter Customer Name, Ship-to and bill-to locations, order…