Saturday, February 28, 2009

Internal Requisition to Internal Order

Hope the above helps to understand the process of Internal Requisition to Internal Order cycle in Oracle Applications


Sunday, February 15, 2009

Basics of Oracle Projects

Please let us know if you would like to contribute in preparing similar slides on certain key areas in Oracle Projects. To view the presentation, please visit


Saturday, February 14, 2009

ERP - An Introduction

ERP - An Introduction


Wednesday, February 11, 2009

Thursday, February 5, 2009

Defining Line Types

Oracle Purchasing provides initial line types of Goods and Services. If Oracle Work in Process is installed, Oracle Purchasing also provides the line type Outside Processing. If Oracle Services Procurement is installed, Oracle Purchasing also provides Rate Based Temp Labor and Fixed Price Temp Labor line types. You can modify these line types or create new line types in the Line Types window.
The Prerequisites for defining line types are to a) Define categories.and b) Define units of measure.

To define a new line type, you go to line type window and provide a name and description for lines types with a value basis of quantity, fixed price, rate, or amount. You can then optionally specify a default category, whether receipt is required, and unit of measure. The unit price defaults to 1 for amount–based line types but is otherwise optional. You cannot specify a line as outside processing unless the value basis is quantity. You must provide a default unit of measure for rate–based and amount–based line types. You use the unit of measure for amount–based lines as reference information only. Purchasing does not perform any unit conversion for amount based lines. You can create a unit of measure such as AMOUNT for amount based line types to help you determine if ordered by amount.


Min-Max Planning

Min-Max Planning determines the size and timing of item replenishment orders and creates a purchase order/move order to replenish items stock. This purchase order/move order to restock items is created based upon the Min-Max Planning report. The planning report provides the item and quantity to be ordered or manufactured. Items are required to be restocked when the quantity of an item in stock is fewer than the quantity required by the inventory organization. It maintains inventory stock levels for all of your items or selected items. With min-max planning, you specify minimum and maximum inventory levels for your items and minimum and maximum order quantity. You can also specify fixed lot multiplier. When the inventory level for an item (on-hand quantities plus quantities on order) goes down below the minimum quantity prescribed by you, Oracle Inventory module suggests a new purchase requisition, internal requisition, move order, or a manufacturing job to bring the balance back up to the maximum quantity mentioned by you. Inventory module performs min-max planning for your items at either the organization level or the subinventory level. You can choose this level when you run min- max planning report.

When you min-max plan at the organization level, you can optionally include the following transactions as demand quantity in the min-max planning calculation
a) unreserved sales orders
b) reserved sales orders
c) account issue move orders
d) work in process component requirements

This creates Purchase requisitions or internal requisitions for buy items and WIP unreleased jobs for make items for the suggested replenishment quantities. You can then turn these requisitions into purchase orders or internal orders and the unreleased jobs into released jobs for the required items. If a revision is specified when a purchase order requisition is created for revision controlled items, it is controlled by setting of the profile option INV: Purchasing by Revision

When you min-max plan at the subinventory level, you can optionally include only unreserved sales orders, reserved sales orders, account issue move orders, and subinventory transfer move orders as demand quantity in the min-max planning calculation. Subinventory level planning cannot generate jobs for WIP and does not consider WIP jobs as supply or WIP components as demand. Purchase requisitions, internal requisitions, or pre-approved move orders for the suggested replenishment quantities can be optionally created. You can then turn requisitions into purchase orders or internal orders for the required items. Sourcing Rule does not work with Min-Max Planning.

Please enter your email address to subscribe

You won't repent doing this!