Saturday, October 17, 2009

Setup Steps – Order Mangement


Setup Steps – Order Mangement

Step 1: Multiple Organizations
Step 2: Multi-Org Access Control
Step 3: Flexfields
Step 4: Inventory Organizations
Step 5: Profile Options
Step 6: Parameters
Step 7: Invoicing
Step 8: Salespersons
Step 9: Tax
Step 10: QuickCodes
Step 11: Workflow
Step 12: Document Sequences (Order Numbering)
Step 13: Order Import Sources
Step 14: Units of Measure
Step 15: Item Information
Step 16: Items
Step 17: Configurations
Step 18: Pricing
Step 19: Customer Classes
Step 20: Customers
Step 21: Item Cross References
Step 22: Sourcing
Step 23: Order Management Transaction Types (Sales Documents)
Step 24: Cost of Goods Sold (COGS)
Step 25: Processing Constraints
Step 26: Defaulting Rules
Step 27: Credit Checking
Step 28: Holds
Step 29: Attachments
Step 30: Freight Charges and Carriers
Step 31: Shipping

Monday, June 15, 2009

How does one setup Multi Org Access Control (MOAC) in Order Management for R12?

General MOAC Setup:

1. Define the Security Profile in HRMS:

a. Using HRMS Management responsibility

b. Navigate to: HRMS Manager > Security > Profile

c. Verify that the Security Profile is defined (for the OM responsibility or site level)

d. If it is not yet setup, enter it and attach the Operating Units

e. SAVE

NOTE: If you created a new security profile in 'd' above, you MUST run the concurrent program 'Security List Maintenance' or the multiple operating units will not appear in the LOV in the OM forms. This program populates a table that is used for validating multi-org access.

Navigation: HRMS Management > HRMS Manager > Processes & Reports > Submit Process & Report > Security List Maintenance
2. Setup MO Profile Options:

a. MO: Security Profile - Setting this profile enables MOAC functionality

b. MO: Default Operating Unit - This Operating Unit will default into OM forms and reports. You can use the LOV to clear it or change it.

Keep the MO profiles in sync:

MO: Security Profile is settable at both the site and responsibility level.

MO: Default Operating Unit is settable at the site, responsibility and user level.Verify the settings of these profiles if you find the application not behaving as expected.

3. OM Setup:

Review new OM System Parameters migrated from OM Profiles with R12 upgrade: Order Management Super User > Setup > System Parameters > Values


4. Enable hidden field 'Operating Unit' in forms and save as default folder:
Sales Order and Order Organizer forms

Quick Sales order and Organizer forms

Sales Agreement forms

Pricing and Availability form

Other forms

How Can One Use The Same Price List For Order Management And Purchasing?

How Can One Use The Same Price List For Order Management And Purchasing?

Yes, this is possible if one associates Advanced Pricing with Purchasing as follows:

1. Responsiblity: Oracle Pricing Manager

2. Navigate to: Setup > Attribute Management > Pricing Transaction Entity Association.

3. Do a FIND on: Name = PO It will show one line for code = PO.

4. Add a line as follows: Code = QP (defaults description = Advanced Pricing) Ensure that "enabled" is checked. Save.

5. Switch to the purchasing responsibility.

6. Navigate to Price List > Price List Setup Query the price list created and uncheck the 'active' checkbox. Save.

7. Please retest and the price is now returned from the price list created in Order Management.

Order Import Interface Tables

OE_HEADERS_IFACE_ALL

OE_LINES_IFACE_ALL

OE_PRICE_ADJS_IFACE_ALL

OE_PRICE_ATTS_IFACE_ALL

OE_CREDITS_IFACE_ALL

OE_LOTSERIALS_IFACE_ALL

OE_RESERVTNS_IFACE_ALL

OE_ACTIONS_IFACE_ALL

OE_CUSTOMER_INFO_IFACE_ALL

OE_PAYMENTS_IFACE_ALL

Order Management tables

Order Management related tables
Entity Related Table Name
----------------------------- ------------------------
Order Header OE_ORDER_HEADERS_ALL
Order Price Adjustments OE_PRICE_ADJUSTMENTS
Order Sales Credits OE_SALES_CREDITS
Order Line OE_ORDER_LINES_ALL
Order Pricing Attributes OE_ORDER_PRICE_ATTRIBS
Order Adjustment Attributes OE_PRICE_ADJ_ATTRIBS
Order Adjustment Associations OE_PRICE_ADJ_ASSOCS
Line Sales Credits OE_SALES_CREDITS
Line Price Adjustments OE_PRICE_ADJUSTMENTS
Line Pricing Attributes OE_ORDER_PRICE_ATTRIBS
Line Adjustment Attributes OE_PRICE_ADJ_ATTRIBS
Line Adjustment Associations OE_PRICE_ADJ_ASSOCS
Lot Serial Numbers OE_LOT_SERIAL_NUMBERS

