Thursday, February 5, 2009

[Oracle Applications] 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.

--
Posted By OracleOnDemand to Oracle Applications at 2/05/2009 10:43:00 PM

Wednesday, January 28, 2009

[Oracle Applications] Requisitions Setup Checklist for iProcurement

Requisitions Setup Checklist for iProcurement

1) Foreign Currency Support
2) Information Templates
3) Suggested Buyer
4) One-Time Address
5) Purchase Order Grouping for Requisition Lines with One-Time Addresses
6) Hazard Information
7) Global Requester
8) Express Setup Tool
9) Charge Account Displays Billing Optional Charge Account Displays
10) Expense Charge Account Rules
11) Employee PCards
12) Supplier P-Cards
13) PO Extract for P-Card Reconciliation
14) Project Accounting
15) Grants Accounting
16) Estimated Tax Functionality
17) Favorite Charge Accounts
18) Approvals
19) Global Approver
20) Requisition Changes
21) Requester- Initiated Changes to Purchase Orders
22) Requisition Cancellations
23) Lifecycle Tracking
24) Internal Requisitions
25) Oracle Services Procurement

-

--
Posted By OracleOnDemand to Oracle Applications at 1/29/2009 12:06:00 PM

Tuesday, January 27, 2009

[Oracle Applications] Different line types in Oracle Purchasing

Different line types in Oracle Purchasing are as follows:

a) Quantity–Based Purchasing
Quantity–based line types let you order and receive and/or invoice based on the quantity of goods or services provided. You can use quantity–based line types when you want to specify the quantity, unit of measure, and unit price for the items you are ordering. Purchasing module provides 'Goods' as an initial default quantity–based line type which is defined in purchasing options window. You can modify this line type by creating new quantity–based line types to satisfy your business needs.

b) Fixed Price–Based Purchase
If you have implemented Oracle Services Procurement module , you can use fixed price–based line types when you want to order general business services or temporary labor services (with Oracle Services Procurement) by a fixed amount. You create an order for fixed price service by selecting a fixed price–based line type, category, item description, and total amount of the service. You can receive and match fixed price services by amount.

c) Rate–Based Purchasing
If you have implemented Oracle Services Procurement module , you can use rate–based line types when you want to order temporary labor services by per unit rate. You can use rate differentials with this line type. You create an order for rate based service by selecting a rate–based line type, category, unit of measure, price, item description, and total amount of the service. You can receive and match rate–based services by amount.

d) Amount–Based Purchasing
You may use amount–based line types when you want to order services and other items by amount. You create an order for a service by selecting an amount–based line type, category, item description, and total amount of the service. You can also receive and match services by amount. Amount–based line types let you order and receive and/or invoice based on the value of the service provided.
When you choose an amount based line type, Purchasing module automatically sets the unit price to 1 for your line and enters the default unit of measure for the line type. You cannot change the unit price or unit of measure for amount–based requisition lines. You enter the amount of the service in the Quantity field. Your total line amount is the same as the value displayed in the quantity field. You can use the quantity field in your distributions to allocate the order amount to multiple accounting flexfields.

Amount–based line types let you order and receive and/or invoice based on the value of the service provided. You may use amount–based line types when you want to order services and other items by amount. You create an order for a service by selecting an amount–based line type, category, item description, and total amount of the service. You can also receive and match services by amount. services can also be ordered by quantity for example 40 hours consulting services order.

e) Outside Processing Line Types
You can use outside processing line types to enter purchasingdocuments to pay suppliers for outside processing operations.Purchasing provides Outside Processing as an initial outside processing line type, and you can create additional outside processing line types. You cannot use outside processing line types, unless Purchasing, Work in Process, and Bills of Material are installed.

f) Temporary Labor Line Types
If you have implemented Oracle Services Procurement module , you can use temporary labor purchase basis line types to enter purchasing documents to pay contingent labor (contract labor) providers.

--
Posted By OracleOnDemand to Oracle Applications at 1/27/2009 11:51:00 PM

Monday, January 26, 2009

[Oracle Applications] Encumbrance / Budgetory Control in Oracle Applications

You can define encumbrance accounting or budgetary control in Financial options window:
Navigation: AP or PO ----> Setup--> Organizations --> Financial Options.

In order to use encumbrance accounting or budgetary control, you must install Payables, Purchasing, and General Ledger modules. You may go to encunbrance region to enable encumbrance accounting and to specify the default encumbrance types which Payables module assigns to your invoices, and Purchasing module assigns to your requisitions and purchase orders.

If you enable encumbrance accounting or budgetary control, Purchasing creates
encumbrances when you reserve funds for a requisition or purchase order. If you use the perpetual accrual method in Purchasing, it reverses the purchase order encumbrances when you inspect, accept, and deliver the units. If you are using the periodic accrual method in Purchasing, Payables reverses the purchase order encumbrances when you create accounting entries for invoices. Payables module creates encumbrances when there is a variance between a matched invoice and the purchase order to which it is matched, and when the invoice encumbrance type is different from the Purchasing encumbrance type.

