Monday, November 23, 2009

Specifications in Oracle Quality

Specifications define the requirements to which the product must conform. You can define specifications for the key characteristics of the products that you produce or for the materials that you receive from suppliers. You can attach illustrative or explanatory files to specifications, such as text, images, word processing documents, spreadsheets, video, and so on. Attachments can be used to document processing instructions as well as inspection and disposition procedures.

Quality Menu > Setup > Specifications

Some typical examples of using specifications are:

1) Warn or trigger a specific action when collected data lies outside the reasonable range of a specifications

2) Assist data entry by displaying the specification limits

Three types of specifications available in Oracle Quality are Item, Supplier and Customer

Please send in your queries on ""

Thursday, November 12, 2009


A man who dares to waste one hour of time has not discovered the value of life.
-- Charles Darwin

All the art of living lies in a fine mingling of letting go and holding on.
-- Henry Ellis

Any idiot can face a crisis - it's day to day living that wears you out.
-- Anton Chekhov

Believe that life is worth living and your belief will help create the fact.
-- William James

Don't go around saying the world owes you a living. The world owes you nothing. It was here first.
-- Mark Twain

Every man dies. Not every man really lives.
-- William Wallace

Everything has been figured out, except how to live.
-- Jean-Paul Sartre

God writes a lot of comedy... the trouble is, he's stuck with so many bad actors who don't know how to play funny.
-- Garrison Keillor

He who has a why to live can bear almost any how.
-- Friedrich Nietzsche

Here is the test to find whether your mission on Earth is finished: if you're alive, it isn't.
-- Richard Bach

Life consists not in holding good cards but in playing those you hold well.
-- Josh Billings

Life is half spent before we know what it is.
-- George Herbert

Like all sciences and all valuations, the psychology of women has hitherto been considered only from the point of view of men.
-- Karen Horney

My formula for living is quite simple. I get up in the morning and I go to bed at night. In between, I occupy myself as best I can.
-- Cary Grant

Only a few things are really important.
-- Marie Dressler

The purpose of life is a life of purpose.
-- Robert Byrne

There is only one difference between a long life and a good dinner: that, in the dinner, the sweets come last.
-- Robert Louis Stevenson

We can't plan life. All we can do is be available for it.
-- Lauryn Hill

When I stand before God at the end of my life, I would hope that I would not have a single bit of talent left, and could say, "I used everything you gave me".
-- Erma Bombeck

Your life is what your thoughts make it.
-- Marcus Aurelius

Action is the real measure of intelligence.
-- Napoleon Hill

Intelligence is the wife, imagination is the mistress, memory is the servant.
-- Victor Hugo

A hug is like a boomerang - you get it back right away.
-- Bil Keane

A man reserves his true and deepest love not for the species of woman in whose company he finds himself electrified and enkindled, but for that one in whose company he may feel tenderly drowsy.
-- George Jean Nathan

A woman knows the face of the man she loves as a sailor knows the open sea.
-- Honore de Balzac

Being deeply loved by someone gives you strength, while loving someone deeply gives you courage.
-- Lao Tzu

I like not only to be loved, but to be told I am loved.
-- George Eliot

If you live to be a hundred, I want to live to be a hundred minus one day so I never have to live without you.
-- A. A. Milne

If you press me to say why I loved him, I can say no more than because he was he, and I was I.
-- Michel de Montaigne

Love is a game that two can play and both win.
-- Eva Gabor

Love makes your soul crawl out from its hiding place.
-- Zora Neale Hurston

When I was born I was so surprised I didn't talk for a year and a half.
-- Gracie Allen

A soft refusal is not always taken, but a rude one is immediately believed.
-- Alexander Chase

Forgive your enemies, but never forget their names.
-- John F. Kennedy

It is easier to forgive an enemy than to forgive a friend.
-- William Blake

The weak can never forgive. Forgiveness is the attribute of the strong.
-- Mohandas Gandhi

How can a society that exists on instant mashed potatoes, packaged cake mixes, frozen dinners, and instant cameras teach patience to its young?
-- Paul Sweeney

A psychiatrist asks a lot of expensive questions your wife asks for nothing.
-- Joey Adams