Thursday, June 11, 2009

Oracle Pricing

Oracle Pricing engine determines the selling prices for products and services. It provides answers to the following questions:
1) Who qualifies for prices and benefits?
2) What is the item or service, which is being priced or modified?
3) How do we adjust the order price or the order line price?
How it works?Oracle Advanced Pricing prices any transaction by first identifying a list price which contains the list price. The pricing engine (Qualifiers) then determines whether the price found on the price list have to be adjusted or not. Modifiers control the amount of these adjustments, and can modify a price by either giving a discount or adding a surcharge. Once the pricing engine has selected one or more modifiers that adjust the price, it computes the final selling price.
"Price List" contains price for items and/ or services. You could have multiple price list for the same items/service. For example: Standard Price List, Summer Promotion Price List, Festival price list.
"Qualifiers" determine who is eligible for a price or modifier list. For example: Order Type, Customer Class, Customer Site and Customer Name.
"Pricing Attribute" determines what is being priced or modified on a price or modifier list. For example: Item Category, Product Brand, Location, Distance, Age and Volume.
"Modifiers" determines how the eligible item/service is priced. For example, Discounts, Surcharges, Coupon Issue, Item Upgrade, Terms Substitution, Freight Charge, Promotional Goods.
With all the above inputs, Pricing Engine calculates the final Price which is equal to the original price on the price list minus any eligible discounts, plus any other applicable surcharges or promotionsOracle Pricing is flexible to occupy various combinations to suit the business needs.
For example:
-Price List A is for Product X and applicable for Customer ABC.
- Price List B is for All Products and applicable for All Customer.
- Price List C is for all products belonging to Item Category A and B and applicable for All Customers

Supply types in Oracle WIP?

Supply types decides the method of supplying component materials to discrete jobs and repetitive schedules in WIP module. It also controls how materials are planned in MS/MRP module and how materials are costed in Cost Management module.You can assign supply types to the items when you define in Inventory module. You can also assign supply types to components when you create bills of material in Bills of Material and Engineering modules. The following is a list of the WIP supply types and the way they work:

a) Push

Push components can be manually issued directly to discrete jobs and repetitive schedule as per requirements. You can specify the subinventory for items in Item definition form or in Bills or define default subinventory in WIP parameters form. Work in Process defaults the supply subinventory associated with the component.

b) Operation Pull:

Operation pull components that are assigned to backflush operations, are automatically backflushed (pulled) from inventory and issued to discrete jobs and repetitive schedules when assemblies are moved and completed at that operation i.e. when you complete backflush operations. Also, operation pull component that have not been backflushed because they are assigned to non-backflush operations prior to the backflush operation are also backflushed. The Components are pulled from the supply subinventory assigned to the component. You cannot assign this supply type to an assenbly without a routing or a non-standard discrete job without a routing. You can assign this supply type to assemblies that have routings with no operations or when the routing has disabled operations. However, all components with a supply type of operation pull are automatically changed to assembly pull.

c) Assembly pull:

Assembly Pull components are issued (backflushed) to discrete jobs and repetitive schedules when you complete all operations on assemblies in Work in Process. They are pulled from the supply subinventory assigned to the component requirement.If you want to assign pull components to a bill of material or job that is not associated with a routing, you must assign an Assembly Pull supply type, rather than operation pull supply type. You cannot assign this supply type to a non-standard discrete job if you have not specified an assembly or bill of material reference for that non standard discrete job.

d) Based on Bill:

When you define a discrete job or a repetitive line/assembly association in WIP, the supply type for the assembly defaults to Based on Bill and assembly components are supplied based upon their bill of material supply types. You can change the defaulted Based on Bill supply type that is assigned to jobs and schedules as you define them. The Based on Bill supply type is WIP specific.If the supply type for a job or line/assembly association is changed, the new supply type is applied to all component material requirements. For example, if you change the supply type of a job assembly from Based on Bill to Assembly Pull, the supply types of all assembly components are changed to Assembly pull. You can update the supply types of individual material requirements using the Material Requirements window in WIPThe system automatically changes components with a supply type of Operation Pull to Assembly Pull, when the Based on Bill supply type is applied to a job or repetitive job/ schedule that has a bill of material but has no a routing or operations.

e) Bulk:

