Saturday, December 14, 2013

Create master items in Oracle Inventory

There are many ways of creating or defining items inside Oracle Inventory
·         Use Master items from Inventory Items menu
·         Load data using data loading tools and load the data into interface table MTL_SYSTEM_ITEMS_INTERFACE and validate and run concurrent program
When you use Master items using item master window you may have two options to choose
·         Attribute Groups tab,
·         Item Folder tab.
















The Attributes Group tab allows you to select individual attributes, and use the tool menu to apply templates and assign it to organizations.

 The Item Folder tab enables you to create an item, apply a default template, and assign the item to an organization all in one window.This is good when you are using dataloader using the UI.

Wednesday, December 11, 2013

Oracle Applications Implementations Methodologies (AIM, AIM for Business Flows, OUM)

What is a methodology
A methodology is a set of guidelines that can be used and applied to a specific situation during the applications development and implementation life cycle. See below the common methodologies
Software Development Methodology
  • Waterfall
  • Prototyping
  • Incremental
  • Rapid Application Development (RAD)
  • Rational Unified Process
  • Agile Unified Process
Project Management Methodology
  • Project Management Institute PMBOK
  • Prince 2
  • Critical Chain Management
  • Process based Project Management
  • Agile Project Management

Oracle Applications Implementation Methodologies
  • Oracle AIM
  • Oracle ABF
  • Oracle Unified Method (OUM)
AIM  methodology known as  Ask and Do as it is requirements driven and solution is derived based on the requirements during the project.

AIM For Business Flows (ABF) also called as Show and Tell, as it is solution driven and Solution Flow is defined before the start of project. It is based on iterative approach based where multiple runs of CRPs are done. In the essence it aims at avoiding customization and prioritizes all changes. 

OUM The vision for the Oracle Unified Method (OUM) is to support the entire enterprise IT life cycle, including support for the successful implementation of every Oracle product. OUM supports implementations of every size including: staff augmentation, agile implementations ,projects (small to large), programs

Oracle AIM Phases
  1. Definition
  2. Operational & Analysis
  3. Solution Design
  4. Build
  5. Transition
  6. Production

Oracle AIM For Business Flows Phases


  1. Definition
  2. Elaboration
  3. Build
  4. Transition
  5. Production



ATO,PTO,MTO,CTO

Manufacturing Methods

  • ATO
  • PTO
  • MTO
  • CTO

Assemble to Order (ATO)

These are the standard products and are often configured by customers.Sub assemblies are manufactured prior to receiving the order and when the order is received ,the sub assemblies are assembled to make the finished products For Example : Automobiles , Computers

Pick to Order (PTO)
A Variety of shippable components are stocked. Customers order kits or collection of these parts under a single item number. Kits can be predefined or configured by the customer during the order entry process.
There is no additional value added after the customer order. For Example : Computer System (CPU , Monitor , and Printer)

Make to Order (MTO)
Standard Products are designed and published in catalogs. The actual product is built on receipt of the customer order.Customer might be able to choose certain characteristics optionally. An example of this would be a machine building.

Configure To Order (CTO)
This is when manufacturer has few configurable base models. An example is heavy equipment manufacturers which usually have several base tractor & truck models, but where customers can choose configuration option for each order, like air con, radio, bucket size, boom length, etc. Without CTO software, the number of combination of finished good stored in the system will be ridicilously high. Using CTO software, manufacturer only has to store a master base (or generic) item along with its generic BOM & routing, plus some configuration question which adds or remove parts/operations. When customer books an order, the sales rep asks series of questions (would you like air con? which bucket size would you like? and so on) then records the answers in the system. The CTO software then automatically create a new product variant specifically according to the configuration required by the customer. The product variant will automatically have customized BOM & routing per customer request as well, so that when the production is executed in the shop floor, correct materials & routings are followed


Friday, December 6, 2013

Key Differences between Process and Discrete Manufacturing

Key Differences between Process and Discrete Manufacturing


Oracle MES for process manufacturing

Oracle MES for process manufacturing flow diagram