Monday, 19 January 2015

Advance Supply Chain Planning

This is one of the basic areas from management books. In fact lot of people have requested some more information on SCM, OPM and other manufacturing area. therefore,I take this opportunity, as this is one of my favorite topic, as I started my first job in PPC (Production Planning &Control) department of a big steel company a decades ago, so I hope I will surly help in giving a clear picture of SCM. Let's start with basic and gradually will move into ERP arena:
SCM is defined as combination of art and science that goes into improving the way your company find the raw components that needs to make a product or services and deliver it to customer. In Business word this art and science become functions that an organization undertake.
If you are IT guys you can understood SCM as:
Systems that support manufacturing managers in making decisions that optimize the trade off between capital tied up in stocks and inventories, versus the ability to deliver goods at prices and delivery dates agreed with customers.
In principle and reality, both inwards logistics operations to acquire materials to make products and outwards logistics operations shipping finished goods to final customers are monitored.
bluWHAT EXACTLY IS SUPPLY CHAIN MANAGEMENT OR WHAT IS BASIC COMPONENT OF SCM?
As per Supply-Chain Operations Reference-model (SCOR®) which has been developed by Supply-Chain Council. This model organized and focused on the five primary management
  1. PLAN
  2. SOURCE
  3. MAKE
  4. DELIVER
  5. RETURN
1. Plan: This is vital part of SCM philosophy, where the companies normally need to make strategy for managing all the resource that go towards fulfilling the customer demand for the product and services that they offers. A big piece of planning is developing a set of matrices to monitor the Supply chain so that it would be efficient, cost effective and deliver high quality and value to the customer.
2. Source: It means processes that procure goods and services to meet planned or actual demand. This part of SCM consists of selecting right suppliers that will deliver the good and services that need to create your product. Developing a set of pricing, delivery and payment process with supplier is important. Also this will also take care of managing the inventory of goods, and services you receive from your suppliers, including receiving shipping, verifying them, transferring them into various facilities and authorizing supplier payment.
3. Make: This is basically a step where your company starts fulfilling the request or BUILT for products into finished state to meet planned or actual demand. Schedule activity necessary for production, testing, packaging and preparation for delivery.
4. Deliver: This is also called Logistic Process. This is the processes that provide finished goods and services to meet planned or actual demand, typically including order management, transportation management, and distribution management.
5. Return - This is real pain of SCM model, which defined as processes associated with returning or receiving returned products for any reason.
Typical model can be best described as:
scmmodel
purpWHO IS THE STAKEHOLDER OF SUPPLY CHAIN
These are considered as stake holder of SCM:
  • Customers
  • Your Company
  • Design Partners
  • Material Suppliers
  • Contract Manufacturers
  • Logistic Providers
red1WHAT ARE DRIVERS OF THE SUPPLY CHAIN?
These are the main drivers :
  • Production
  • Inventory
  • Location
  • Transportation
  • Information
1. Production
This driver addressing these questions: what products does the market want? How much of which products should be produced and by when?
This activity includes the creation of master production schedules that take into account plant capacities, workload balancing, quality control, and equipment maintenance.
2. Inventory
This driver addressing these questions: What inventory should be stocked at each stage in a supply chain? How much inventory should be held as raw materials, semi finished, or finished goods?
The primary purpose of inventory is to act as a buffer against uncertainty in the supply chain.
3. Location
This driver addressing these questions: Where should facilities for production and inventory storage be located? Where are the most cost efficient locations for production and for storage of inventory? Should existing facilities be used or new ones built?
Once these decisions are made they determine the possible paths available for product to flow through for delivery to the final consumer.
4. Transportation
This driver addressing these questions: How should inventory be moved from one supply chain location to another? Air freight and truck delivery are generally fast and reliable but they are expensive. Shipping by sea or rail is much less expensive but usually involves longer transit times and more uncertainty.
5. InformationThis driver addressing these questions: How much data should be collected and how much information should be shared?
Timely and accurate information holds the promise of better coordination and better decision making. With good information, people can make effective decisions about what to produce and how much, about where to locate inventory and how best to transport it.
oraGET FAMILIAR WITH TOP 10 TERMS, DEFINITIONS AND TERMINOLOGY IN SCM
f1Master Demand Schedule - MDS
The MDS is a consolidation of demand by product and time bucket
f2Master Production Schedule- MPS
The MPS is a statement of supply required to meet the demand for the items contained in the MDS. The master production schedule defines the anticipated build schedule for all products. The master production schedule also provides the basis for order promising (ATP) function
f3Material Requirements Plan-MRP
The Material requirements planning (MRP) calculates net requirements from gross requirements by evaluating:
  • The master schedule
  • Bills of material
  • Scheduled receipts
  • On-hand inventory balances
  • Lead times
  • Order modifiers