Bulk component requirements can be viewed and are displayed on reports and inquiry forms (that display components requirements) when you include Bulk components on a bill of material. They can be used to communicate to the shop floor that bulk components must be used but need not be transacted. You can choose specific components in the type field of WIP material transaction form for issuing bulk components.Bulk components are not backflushed nor do they default when issuing all components for an assembly. You can, however, manually issue specific bulk components to a discrete job or repetitive schedule. This supply type is selected for components like screws,nuts,bolts,nails,etc where it is difficult and may not be necessary to transact the exact quantity used.

f) Supplier/Vendor:

Supplier component requirements can be included on bills of material. Requirements for supplier components are created when you define discrete jobs and repetitive schedules in Work in Process. Supplier component requirements can be viewed and are displayed on reports. They provide information on the component materials that your suppliers provide but need not be transacted. Supplier components are not backflushed nor do they default when issuing all components for an assembly. You can, however, manually issue specific supplier components to discrete jobs and repetitive schedules/job.

g) Phantoms:

Phantom components can be assigned to bill of material component subassemblies and subassembly items in BOM and Engineering. Components of phantom subassemblies are used as if they were tied directly to the parent assembly. Phantom supply types cannot be assigned to jobs and repetitive lines/assembly associations in Work in Process. When model or option class bills are components to another bill of material, that component supply type is phantom.

Phantoms behave normally when they are top level assemblies, such as when master scheduled or manufactured on a discrete job. As subassemblies, they lose their distinct identity and become a collection of their components. Phantom components (not the phantom itself) are included on discrete jobs and repetitive job/schedules and are listed on the Discrete Job and Repetitive Schedule Pick List Reports.

Which are different manufacturing strategies?

There are 4 manufacturing strategies

a) Make to stock(MTS)

b) Make to Order(MTO)

c) Assemble to Order(ATO)

d) Engineer to order(ETO)

In MTS, stock is created by companies for items without receiving an order from customer. Examples are manufacturing of refrigerators, washing nachines and Television sets. They are manufactured in a flow shop based on master schedule and stocked in finished goods subinventory until they are shipped to a cutomer.

MTO are manufactured after receiving customer order, which means customer is willing to accept longer delivery period. The examples are commercial dish washers and refrigerators for hotels. These items are produced in a flow shop or in job shop depending up on the range of product families produced by the factory. In order to reduce lead time the factory often uses ready components to manufacture a product.

In ATO, stock of existing items is kept on hand but they are sub assemblies, not the finished product. The company uses final assembly orders to put the finished product together according to specifications of the customer order. This involves some extra lead time but not as much as MTO. Private aircrafts, commercial trucks and computers are the examples of ATO. ATO items may be produced either in flow shop or job shop. ATO offers many variations in standard product because of the choices the customers have in deciding final product from options provided .

ETO item is built on the customer product specifications such as large commercial aircrafts. Such product can not be produces according to existing specifications of the company because some engineering skill is required to incorporate customer specifications in to the design of the final product. Companies using this manufacturing strategy, always quote longer lead time .The engineering and manufacturing costs involved are also high and are tracked for each order separately.

Commonly used terms in Oracle Inventory

What is an Inventory Item?

A part number or product code used to track goods or services. Inventory item numbers represent physical goods that are purchased, built or assembled. Inventory item numbers may also be created to represent services sold to customers. These numbers have attributes that describe or control how the item is used. Inventory items are created in an Item Master Organization and then assigned to execution inventory organizations. Attributes for items may be set at the master level, so the value is consistent across all organizations, or at the organization level, so that the value may vary by organization. The attribute control level determines if an attribute is set at the master or organization level. An example of a typical master level controlled attribute is Item Description, which you may want to be the same across all organizations. Planner code, however, is set at the organization level, as each organization has a planner responsible for managing the item.

What is an Inventory Organization?

An entity used to represent a manufacturing or distribution site. Inventory organizations are where a user tracks on-hand balances, manufactures goods, and transacts the daily ins and outs of material movement. An inventory organization is the lowest level entity for costing goods, planning material requirements, and securing system access. Only a single address may be assigned to an Inventory Organization. An inventory organization is assigned a Set of Books which determines the chart of accounts, fiscal calendar, and base currency for all financial and value added activities that occur within the organization. Inventory Organizations are also assigned to a Legal Entity Organization and an Operating Unit Organization.A variation on the inventory organization is the master item organization. Generally, with Oracle Applications a single inventory organization is created and designated at the master organization. Items are defined first in the master organization, then enabled in other inventory organizations as necessary. Some of the item attributes are set as controlled at the master organization and therefore the attribute values cannot be updated within individual inventory organizations. Category sets may also be designated as master organization level. Cross-references are also master level only or master level optional as well.

What is a Category Set?