Collection elements in Oracle Quality

Collection elements are the basic building blocks of collection plans, which are the data structures that you use to collect Quality results. Before you can collect Quality data, you must first create a collection plan. You begin by creating collection elements, which define the characteristics of the product or process that you want to monitor, record and analyze.

Collection elements are categorized by type so that they can be sorted and grouped in database searches and on reports. You assign collection element types to collection elements when you define them.

Oracle Quality offers 3 types of collection element types as mentioned below:

1. Reference information
2. Variable
3. Attribute

Reference Information collection element type groups collection elements that reference common objects defined in other Oracle Applications, such as Oracle Flow Manufacturing, Inventory, Order Management, Purchasing, and Work in Process. You can reference any data within an Oracle Database.

Variable collection element type is used when you need collection elements based on specification tolerance ranges. Specification limits can be entered and actions can be triggered when data is input outside of the range.

Attribute collection type is used when you need collection elements based on a customized list of values. Here you can create your values you wish the user to select from.

For queries, please write to
Please do not request to send training material on emails

Monday, July 6, 2009

Oracle Configurator - What is it about?

"Each time our customers order us, its different configuration from the earlier product we supplied them earlier. It eats up our time in analyzing if what they ask is a possible combination of components that we can supply and we also loose a good time in quoting our customers. Sometimes we end up knowing from our manufacturing team that the requested configuration is not at all possible to manufacture"

Is this something you hear from your client? We are sure you might want to have a look at what Oracle Configurator does. It enables companies to specify, sell and ultimately manufacture and fulfill complex, customized products. Basically, it guides the user to configure the product while you have customer over the phone. While doing so, it continuously validates the possible combinations of options that could be supplied. It brings expertise of a knowledgeable salesperson to the point-of-sale.

What more? Through a web-based interface, it guides the customer to configure the product that best meets their needs through interactive set of questions that gather the requirements and map it to the product that matches the need.

Oracle Configurator integrates with the below modules:

Oracle Order Management
Oracle iStore
Oracle Field Sales
Oracle Quoting
Oracle TeleSales
Oracle Install Base
Oracle Advanced Pricing
Oracle Advanced Planning and Scheduling
Oracle Inventory
Oracle Bills of Materials

Sunday, April 26, 2009

Oracle MSCA - Snapshot


Hello Friends,

Here are few slides on understanding the basics of Oracle MSCA. To view the slides, please visit



Tuesday, April 21, 2009

Understanding Oracle ASCP - Data Collections


Hello Friends,

Here are few slides on understanding the basics of Oracle ASCP. To view the slides, please visit



Monday, April 13, 2009

Serial Number Uniqueness

Using the Organization Parameters window, user can choose the type of serial number uniqueness for the organization. You can choose to enforce uniqueness within inventory items, within an organization or across organizations.

However, system stops you from creating the same serial number for the same item in a different operating unit. Obvious reason for this being that the base table MTL_SERIAL_NUMBERS does not have any column to hold the OU value.

Let us know your comments, if you disagree

Monday, March 30, 2009

Kanban in Oracle Applications


Here are few slides on implementing Kanban using Oracle Applications. Please note that slides can be viewed on


Tuesday, March 24, 2009

Available to Promise (ATP) in Oracle Applications


Available to Promise (ATP) in Oracle Applications


Wednesday, March 11, 2009

Oracle Quality - Data collection structure

Oracle Quality can be used to gather user-defined quality data. Data collected and input into Oracle Quality may come from functions such as purchasing, service, shopfloor inspection or directly from the customer.

The data collection structure in Oracle Quality comprises of
a) Collection Elements
b) Specifications
c) Collection Plans

The basic building block of this structure is the collection element, which is used in both the specifications and the collection plan. Collection elements define the characteristics or the quality parameters of the product or the process, which is being analyzed and for which we collect and report data. Collection Plans are similar to test or inspection plans. Collection plans specify which are the collection elements to be used in collecting data. Collection plans specify when
and how to collect the data as well as the actions to take based on the data collected. Specifications set the quality standards to which the product or the process should conform. These standards can be in the form of absolute values or a specific range within which the results would be acceptable. The type of collection elements being used determines the nature of the specification.