f4Advanced Supply Chain Plan- ASCP
Constrained Based and optimized version of MRP
f5Planned Order
Automatically suggested action from planning engine
f6Consumption
The process of "relieving" the forecast to prevent double counting of demand
f7Drop Ship
Having an order ship directly from the vendor to the customer without physically being in your inventory.
f8Vendor Managed Inventory- VMI
The process of giving the vendor the authority and visibility to determine what your inventory should be
f9Customer Owned Inventory- COI
Where you are managing the customers inventory on your premises and supply as required
f10Work Order/Sales Order
The request that you received from the customer for fulfilling there demand.
greSIMPLE PLANNING CYCLE WITHIN AN ORGANIZATION
A typical planning cycle would start by loading the sales orders, forecast and other demand such internal orders into the master demand schedule (MDS). That demand statement would then be used as the schedule that drives the Master Production Schedule (MPS) . Take a note in regular MRP implementations the MPS is used as the schedule for ATP. Once the MPS is reviewed and updated is used as the schedule to drive the MRP process. The result of the MRP process is planned orders and exception messages. When released from MRP the planned orders for "buy" items become requisitions or purchase orders in the purchasing module and the "make" items become discrete jobs in the Work In Process Module. Once the finished goods are received into inventory it is shipped to satisfy customer orders.
PlanningwithinOrgnization
Scenario I :Sales Order - Forecast Planning Cycle
Forecast Planning
This is the scenario where normally we are building to stock and satisfying sales order demand from stock. Here you will see the difference as planned orders are released to become purchase requisitions for components and work orders for sub assemblies and finished goods. The finished goods are then shipped to satisfy the sales orders.





Scenario II : Planning - Procurement Cycle
ProcurementCycleIn the Planning-Procurement cycle we normally start where the first part of the planning cycle is complete and we have a planned order for a buy item from MRP. The planned order is released and becomes a requisition or purchase order in the purchasing module. A purchase order is then created from the requisition and sent to the vendor. The vendor would supply the materials. The materials would be received into inventory and the purchase order would be closed.



Scenario III :Planning - Drop Ship Cycle
In the Drop Ship cycle the process is as follows:
  • A sales order is received from the customer.
  • After the sales order is entered a process is run that creates a purchase order that matches the sales orders
  • The item, quantity and required date information on purchase order matches that information on the sales order.
  • The ship to address on the purchase order is the ship to address of the customer.
  • The vendor ships the product directly to your customer. Once the vendor ships the product you receive" the purchase order and that creates the shipping transaction to satisfy the sales order.
  • Matching accounting transactions complete the process
DropShipmentCycle
You can also see technical details for drop ship cycle in my earlier post.
Scenario IV :Planning - WIP Cycle
In the Work In Process cycle after the planning cycle is complete a planned order is released to create a discrete job. Material/components is issued the job or back flushed from inventory. The job is completed from Work In Process to Inventory.
wipcycle
Scenario V : Planning - Outside Processing Cycle
With Outside Processing you could be buying a service, an item or capacity from an outside vendor. The setup for each of these scenarios will be described in the training sessions to follow, however they all follow a similar process. A routing with an outside processing operation is setup.
After the planning cycle is complete a planned order is released to create a discrete job. Once the Discrete job is moved to a outside processing operation, a purchase requisition is triggered. The requisition is imported to Purchasing and a purchase order is created. The details of the discrete job such as job number, assembly number and quantity is tied to the purchase order. The purchase order is sent to the vendor. When the purchase order is received its destination will be shop floor and the assembly will be returned to the next operation on the work order.
OutsideProcessing
This make an end of this discussion. In Next post we will see what are the different subsystem SCM will have and what are the modules which comes under SCM Implementation. Any comment is welcome :)

