Oracle E-Business Suite R12 Supply Chain Management

I got a request to review book “Oracle E-Business Suite R12 Supply Chain Management” written on Oracle Supply Chain by Muneeb A. Siddiqui and published by Packt Publishing.

Apparently it seems to me good book for beginners with Case study etc. I will review this and will keep everyone posted. Meanwhile you guys can have a look at Sample Chapter on following link


How to Create Position Hierarchy by Using APIs

How to Create Position Hierarchy by Using APIs

Supply Chain Footprint in Oracle Application

1. Supply Chain Planning

MRP/Supply Chain Planning

Demand Planning

Advanced Supply Chain Planning

Constraint and Inventory Optimization

Global Order Promising

Manufacturing Scheduling

Inventory Optimization

Collaborative Planning

Transportation Planning

Supply Chain Intelligence as an independent module

2. Order Management

Order Management





Advanced Pricing

Quoting & Proposals

Trade Management

Release Management

Sales Contracts

3. Procurement





iSupplier Portal

Procurement Contracts

  1. Manufacturing

Discrete Manufacturing

– Project Manufacturing

– Flow Manufacturing

– Project Contracts

– Shop Floor Management

Process Manufacturing

  1. Logistics

Inventory Management

Mobile Supply Chain Apps

Warehouse Management

Transportation Execution

6. Service

Tele Service

Depot Repair

Field Service

– Spares Management

– Advanced Scheduler

Mobile Field Service


Service Contracts

7. Maintenance Management

Enterprise Asset Management

Property Manager

Demand and reservation information used in Available To Promise, Planning and other Manufacturing Functions

Following query returns Demand and reservation information used in Available To Promise, Planning and other Manufacturing functions.

There are three major row types stored in the table

· Summary Demand rows

· Open Demand Rows

· Reservation Rows.



SELECT SUBSTR (md.demand_id, 1, 8) ID,

SUBSTR (demand_source_header_id, 1, 8) demand_source_header_id,

SUBSTR (parent_demand_id, 1, 8) parent_demand_id,

SUBSTR (demand_source_line, 1, 10) demand_source_line_id,

SUBSTR (demand_source_delivery, 1, 10) demand_source_delivery,

SUBSTR (inventory_item_id, 1, 10) “Item Id”,

(SELECT UNIQUE msi.description

FROM mtl_system_items_b msi

WHERE msi.inventory_item_id =

SUBSTR (md.inventory_item_id,



)) “Item Description”,

SUBSTR (inventory_item_id, 1, 10) item_id,

SUBSTR (organization_id, 1, 5) organization_id,

SUBSTR (reservation_quantity, 1, 5) reservation_quantity,

SUBSTR (primary_uom_quantity, 1, 5) primary_uom_quantity,

SUBSTR (reservation_type, 1, 5) reservation_type,

SUBSTR (requirement_date, 1, 10) requirement_date,

SUBSTR (subinventory, 1, 10) subinventory,

SUBSTR (serial_number, 1, 10) srl_num,

SUBSTR (lot_number, 1, 10) lot_num

FROM mtl_demand md

What are make to order and make to stock items in Oracle E-Business Suite and what are there decision factor?

What are MTO and MTS in Oracle E-Business Suite and what are there decision factor?

Make to Order (MTO)

Some manufacturing units manufacture products only against customer orders in other words job is directly associated with Sale order.

This is an example of make to order scenario. In case of make to order products manufacturing lead time need to be low enough to meet the customer requirements. Organizations may stock sub assemblies / Factory made items used in multiple finished products to enable them to satisfy customer demand within a reasonable time.

Make to Stock (MTS)

Some time Products are manufactured in advance expecting future customer orders.

This is the example of make to stock scenario. Organizations making make to stock products are almost totally dependent on planning forecast. In such cases forecast accuracy is a very important factor to maintain cost effective operations.

There are manufacturing units which has both MTO and MTS type of products

MTO & MTS Decision Factors

Depending on different factors like manufacturing lead time, product cost, market demand, competitor’s capability, storage space, change over time, change over cost etc. manufacturing organizations decide to operate the plant as MTO or MTS. The item parameters are to be set accordingly so that the recommendations provided by Advance Supply Chain Planning support MTO or MTS strategy.

Oracle Advanced Supply Chain Planning

Oracle Advanced Supply Chain Planning has component based architecture that separates the transaction data and processing associated in a source instance from the planning calculations done in a destination instance.

The Oracle Advanced Planning can plan a single instance or multiple instances. An instance is a database and a set of applications.

There are several types of instances:

Source instances
Source instances hold source information, for example, items, bill of materials, Orders. Source instances are Oracle Applications instances (from releases 10.7, 11.0, and 11i) or legacy systems.

Destination instance
The destination instance (APS planning server) holds planning information. Planners use the planning server to store information collected from the source instances. Run, analyze, and simulate plans; and implement planned orders.

Oracle Advanced Supply Chain Planning consist of following modules

1. Oracle Collaborative Planning
2. Oracle Demand Planning
3. Oracle Global Order Promising
4. Oracle Inventory Optimization
5. Oracle Manufacturing Scheduling