Monday, March 9, 2009

Oracle WIP Tables

Oracle WIP Tables



Wednesday, March 4, 2009

ERP market in Year 2009

ERP market in Year 2009

Inventory Management - An Introduction

Inventory Management - An Introduction

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.

Thursday, January 29, 2009

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


Tuesday, January 27, 2009

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.

Monday, January 26, 2009

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

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.

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.

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

Wednesday, January 14, 2009

Shortnames for Oracle Applications products

Shortnames for Oracle Applications products

1)ABM - Activity Based Management
2)AD - Applications DBA
3)AHL - Oracle Advanced Service Online
4)AK - Oracle Common Modules-AK
5)ALR - Oracle Alert
6)AMF - Oracle Fulfillment Services
7)AMS - Oracle Marketing
8)AP - Oracle Payables
9)AR - Oracle Receivables
10)AS - Oracle Sales
11)ASG - Oracle CRM Gateway for Mobile Services
12)ASL - Oracle Mobile Field Sales Laptop
13)ASO - Oracle Order Capture
14)AST - TeleSales
15)AX - Global Accounting Engine
16)AZ - Application Implementation
17)BEN - Oracle Advanced Benefits
18)BIC - Customer Intelligence
19)BIL - Sales Intelligence
20)BIM - Marketing Intelligence
21)BIS - Oracle Applications BIS
22)BIX - Call Center Intelligence
23)BNE - Oracle Web ADI
24)BOM - Oracle Bills of Material
25)BSC - Balanced Scorecard
26)CCT - Oracle Call Center and Telephony
27)CE - Oracle Cash Management
28)CHV - Oracle Supplier Scheduling
29)CLN - Supply Chain Trading Connector for RosettaNet
30)CN - Oracle Sales Compensation
31)CS - Oracle Service
32)CSC - Customer Care
33)CSD - Depot Repair
34)CSE - Oracle Enterprise Install Base
35)CSF - Field Service
36)CSI - Install Base
37)CSM - Oracle Field Service Palm
38)CSP - Oracle Spares Management
39)CSR - Oracle Scheduler
40)CSS - Support
41)CUG-Oracle Citizen Interaction Center
42)CUN - Oracle Network Logistics NATS
43)CZ - Oracle Configurator
44)EAM - Oracle Enterprise Asset Management
45)EC - Oracle e-Commerce Gateway
46)ECX - Oracle XML Gateway
47)EDR - Oracle E Records
48)ENG - Oracle Engineering
49)FII - Financials Intelligence
50)FLM - Oracle Flow Manufacturing
51)FND - Application Object Library
52)FTE - Oracle Transportation Hub
53)FV - Oracle Federal Financials
54)GHR - Oracle Federal HR
55)GL - Oracle General Ledger
56)GMA - Oracle Process Manufacturing Systems
57)GMD - Oracle Process Manufacturing Product Development
58)GME - Oracle Process Manufacturing Process Execution
59)GMF - Oracle Process Manufacturing Financials
60)GMI - Oracle Process Manufacturing Inventory
61)GML - Oracle Process Manufacturing Logistics
62)GMP - Oracle Process Manufacturing Process Planning
63)GMS - Oracle Grants Accounting
64)GR - Oracle Process Regulatory Mgmt
65)HRI - Human Resources Intelligence
66)HXC - Oracle Time and Labor
67)HXT - Oracle Time and Labor Rules
68)IBA - iMarketing
69)IBC - Oracle iContent
70)IBE - iStore
71)IBU - iSupport
72)IBY - iPayment
73)ICX - Oracle Self-Service Web Applications
74)IEB - Oracle Interaction Blending
75)IEC - Oracle Campaign Plus
76)IEM - Oracle eMail Center
77)IEO - Call Center Technology
78)IES - Scripting
79)IEU - Oracle Universal Work Queue
80)IEX - Oracle Collections
81)IGC - Commitment Administration
82)IGF - Student Systems Fin Aid
83)IGI - Oracle International Public Sector Financials
84)IGS - Oracle Student Sytems
85)IGW - Oracle Grants Proposal
86)INV - Oracle Inventory
87)IPD - Oracle Product Development Exchange
88)ISC - Supply Chain Intelligence
89)JTF - CRM Foundation
90)JTM - Oracle CRM Mobile Foundation
91)JTS - Oracle CRM Self Service Administration
92)MRP - Oracle Master Scheduling/MRP
93)MSC - Oracle Advanced Supply Chain Planning
94)MSD - Oracle Demand Planning
95)OFA - Oracle Assets
96)OKC - Oracle Contracts Core
97)OKI - Oracle Contracts Intelligence
98)OKL - Oracle Lease Management
99)OKR - Oracle Contracts for Rights
100)OKS - Oracle Contracts Service Module
101)ONT - Oracle Order Management
102)OPI - Operations Intelligence
103)OTA - Oracle Training Administration
104)OZF - Funds & Budgets
105)PA - Oracle Projects
106)PAY - Oracle Payroll
107)PER - Oracle Human Resources
108)PJM - Oracle Project Manufacturing
109)PN - Oracle Property Manager
110)PO - Oracle Purchasing
111)POA - Purchasing Intelligence
112)POM - Oracle Exchange
113)PON - Oracle Sourcing
114)POS - Internet Supplier Portal
115)PQH - Oracle Public Sector HR
116)PSA - Public Sector Applications
117)PSB - Oracle Public Sector Budgeting
118)PSP - Oracle Labor Distribution
119)PV - Partner Relationship Management
120)QA - Oracle Quality
121)QP - Oracle Pricing
122)QRM - Oracle Risk Management
123)RG - Application Report Generator
124)RLM - Oracle Release Management
125)VEA - Oracle Automotive
126)WIP - Oracle Work in Process
127)WMS - Oracle Warehouse Management System
128)WSH - Oracle Shipping
129)WSM - Shop Floor Management
130)XDP - Oracle Provisioning
131)XNC - Oracle Sales for Communications
132)XNI - Oracle Install Base Intelligence
133)XNP - Oracle Number Portability
134)XNS - Oracle Service for Communications
135)XTR - Oracle Treasury