Supply Chain Management Basic

This article is an easy guide for Techno-functional consultant to understand SCM from Implementation as well as Oracle Application product Prospective.Lets start the topic with some of high points of earlier post .
  • As mention in earlier post a Supply Chain is a network of retailers, distributors, transporters, storage facilities and suppliers that participate in the sale, delivery and production of a particular product.
    • Make a note a supply chain is product specific, not company specific
  • Supply chain management (SCM) is a systematic approach to manage the entire flow of information, materials, and services from raw material suppliers through factories and warehouses to the end customer.
  • Moreover , SCM involves the flows of material, information and finance in a network consisting of customers,suppliers, manufacturers, and distributors.
  • You should be clear with Flow that SCM can manage :supply Chain Flow
    • The flow of actual materials, the top middle bars
      • From suppliers : flows of raw materials, intermediate products, finished goods
      • Reverse material flows : returns, repairs, servicing, recycling, disposal
    • and the information flows
      • From suppliers : manufacturing capacity, delivery schedules, promotions they have going
      • Reverse flows : sales, orders, inventory, quality, promotions
    • And finally, there are financial flows:
      • From suppliers: Credits, consignment, payment terms, invoice
      • Reverse Flows : payments, consignment
  • Supply Chain Management is the management of the entire value-added chain, from the supplier to manufacturer right through to the retailer and the final customer.
  • SCM has three primary goals: Reduce inventory, increase the transaction speed by exchanging data in real-time, and increase sales by implementing customer requirements more efficiently
  • The need for SCM is because effective Supply Chain Mgt. is the next logical step towards increased profits and market share.
  • Supply Chain Management (SCM) in line manager prospective is "let's-keep-things-moving-efficiently".

Advance Shipping Notification Cancel Process


Script to get the ASN line against PO:

 There are two scenarios possible when you take receipts against these ASN shipments:

•          When these ASN shipment line are received against Purchase orders, it creates duplicate records in the rcv_shipment_lines table, which shows up as an expected receipts in ASCP, though they are already been received against these corresponding Purchase orders.

•          When these ASN shipment line are received against ASN, it does not create any duplicate records in the rcv_shipment_lines table and hence unprocessed records doesn’t get piled up in Receiving tables and hence the expected receipts shows the correct picture in ASCP planning.

(SELECT rsh.shipment_header_id
  FROM mtl_supply ms,
       rcv_shipment_lines rsl,
       rcv_shipment_headers rsh,
       po_line_locations_all poll
 WHERE ms.supply_type_code = 'SHIPMENT'
   AND rsl.SHIPMENT_LINE_STATUS_CODE = 'EXPECTED'
   AND ms.shipment_line_id = rsl.shipment_line_id
   AND rsl.shipment_header_id = rsh.shipment_header_id
   AND rsh.asn_type = 'ASN'
   AND nvl(poll.closed_code, 'OPEN') in ('CLOSED FOR RECEIVING', 'CLOSED', 'FINALLY CLOSED')
   AND ms.po_line_location_id = poll.line_location_id
   AND poll.quantity <= nvl(poll.quantity_received, 0))

   AND SHIPMENT_LINE_STATUS_CODE = 'EXPECTED')

DECLARE
x_vendor_id NUMBER;

CURSOR rsls IS
SELECT * FROM RCV_SHIPMENT_LINES 
 WHERE shipment_header_id IN 
(SELECT rsh.shipment_header_id
  FROM mtl_supply ms,
       rcv_shipment_lines rsl,
       rcv_shipment_headers rsh,
       po_line_locations_all poll
 WHERE ms.supply_type_code = 'SHIPMENT'
   AND rsl.SHIPMENT_LINE_STATUS_CODE = 'EXPECTED'
   AND ms.shipment_line_id = rsl.shipment_line_id
   AND rsl.shipment_header_id = rsh.shipment_header_id
   AND rsh.asn_type = 'ASN'
   AND nvl(poll.closed_code, 'OPEN') in ('CLOSED FOR RECEIVING', 'CLOSED', 'FINALLY CLOSED')
   AND ms.po_line_location_id = poll.line_location_id
   AND poll.quantity <= nvl(poll.quantity_received, 0))
   AND SHIPMENT_LINE_STATUS_CODE = 'EXPECTED';