A grouping of item categories. A category set is a user-defined entity for grouping items by category within the category set entity. Oracle inventory requires at least one category set be used. Product family, commodity, usage, or any other grouping and reporting requirements a user may have generally define category sets for grouping items. Category sets may be defined at the master organization level or the inventory item organization level. What is an Item Category?A code used for classifying or grouping items. Items are assigned to a category within a category set for reporting and grouping. To see the grouping, a user would specify a category set and one or more categories from that set.

What is a Subinventory?

Physical or logical locations for storing inventory. Subinventories are generally defined to represent the main stores area as well as stocking points on the production floor. Additional subinventories may be used to specify supply closets or cabinets and the cage area for discrepant material. Subinventories are flagged as to availability for planning (nettable), reservations, and available to promise checks, thereby determining the availability of the material stored in the subinventory. Subinventories are assigned material asset account numbers. As goods move in and out of a subinventory a transaction posts to the asset account.

What is a Workday Calendar?

The workday calendar indicates the manufacturing workdays for an inventory organization. The calendar indicates holidays as well as work shifts. Multiple calendars may be defined for an organization to represent differences in workdays by department or group.What is a Stock Locator?A physical area within a stockroom. The stock locator is a key flexfield that is often defined as a multiple segment flexfield with the segments representing the physical layout of a stockroom. For example, a stockroom may be laid out in rows of shelves with bins on the shelves, each numbered so that a row/shelf/bin combination would direct someone to a particular material storage compartment. Such an implementation would define a locator flexfield as a 3 segment flexfield with segments for row, shelf, and bin.

What is Discrete Manufacturing?

1) Discrete manufacturing is a manufacturing process in which distinct items/products(which you can easily count, see and touch) are built or manufactured in discrete batches on manufacturing floor. It creates physical products which go directly to business and consumers, and assemblies that are used by other manufacturers. The resulting product is easily identifiable. It is different from process manufacturing where products are undifferentiated (can not tell the difference between one product and another) such as oil, natural gas and salt.

2) A typical characteristic of discrete manufacturing is the frequent switching from one manufactured product to another. The products are typically manufactured in individually defined lots, the sequence of work centers through production varying for each one of these. Costs are calculated on the basis of orders and individual lots.

3) Discrete manufacturing is also characterized by individual or separate unit production. Units can be produced in low volume with very high complexity or high volumes of low complexity. Low volume/high complexity production results in the need for an extremely flexible manufacturing system that can improve quality and time-to-market speed while cutting costs. High volume/low complexity production puts high premiums on inventory controls, lead times and reducing or limiting materials costs and waste.

4) Discrete manufacturing typically involves the sequence of work centers through which the products can pass during production. This sequence can be varied as per requirement. The order of work centers is determined in routings, which can often be very complex. There can be waiting times between the individual work centers. Also, semi-finished products are frequently placed in interim storage prior to further processing.

5) In discrete manufacturing, component materials are staged with specific reference to the individual production lots. Completion confirmations for the various steps and processes document the work progress and enable fine-tune controlling.

Examples are Transportation equipment, Automobiles, toys, Computer and accessories and electronic products, consumer electronics, furniture, Lego Blocks, Appliances and other house hold items, Industrial and electrical equipment, Medical equipment and supplies, Fabricated metal, furniture, recycling, pencil ,light bulb, telephone, bicycle, fuel pump, miscellaneous manufacturing as well as "big ticket” consumer and commercial goods like cars and airplanes, semi conductors, outfitting with industrial products, machine and plant engineering, right through to shipbuilding and aircraft construction. Fabricating products by assembling components and subsystems into larger systems. The automated assembly line is the prime example of discrete manufacturing such as in the making of automobiles, household appliances and computer systems. Discrete manufacturing systems typically deal with digital inputs to programmable logic controllers (PLCs) and programmable automation controllers (PACs) that cause motors and robotic devices to be activated. Fabricated Metal Products, Industrial and Commercial Machinery.

What is Process Manufacturing?

Process manufacturing is different from Discrete manufacturing. Manufacturing is not in discrete batches but is a process of pressing/mixing/chemical processing/heating/boiling liquid/semi liquid/solid and powder or raw materials.

Once you manufacture a product by using process manufacturing, the output can not be brought to it's original basic form. For example orange juice with sugar added cannot be put back in to the Orange and Sugar seperately. On the other hand a computer manufactured by a discrete manufacturing process can be disassembled and the parts can be returned to stock to a large extent.

Examples of process manufacturing are food products, beverages, paints & coatings, chemicals, specialty chemicals , pharmaceuticals, consumer packaged goods, Bulk drug pharmaceuticals, Nutraceutical, cosmeceutical and biotechnology industries. In Process Manufacturing, there are ingredients and not parts; there are formulas and not bill of materials; and bulk, not Unit of measure Each.

Tuesday, June 9, 2009