Setup MRP - Material Requirements Planning in Oracle EBS R12

By -

 Setting up Master Scheduling/Material Requirements Planning (MRP) in Oracle E-Business Suite (EBS) R12.3 involves several configuration and master data setup steps.

 Here's a step-by-step guide to set up Master Scheduling/MRP in Oracle EBS R12.3:


Step 1: Define Organizations


Navigation: Inventory > Setup > Organizations > Organizations

Define the organization where you will perform Master Scheduling/MRP activities.


Step 2: Define Item Master


Navigation: Inventory > Items > Master Items

Create item master records for each item you want to include in the MRP planning.


Step 3: Set Up Item Attributes


Navigation: Inventory > Items > Organization Items

Set up item attributes such as lead time, safety stock, lot size, and planning method for each item in the organization.


Step 4: Define BOM (Bill of Materials)


Navigation: Bills of Material > Bills > Bill of Material

Create BOMs to represent the list of components required to manufacture an assembly.


Step 5: Define Routing


Navigation: Bills of Material > Routings > Routings

Define routings to specify the sequence of operations required to manufacture an assembly.


Step 6: Set Up Master Scheduling/MRP Parameters


Navigation: Master Scheduling/MRP > Setup > Planning > Parameters

Define MRP planning parameters, such as planning horizon, safety stock days, etc.


Step 7: Set Up Master Scheduling/MRP Profile Options


Navigation: System Administrator > Profile > System

Set up profile options specific to Master Scheduling/MRP.


Step 8: Set Up Planner Codes (Optional)


Navigation: Master Scheduling/MRP > Setup > Planning > Planner Codes

Define planner codes to categorize planners or planning responsibilities.


Step 9: Set Up Planning Time Fence


Navigation: Master Scheduling/MRP > Setup > Planning > Planning Time Fence

Define the planning time fence to control the horizon within which MRP will not automatically change the planned orders.


Step 10: Run Master Scheduling/MRP


Navigation: Master Scheduling/MRP > Launch > Single Plan

Run the Master Scheduling/MRP process for the organization and set of items.


Step 11: Review MRP Output


Navigation: Master Scheduling/MRP > View > Planned Orders

Review the MRP output, including planned orders, purchase requisitions, and recommended order quantities.


Step 12: Review Exception Messages (Optional)


Navigation: Master Scheduling/MRP > View > Exception Messages

Check for any exception messages generated during the MRP run and take appropriate actions.


Step 13: Convert Planned Orders to Purchase Requisitions (Optional)


Navigation: Master Scheduling/MRP > Planning > Order Recommendations

Convert planned orders to purchase requisitions or internal requisitions, if required.


Comments

Post a Comment

Popular posts from this blog

Oracle DBA Queries

By -
 Useful Queries for Checking Concurrent Requests and Programs  Hi DBAs, As an Apps DBA we have to monitor the Concurrent jobs status and details frequently,This can be done with the help of the below queries. -- Concurrent Program Queries for Apps DBA: -- Query 1:For checking the locks in concurrent jobs  SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,inst_id,id1, id2, lmode, request, type FROM gV$LOCK  WHERE (id1, id2, type) IN (SELECT id1, id2, type FROM gV$LOCK WHERE request>0) ORDER BY id1,request; -- Query 2:For checking the concurrent programs running currently with Details of Processed time-- and Start Date  SELECT DISTINCT c.USER_CONCURRENT_PROGRAM_NAME,round(((sysdate-a.actual_start_date)*24*60*60/60),2) AS Process_time,  a.request_id,a.parent_request_id,a.request_date,a.actual_start_date,a.actual_completion_date,(a.actual_completion_date-a.request_date)*24*60*60 AS end_to_end,  (a.actual_start_date-a.request_date)*24*60*60 AS lag...
Read more

Interview Questions and Answers on O2C (Order to cash) in Oracle EBS R12

By -
  Order-to-Cash (O2C) Basics: What is the Order-to-Cash (O2C) cycle, and what is its significance in Oracle EBS? Answer: The O2C cycle represents the end-to-end process of receiving customer orders, processing them, delivering goods or services, and receiving payments. It is a critical business process in Oracle EBS for revenue generation. What are the key components of the O2C cycle in Oracle EBS? Answer: The key components include Order Management, Pricing, Shipping, Invoicing, Receivables, and Cash Management. Order Management: Explain the role of Order Management in the O2C cycle, and how does it handle order creation, modification, and processing? Answer: Order Management is responsible for creating, modifying, and processing customer orders. It ensures that orders are accurate, fulfillable, and meet customer requirements. What are the various order types in Oracle Order Management, and how are they used within the O2C cycle? Answer: Order types include standard orders, sa...
Read more

Setup of BOM (Bill of Material) on Oracle EBS R12

By -
Setting up Bill of Material (BOM) in Oracle E-Business Suite (EBS) R12.3 involves several configuration and master data setup steps. Here's a step-by-step guide to set up BOM in Oracle EBS R12.3: Step 1: Define BOM Parameters Navigation: Bills of Material > Setup > Parameters Define BOM parameters, such as the default BOM type, effective date, and organization. Step 2: Define BOM Item Attributes Navigation: Bills of Material > Setup > Attributes Define BOM item attributes, such as item categories and planning attributes. Step 3: Define BOM Structures Navigation: Bills of Material > Setup > BOM Structures Define BOM structures to represent different types of BOMs (e.g., Engineering, Production). Step 4: Create Bill of Material (BOM) Navigation: Bills of Material > Engineer > Bills > Bills Create the BOM by entering the header data (e.g., assembly item, BOM type) and adding the components along with their quantities and item attributes. Step 5: Define Compo...
Read more