BEGIN
FOR c1_rec IN rsls LOOP

SELECT vendor_id
INTO x_vendor_id
  FROM po_headers_all
 WHERE po_header_id = c1_rec.po_header_id;

/*SELECT TO_DATE(end_date,'DD-MON-RR')
INTO X_TRX_DATE
    FROM org_acct_periods_v
   WHERE organization_id=c1_rec.to_organization_id
   AND STATUS= 'Open';*/

INSERT INTO RCV_TRANSACTIONS_INTERFACE 
(INTERFACE_TRANSACTION_ID,
GROUP_ID,
SHIPMENT_HEADER_ID,
SHIPMENT_LINE_ID,
SHIP_TO_LOCATION_ID,
PRIMARY_QUANTITY,-- Add
PRIMARY_UNIT_OF_MEASURE,-- Add
VENDOR_ID,
VENDOR_SITE_ID,--Add
TO_ORGANIZATION_ID,
PO_HEADER_ID,
PO_LINE_ID,
PO_LINE_LOCATION_ID,
PO_RELEASE_ID,
PROCESSING_STATUS_CODE,
TRANSACTION_STATUS_CODE,
CATEGORY_ID,-- Add
PROCESSING_MODE_CODE,
INTERFACE_SOURCE_CODE,
AUTO_TRANSACT_CODE,
TRANSACTION_TYPE,
SOURCE_DOCUMENT_CODE,
RECEIPT_SOURCE_CODE,
DESTINATION_TYPE_CODE,
CREATION_DATE,
LAST_UPDATE_DATE,
TRANSACTION_DATE,
LAST_UPDATED_BY,
CREATED_BY,
LAST_UPDATE_LOGIN,
QUANTITY,
UNIT_OF_MEASURE,
EMPLOYEE_ID,--Add
--VALIDATION_FLAG,
ROUTING_HEADER_ID,--Add
LOCATION_ID, -- Add
ITEM_ID, --Add
ITEM_DESCRIPTION, --Add
ORG_ID --Add
)
SELECT
rcv_transactions_interface_s.nextval,
RCV_INTERFACE_GROUPS_S.currval,
SHIPMENT_HEADER_ID,
SHIPMENT_LINE_ID,
SHIP_TO_LOCATION_ID,-- Add
quantity_shipped,--Add
PRIMARY_UNIT_OF_MEASURE, --Add
x_vendor_id,
NULL,--Add
TO_ORGANIZATION_ID,
PO_HEADER_ID,
PO_LINE_ID,
PO_LINE_LOCATION_ID,
'',
'PENDING',--PROCESSING_STATUS_CODE
'PENDING', --TRANSACTION_STATUS_CODE
category_id, -- add
 'BATCH',  --PROCESSING_MODE_CODE
'RCV', --INTERFACE_SOURCE_CODE
'CANCEL', --AUTO_TRANSACT_CODE
'CANCEL',  --TRANSACTION_TYPE
'PO',  --SOURCE_DOCUMENT_CODE
'VENDOR', --RECEIPT_SOURCE_CODE
 'INVENTORY', --DESTINATION_TYPE_CODE CHANGE TO ''RECEIVE'
  SYSDATE,
  SYSDATE,
  SYSDATE,
1,
1,
1,
quantity_shipped,
unit_of_measure,
employee_id,-- Add
--'Y',
routing_header_id,-- Add
deliver_to_location_id, -- Add 167
item_id,--Add
ITEM_DESCRIPTION, --Add
103 --Add
from rcv_shipment_lines where shipment_line_id = c1_rec.shipment_line_id;

END LOOP;
COMMIT;

END;

Run the >Purchasing Super User>Receiving Transaction Processor(Group_id) as parameter from RCV_TRANSACTION_INTERFACE table it should be unique for all the ASN line which are going to process at a time.