Sunday, January 11, 2009

Which are different Inventory Planning methods?

Which are different Inventory Planning methods?

There are 5 inventory Planning methods as mentioned below:
1) Subinventory Replenishment planning
2) Min-max planning
3) Re-order point planning
4) Kanban planning
5) Periodic Automatic Replenishment(PAR)

Subinventory Replenishment planning

Oracle Inventory provides additional methods for planning and replenishing inventories. Even if you are not maintaining perpetual on-hand balances in non-tracked subinventories, for example-you can use the replenishment counting system to plan your inventories. This may be ideal for replenishing free stock items that you store on the production floor, or office supplies kept in departmental cabinets. Oracle Inventory even provides an open interface for loading replenishment count data collected electronically, such as with a hand held bar code reader.

Replenishment Counting Tracked Subinventories
In some situations, you may want to do your own planning and use Oracle Inventory
to create your internal requisitions. When using the replenishment system in this
manner, you provide the system with one of the following pieces of information (in
addition to the item and subinventory):
• Order quantity. You specify the quantity that is to be ordered.
• Order maximum quantity. Oracle Inventory orders the min-max maximum quantity.
You can manually enter this information in the Replenishment Counts window or through an external interface, using the replenishment interface tables

Replenishment Counting Non-Tracked Subinventories
Planning and replenishment of non-quantity-tracked subinventories is different because Oracle Inventory cannot use perpetual system quantities. As you issue items from a subinventory without formal issuing procedures, it is necessary to take inventory of non-tracked subinventories to record item usage and determine reorder necessity.

In order to determine when and how much to replenish, you periodically physically count the items in non-tracked sub inventory. Here also you can enter the count details through batch load transaction such as bar code reader or manually by navigation. Inventory module permits on hand quantity as an additional replenishment information type for non-tracked subinventories.

Planning Levels
You can only use the replenishment counting system at the subinventory level. To use
replenishment counting, you must set up item-subinventory relationships using the Item Subinventories or Subinventory Items windows.

Which are different process flows in Oracle eAM module?

Which are different process flows in Oracle eAM module?

There are 2 types of process flows in eAM module as follows:

