The planning engine calculates the difference between the earliest possible completion time and supply duration to populate this field. For more details on Allocated ATP, see Oracle Global Order Promising. MRP: Plan Revenue Discount Percent profile option value. Click Execute to run the query. Name of the assembly. You can enter either the complete item name or a partial name with a wildcard. Note: This can be done only when the Orders view is displaying all supplies. [Right-click] on the bar in the right pane. The Inventory Turns graph is displayed at the following nodes: The On-time Delivery Percentage graph is displayed at the following nodes: The Planned Utilization percentage is available at the following nodes: This graph compares the actual margin to the target values collected from the source. The right-click pop-up menu displays the following options to navigate to windows that display specific information: You can navigate to the Components window from the Items window. You can view and compare items that belong to two different categories in the horizontal plan. The type of exception determines what buttons are available. You can set the firm supply allocation window in these ways: Site level: Use profile options MSO: Firm Supply Allocation Window (Backward days) and MSO: Firm Supply Allocation Window (Forward days) for all items. Supplies in the second supply window [day 2] are pegged in the following order: Firm planned order of quantity 5 on day 2 and demand of quantity 100 on day 3, Non-firm planned order of quantity 35 on day 2 (for partial quantity 10) and demand of quantity 100 on day 3, Non-firm planned order of quantity 35 on day 2 (for partial quantity 25) and demand of quantity 100 on day 4, Supply in the third supply window [day 3] is pegged as non-firm planned order of quantity 75 on day 3 and demand of quantity 100 on day 4. Use to navigate to the Exception Details window. The Exception Details window appears. Firm Jobs: Enables the release of the Firm status when you release the work in process jobs. You can use global forecasting for consuming forecast without any reference to a shipping organization. It scans backwards the number of days in the site or item-specific firm supply allocation window (profile option MSO: Firm Supply Allocation Window (Backward days) and finds the first firm supply quantity to peg the demand to. If the organization has a receiving calendar and Dock Date is a non-workday in the receiving calendar, moves it to the previous working day on this calendar. The following table lists the information displayed in the Resource Availability Summary window. Select the Firm check box for the order line that you wish to firm. The first window starts at the first demand date and the last window ends at the end of the planning horizon. Within the same resource, users can drag and drop activities to earlier or later points in time. The detailed information related to the selected item appears in separate context windows. Alternatively, you can select a supply or a set of supplies and enter the Gantt chart. The Public Queries node comprises of Item, Resource, Exception, and Supplier. Navigate to Supply Chain Plan > Workbench to view plans by supplier organizations. The date on which the last unit belonging to a line is completed, The date on which the last unit belonging to a line is started. Right-click in the Queries tabbed pane to display the pop-up menu. In addition, the history of the navigation is cleared when you select a different supply or demand line from the supply and demand region of the Supply/Demand window. Items: For details on the Items window, see Items Window. Choose [right-click] > Firm/Unfirm Operation > [Firm option]. Choose a plan for which to view exception messages. The exception details data is not stored in a simple way. BOM enforce Integer Requirements Parameter, Components required at the operation sequence, Network routing primary or alternate path, Process manufacturing batch minimum quantity, Process manufacturing batch maximum quantity, Process Manufacturing item processing cost, [Select any field] > [right-click] > Gantt Chart, Select a resource>[right-click]>Gantt Chart, View Alternate/Primary Resource for this operation, Load Alternate/Primary Resource for this operation. The following table lists the information displayed in the Resource Availability window: You can make changes to the resource availability in the Update Resource section. The history of your forward and backward navigation is cleared when you select a different node from the Navigator or the Query result window. You can then run the online planner to see the results of adding capacity for this date. This indicates the number of days (forward) when a forecast can be consumed by sales orders. Select Key Indicators in the pop-up menu. ORACLE APPS COMMUNITY > Tutorial > Supply Chain Planning > Oracle Supply Chain Planning > Oracle Advanced Supply Chain Planning Tables. Run Blitz Report from the new menu in the PWB, or instead use the Navigator / Top 10 list. Hide Dependant Demands and Show Dependant Demands toggle icon: This is a toggle icon and can be used to switch between hide and show of dependent demand pegging lines. The following table lists the information displayed in the Resource Requirements window. Implement as a work order or a purchase requisition (editable). Required resource hours based on the routing requirement, Assembly quantity of the actual or planned make order, Actual or planned operation sequence number for the requirement, Actual or planned operation resource sequence number for the requirement. At a glance, you can see how the plan performs relative to the following measures: You can choose to see any four of these measures together. The Material Plan tab appears as the default tab. Category: Oracle EBS R12 Training. To see safety stock levels calculated but Oracle Advanced Supply Chain Planning or Oracle Inventory Optimizaion, see Horizontal Plan. The planning engine pegs in several ways (pegging modes). Select to navigate back and forth between prior results from pegging actions taken within the Orders view. Select [right-click] > Supplier Information. Interorganization transfer quantities or quantities shipped from suppliers (after the customer receives the advanced ship notice). Change the prompt or the heading of the field. You can specify whether or not you want the graph to be shown. The planning engine can split planned orders to peg to different transient safety stock levels. This view is useful if there are a large number of available units per resource and if the units available vary with time. The first section includes the following information about the product family items: The order types associated with the product family appear against the product family node in the first section. Place your cursor over the operation you wish to firm. You can select a non-workday. Set the profile MSC: Minimize Workorder crossovers during reschedules to Yes to avoid pushing any supply forward to complete a work order even if there is some excess. To display the Find window, select View>Find. Routings for phantom items are used to generate resource requirements. You can specify a customer and site to view the substitution chain for the item. This field stores the original demanded item. You can use the following to navigate to various context windows for the selected item: The Plan tabbed pane displays all available plans for your organization whereas the Queries tabbed pane displays filtered information. Drag the right end of the activity bar to a desired end date. For example, you might want so see information a Horizontal Plan row in an alternate unit of measure. For example, you can graph either planned orders, gross requirements, or both. The following button is available in this window: Supply: Click this if you want to view the pegging information for supplies (Supply window). MSC: Multiplier to Derive Supply Allocation Window: 1.2, Cumulative manufacturing lead-times for item A101: 12 days, Cumulative manufacturing lead-times for item A102: 20 days, Firm supply allocation window for item A101: 15 days (12 * 1.2 = 14.4), Firm supply allocation window for item A102: 24 days (20 * 1.2). A preference set is applicable to all types of horizontal plans. If the planning engine determines that the material availability date is: D22, then both the earliest ship date and schedule ship date are updated to D22. This includes supplies at various levels in the bill of material. Is it because of a resource, material, or transportation resource constraint? You can choose the levelsite, responsibility, or user. The horizontal plan information is displayed in a pivot table that enables you to drill down from aggregate to periods to weeks to days. The planning engine marks the demand quantity as expired if the demand is not met within specific number of days. Supply-Demand Pegging Sajeev Nair Principal Consultant, Oracle VCP Rapidflow Apps Inc.. Information About the Author This document is prepared by Sajeev Nair, from RapidflowApps Inc. Sajeev Nair has 14 years of industry experience in the Supply Chain and Manufacturing domain, having worked as a consultant in many complex supply chain IT projects involving Oracle VCP . The Planner Workbench enables you to filter specific information in a plan. For the selected supply (or supplies), if pegging actions are invoked, the Gantt Chart displays all the supplies that peg to the selected supply. An assembly is an item that has a bill of material. Specify the criteria in the Criteria box. We use cookies to let us know when you visit our websites, how you interact with us, to enrich your user experience, and to customize your relationship with our website. Create forecasts for VMI items and publish them to your suppliers. This check box is selected by default. On the sales order, the arrival set name designates lines that should arrive together at the customer site. Firm supplies are not sorted on any given date. This view also serves as the indented bill of materials. The Resource Availability Summary window appears. A demand pegging to an expiring lot must have its demand date earlier than the lot expiration date; therefore, some expiring lots may not peg. 3. The first window starts at the first supply availability date and the last window ends at the end of the planning horizon. Indicates the priority of a demand. Once the organization has been defined, you can create the reference setup information for planning purposes in this organization like items, bills of material, routings, resources, and operations. Choose tabs to access different types of information. The system does not allow the zoom level to be less than a day (minutes and hours are disabled). The Routing window displays the following information, but it does not display information for flow routings: Based on the context, specific buttons may be available in the Routing Operations window. Drill-down to the item level and right-click the item. Displays upstream supplies and downstream supplies relative to the selected supply or demand. For long-running processes, you can segment the material completions from a supply over the time of the process (supply segments). In the right pane, the operation's shading changes to reflect that it is updated. The quantity 10 on day 7 pegs to the planned order quantity 10 consumed on day 8. The related activity appears in the right pane. The demand for quantity 100 on day 1 to the purchase requisition for quantity 20 on day 2, then to the planned order for quantity 50 on day 2, and then to the work order for quantity 30 on day 3. The planning engine pegs each item after the netting process. The process performs the pegging for these demands immediately following the item substitution: MSO: Firm Supply Allocation Window (Forwards Days), MSO: Firm Supply Allocation Window (Backwards Days), MSO: Use Firm Supplies Before Creating Planned Orders. In the View by Items mode, select an item and navigate to the Horizontal Plan window. The planning engine calculates this based on the engineering change order for the item. Add Day: Add resource capacity for a non-working day. You can right-click and select an option to view information about the multiple nodes you selected. Type of order. You always can block or delete cookies by changing your browser settings and force blocking all cookies on this website. The pass ends when the demand is completely pegged to firm supplies or all firm supplies in the firm supply allocation windows are exhausted. This refers to the quantity of the make order that is complete and is ready to be moved. You can select a non-workday. You can use the Show and Hide right-click menu options to view specific order types. You can save settings for Item, Resource, Transportation, and Supplier types of horizontal plan. The Resource Activities view only displays the portion of the planning horizon that is scheduled to the minute level of granularity. The horizontal plan information is displayed in a pivot table enabling you to drill down from years, to periods, to weeks, to days. It provides a limited amount of prioritization at the day level (the window size is always one day). Refer the following table for right-click menu options for various node types in view by Resources. It is the earliest time in which the resource requirement can be completed. The Supply/Demand window displays information about supplies and demands and shows pegging information. Do not select a category set with flag Allow multiple item category assignments selected. Click Save to save the query. Profile option MSC: Use FIFO Pegging: Yes, Plan option Peg Supplies by Demand Priority: Cleared. If you do not enter a value, enter 0, or enter a negative value, the planning engine uses value 1. Related exceptions appear in the Exception Details window. The fields on the Resource Activities view type are similar to the Orders view type with the exception of the Display Tolerances field. The planning engine calculates this as the sum of work in process, purchase orders, purchase requisitions, in transit, in receiving, and payback supply. Exception details display pre-seeded default folders (combination of various key columns) based on exception type. You can adjust the width and height of the data cells as per your requirement in the Planner Workbench. Check to enable permanent hiding of message bar and refuse all cookies if you do not opt in. A plan can also be compared with its archived version. Based on the context, specific buttons are available in the Routing Operations window. The planning engine calculates this as follows: The planning engine calculates this to indicate the end of the scheduling window for those resource requirements that allow sufficient time for the upstream activities to be scheduled. This chapter covers the following topics: The Planner Workbench is a powerful graphical tool that lets you perform advanced simulation, review plan performance, and take actions based on system recommendations. Demand priorities are in parentheses and pegged entities are connected by arrows. Demand resulting from a borrow or a payback transaction in Oracle Project Manufacturing. The following table provides a description of the fields displayed in the Sourcing tabbed pane: The following table provides a description of the fields displayed in the Effectivity Dates tabbed pane: The following table provides a description of the fields displayed in the Assignment Information tabbed pane: The Sources window details information about sourcing and assignment associated with items. Check each type of plan information you want displayed in your supplier capacity plan. None or Null: The sales order line is not firmed. Existing requisitions without corresponding purchase orders, including internal requisitions. This refers to the model or the option class to which the item belongs. For an MRP plan with an MPS plan as a demand schedule, the MRP item may peg to a demand in the MPS plan. Enter either a complete item name or a partial item name with a wildcard and select OK. The planning engine performs priority pegging logic using transient safety stock levels and supplies. Not used in Oracle Advanced Supply Chain Planning. The Plan tabbed pane displays a list of plans for an organization. Unconstrained Latest Possible Completion Time. Based on your selection, the planning engine saves the query either as a Personal Query or a Public Query. The Network Routing window displays the following information: The Where Used window provides information about the items usage. Location refers to the supplier site or organization location. This refers to the supply or the demand type. You can select Item to create queries that filter information related to items. Items that you have not assigned to a category in this category set do not appear in Planner Workbench. The availability of the KPIs depends on the type of plan chosen. An end item is applicable for option class and optional items. It lets you troubleshoot exceptions arising from resource or material constraints; overloaded or underloaded resources; absenteeism, or machine downtime. In this case, specify Make or Buy, Equals, and Buy in the Criteria, Condition, and From fields, respectively. Comparison of the constrained earliest and planned start and completions times along the various activities on the critical path, which enables you to identify the key bottlenecks on the critical path. You can specify the query name in the Auto Execute Query field. You may have multiple preference sets for a horizontal plan. Select the Notifications check box for the plan that you want to publish result for. The objective is to explain the cause and effect of the problems. Yes indicates that the supply is for a VMI-enabled item. A negative value indicates that the order is rescheduled to an earlier date. The planning engine displays the numbers in the horizontal plan as an aggregate of all organizations. In case you want to share the query with others planners, save the query as Public query. Source organization from the sourcing rule, Supplier from the sourcing rule or bill of distribution, Supplier site from the sourcing rule or bill of distribution, Rank from the Sourcing Rule or bill of distribution, Ship Method from the sourcing rule or bill of distribution, The planning engine calculates the allocated quantity in the following manner, Approved Supplier List processing lead-time, Approved Supplier List minimum order quantity, Approved Supplier List fixed lot multiplier, Approved Supplier List supplier capacity calendar, The planning engine calculates the capacity accumulation date based on the Supplier Capacity profile option. To use pegging you must enable it for the items and for the plan. The planning engine calculates the difference between the suggested due date and the plan launch date to populate this field. When working in the Items or Organizations category, drill down from the Vertical Plan to view supply/demand details. The possible values are: After you firm a supply, you can specify a new date to change an existing planned order, a forecast, an MDS demand, a manual MDS demand, or a sales order. An instance is a database and a set of applications. In standard pegging, the planning engine uses 1 as the value for MSO: Demand Window Size and MSO: Supply Window Size and ignores the entered values. They are safety stock levels with ending effectivity dates. This option provides you the horizontal plan for each organization that you select. The Supplier Capacity window displays the following information: The Supplier Capacity window has two tabs: A supplier may have different capacity on different dates. Click on the different category headings to find out more. The identifier assigned to the task in a project belonging to a planning group. The columns are dependant on the view that is selected. However, the planning engine does not save a copy of the Supply Demand window if you change the context in the supply/demand region of the window by firming a supply, querying a subset of records, or refreshing supply/demand. You can view the details of the available capacity in the Resource Availability window. On the sales order, the ship set name designates lines that should ship together. You can navigate to the Supply/Demand window from various node types such as items, organizations, plans, departments, and planning groups in the Navigator. Specify the modified information: Provide a PL/SQL program unit with no parameters that. If your operating system does not support clipboards, you cannot copy the plan. This indicates the supply quantity that is available by the demand due date. For a given Supply Chain Plan, the report includes the relevant details about items, resources, gross requirements, scheduled receipts, planned orders, plan constraints, and exceptions in separate worksheets. Your suppliers can use the Planner Workbench - Supplier Administrator responsibility to view the following left-pane nodes and related right-pane tabbed regions in the Planner Workbench: The following table lists the right-click menu options available in Planner Workbench that your suppliers can use: If you model the supplier as a supplier in the Planner Workbench, this information appears in their Planner Workbench: Plans for which the supplier is modeled as a supplier, Categories and items associated with the supplier, Supply and demand information specific to the supplier. This results in increased lateness for the early demands. The properties for the supply order tab (only for the supply node) are: job number, job type, item, quantity, firm flag, suggest due date, ship date, need by date, unit number, project, task, alternate BOM, alternate routing, and time fence. Prioritize critical material and capacity resources. If you want to filter based on rolling dates, select Days From Today as the condition. Hide Operation/Resource and Show Operation/Resource toggle icon: This is a toggle icon and can be used to switch between hide and show operation and resource pegging lines. For more information, see Destinations Window. Select a date for which you'd like to add capacity. You can right-click an item in the Navigator, select BOM/Routing > Process Effectivity to navigate to the Process Effectivity window. In performing the pegging process, the planning engine selects demands and locates supplies to peg those demands to. It becomes a firm planned order. Click here to get started. You can view aggregate production plans in the Planner Workbench. Note: You can manually change the Implement Date in the Release Properties window to override the plan recommendations. Job Status: When Planner Workbench creates discrete jobs from planned orders, it assigns this status to the discrete jobs. Oracle ASCP addresses the following key supply planning issues: For example, if you want to retrieve all items that start with X, set the condition as Starts With and specify X in the From field. The product family to which the item belongs. The planning engine refreshes only the pegging region and creates the highlighted line in the pegging region as the root pegging line. Select a type of query from the Query Type drop-down menu to specify the information you want to filter. Because material availability is just as important as resource availability, it is shown within the Gantt to make rescheduling more accurate. You can tailor the user interface in the following ways: You can resize windows as with any windows-based application. *,MSI1.ITEM_NAME||' ('||MSI1 . The following right-click menu options are available from the pegging region: Pegging information is available in the pegging region of the Supply/Demand window. Personal Queries: You can save your query either as a Personal query or a Public query. The order of supplies for pegging to demand D1 is: Backward: S1, S2 and S3 randomly; OH; and S4. In this case, the planning engine always generates pegging. Choose [right-click] > Resource Capacity. To understand safety stock pegging, see Safety Stock Pegging in Pegging.