Oracle EBS provides two predefined encumbrance types that you can use to identify requisition, purchase order, and invoice encumbrances:- Commitment and
Obligation. You can define additional encumbrance types in Oracle General Ledger module in the Encumbrance Types window.

1) Use Requisition Encumbrance
You may enable this option to encumber funds for requisitions. If you enable this option, Purchasing creates journal entries and transfers them to General Ledger to encumber funds for purchase requisitions.

If you enable Use Requisition Encumbrance, you must select an encumbrance type by which you can identify your requisition encumbrance journal entries. Purchasing assigns this encumbrance type to the encumbrance journal entries it creates for purchase requisitions. If you enable Use Requisition Encumbrance, you can indicate whether you want requisition preparer to have the option to reserve funds. If you do not enable this option, only requisition approvers will have the option to reserve funds.

2)Use PO Encumbrance
Enable this option to encumber funds for purchase orders, purchase order and receipt matched invoices, and basic invoices (not matched). If you enable this option, Purchasing encumbers funds for purchase orders and Payables encumbers funds for variances during Payables Invoice Validation for purchase order and receipt matched invoices. If you enable this option and enter a non-purchase order matched invoice, Payables will encumber funds for it during Payables Invoice Validation. All Payables encumbrances are reversed when you create accounting entries. If you enable Use Requisition Encumbrance, you must also enable this option.

If you enable Use Purchase Order Encumbrance, select a purchase order encumbrance type by which you can identify your purchase order encumbrance journal entries. Purchasing assigns this encumbrance type to the encumbrance journal entries it creates for purchase requisitions and purchase orders. If you use purchase order encumbrance, select an invoice encumbrance type by which you can identify your invoice encumbrance journal entries. Payables module assigns this encumbrance type to the encumbrance journal entries that it creates. It is recommended that you use an encumbrance type different from the Purchasing encumbrance type so you can identify invoice encumbrances

--
Posted By OracleOnDemand to Oracle Applications at 1/26/2009 11:34:00 PM

[Oracle Applications] GL: Archive Journal Import Data

"GL: Archive Journal Import Data" profile option of General ledger module decides whether you want your Journal Import to save your journal import data from the GL INTERFACE table to the GL INTERFACE HISTORY table at the end of each Journal Import run. You could select the values of "Yes" or "No" for this profile option.

If you choose 'Yes', Journal Import will save your journal import data to the GL INTERFACE HISTORY table. In this case journal import will run slower.

If you choose 'No', Journal Import will not save your journal import data to the GL INTERFACE HISTORY table at the end of each successful journal import run.

The default value provided by Oracle for this profile option is 'No'. You can view this profile option at the User level. System Administrator can set this profile option at the Site, Application, Responsibility, or User level.

--
Posted By OracleOnDemand to Oracle Applications at 1/26/2009 11:26:00 PM

[Oracle Applications] Requisition - 'Inprocess' status

1) The preparer completed the requisition and submitted to the approval process. However, no one with sufficient authority has approved the requisition. Requisition status will be 'in-process'

2) If in the Approve Document window you forward to an approver who does not have a logon user name, Purchasing module alerts you right away. If an approver without a logon user name is already included in the approval hierarchy, the approval workflow will fail at that approver and the document will remain' In Process'.

3) In requisition headers summary window, you may select the Open button to open the Requisitions window and query the requisition on the current line. Your options in this window depend on the status of the requisition and your approval and security options. For example, if a requisition has a status of In Process, you cannot open its line from requisition headers summary window.

--
Posted By OracleOnDemand to Oracle Applications at 1/26/2009 11:21:00 PM

[Oracle Applications] Line types in Oracle Purchasing

Line types in Oracle Purchasing

Oracle Purchasing module provides the line type feature for clearly differentiating orders for goods from those for services or outside processing orders. The line type governs the type of requisition, purchase order, RFQ, and quotation lines you create. You can select a default Line Type for requisition, RFQ, quotation, and purchase order lines. When you create any of these documents, the line type is part of your item information. You can override the line type for each document line. The services related line types support a broad range of service categories including general business services, consulting services, and contingent labor. While implementing oracle purchasing module 'Define Line Types' is a Required step with defaults.

The different types of line types are as follows:

a) Quantity–Based Purchasing line type
b) Fixed Price–Based Purchasing line type
c) Rate–Based Purchasing line type
d) Amount–Based Purchasing line type
e) Outside Processing Services Purchasing
f) Temporary Labor Purchasing line type

More details on each line type and defining line types follow in next posts

--
Posted By OracleOnDemand to Oracle Applications at 1/26/2009 11:09:00 PM