1) Work Execution Implementation Flow
First, You have to create a Maintenance Work in Process (WIP) Accounting Classes and then you need to define Resources and Maintenance Departments. Afterwards, you decide if employee association is required with resource. If employee and resource association is required, create resource and employee associations and if it is not required then create department and resource associations.

Finally, you decide if Work Orders are included in projects. If included then you need to set up Project Manufacturing module, and then create a Work Order. If Work Orders are not included in projects, create a Work Order.

2) Preventive Maintenance Implementation Flow
First, You have to create an Asset Group.
Next, decide if Preventive Maintenance (PM) definitions are based on runtime rules. If Yes, create Meter Templates, next Asset Group and Meter associations using those templates, and then create a Set Name. If it is NO i.e. if PM definitions are not based on runtime rules, create a Set Name directly.
Next, create a Maintenance Activity and then Asset Group and Activity associations using templates. Finally, optionally you have to create PM Schedule templates.

Oracle EAM - Different types of assets

Explain the different types of assets?

There are 2 types of assets
a) Capital or financial Assets
b) Maintenanace assets

Maintenance Assets can be classified into the following two types:

1) Linear Assets
Linear Assets have linear properties and are connected with each other by their relationship with the linear infrastructure itself. i.e. Networks
For example a metropolitan city which has a huge network of subways & roadways. You can model them as linear assets in an Asset Management system and the buildings, poles parks and terminals can be represented as non-linear assets. The joins and overlaps of the Linear Assets make up the networks and the non-linear assets can be ‘placed’ within that Network for positioning and tracking purposes.

Example are Roads, Rail lines and tracks ,Highways, airport runways, harbors,Ports, Subways, cables, Waterways, Transmission Lines, Water & Sewer pipe lines, Oil & Gas Pipelines

2) Non-Linear Assets
A non-linear asset does not have any linear property, occupies some space as per dimension and can be tracked by its location or modeled as part of a parent child hierarchy.

For example, Mobile assets such as fleet, vehicles, tools and equipment, Fixed Physical assets i.e. plant, equipment, facility ,Component relationship based assets (aircraft, ship), Terminals, Rail cars, Buses, Trucks, Buildings, Parks, Poles, Substations, Facilities, Power Generating Plants & Equipment,Pumping Stations, Extraction Facility.

Monday, January 5, 2009

'Push' and 'Pull' systems of controlling resources in Inventory planning

'Push' and 'Pull' systems of controlling resources in Inventory planning

The push system pushes the resources in to manufacturing based on resource planning. It is also more commonly known as the Materials Requirements Planning (MRP) system. This system is based on the Planning Department setting up a long-term production schedule which is then analysed to give a detailed production schedule for making or buying parts. This detailed schedule then pushes the operations team to make or purchase a part and push it forward to the next work station. The biggest weakness of this system is that it is based on guessing/forecasting the future customer product demand to develop the production schedule that production is based on and estimating the time it takes to produce each part. Over-estimation and under-estimation may lead to excess inventory quantity or part shortages, respectively.

A Pull system is a method of controlling the flow of resources in which replacement of products is based on consumption of the item quantity. A pull system is completely based on customer product demand. Whatever is consumed is only ordered on sources of supply. Since here the resources are pulled from the supply sources, it is called 'Pull' system. A Kanban system of Inventory planning is a Pull system that uses color-coded cards attached to parts or part containers to regulate the upstream production and delivery flow.

Thursday, January 1, 2009

Happy New Year !!

When does the PO status shows as 'Pre- Approved'?

When does the PO status shows as 'Pre- Approved'?

Pre–Approved document is one in which a person with the final authority to approve the purchasing document approves it, but then forwards it to someone else for additional approval, thus changing its status to Pre–Approved.


Your organization uses encumbrance budgeting (reserves funds for documents), and the purchasing document is eligible for approval but funds have not yet been reserved for it. Even if someone with sufficient approval authority approves this document, its status may still remain Pre–Approved if funds were not able to be reserved at the time of approval. Once funds have been reserved for the approved document, the document changes its status to Approved.

A Pre–Approved document does not show up as supply for planning module until its status changes to Approved.

Please enter your email address to subscribe

You won't repent doing this!