Using Backlog Management
Using Backlog Management
Using Backlog Management
21B
Oracle SCM Cloud
Using Backlog Management
21B
Part Number F39730-01
Copyright © 2011, 2021, Oracle and/or its affiliates.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected
by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate,
broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering,
disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report
them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then
the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed or
activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or
accessed by U.S. Government end users are "commercial computer software" or "commercial computer software documentation" pursuant to the
applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display,
disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated
software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle computer
documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The
terms governing the U.S. Government's use of Oracle cloud services are defined by the applicable contract for such services. No other rights are
granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for
use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware
in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe
use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks
or registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced Micro
Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle
Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and
services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible
for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable
agreement between you and Oracle.
The business names used in this documentation are fictitious, and are not intended to identify any real companies currently or previously in existence.
Oracle SCM Cloud
Using Backlog Management
Contents
Preface i
1 Introduction 1
Why You Use Backlog Management ......................................................................................................................................... 1
Overview of Backlog Management Processes ........................................................................................................................ 1
Integration with Other Cloud Services ..................................................................................................................................... 2
2 Planning Setups 3
How to Enable the Backlog Management Work Area ........................................................................................................... 3
Data Preparation and Planning Configuration ....................................................................................................................... 3
Access Tasks as Quick Actions on a Home Page .................................................................................................................. 4
Backlog Planning Options ........................................................................................................................................................... 5
3 Planning Processes 7
Key Actions on Orders ................................................................................................................................................................. 7
Run Plans ........................................................................................................................................................................................ 8
Review Planning Results ............................................................................................................................................................ 14
How You Troubleshoot Problems in Planning and Analytics ............................................................................................. 19
Release Planning Results ........................................................................................................................................................... 21
Preface
This preface introduces information sources that can help you use the application.
Help
Use help icons to access help in the application. If you don't see any help icons on your page, click your user image
or name in the global header and select Show Help Icons. Not all pages have help icons. You can also access the Oracle
Help Center to find guides and videos.
Watch: This video tutorial shows you how to find and use help.
Additional Resources
• Community: Use Oracle Cloud Customer Connect to get information from experts at Oracle, the partner
community, and other users.
Conventions
The following table explains the text conventions used in this guide.
Convention Meaning
boldface Boldface type indicates user interface elements, navigation paths, or values you enter or select.
monospace Monospace type indicates file, folder, and directory names, code examples, commands, and URLs.
i
Oracle SCM Cloud Preface
Using Backlog Management
Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website.
Videos included in this guide are provided as a media alternative for text-based help topics also available in this guide.
Contacting Oracle
ii
Oracle SCM Cloud Chapter 1
Using Backlog Management Introduction
1 Introduction
To change scheduled dates after identifying which orders are affected by changed supply availability, order managers
would have to first select orders in Order Management or in Global Order Promising and then simulate promising. This
is a manual, drawn-out process.
Users can also perform a variety of simulations to influence the planning results. For example, they can reprioritize
orders, decommit some orders, and even change attribute values to run a planning simulation without impacting the
actual scheduling information. Any updates to the actual scheduling information happen only when the user releases
planning results after backlog planning.
◦ You specify a demand priority rule on the basis of which the orders are prioritized.
◦ You can plan your entire backlog or you can use filters to plan by specific items, categories, and
organizations.
1
Oracle SCM Cloud Chapter 1
Using Backlog Management Introduction
◦ Using the Backlog Analysis UI, which tabulates results for each planned order. These results can be called
using a range of search criteria.
◦ Using the Backlog Analytics UI, which presents result statistical data in the form of graphs and infotiles.
3. Simulating and adjusting attribute values. After reviewing planned results, you can modify order attribute
values and replan those orders to see how fulfillment prospects vary. Here's what all you can do:
Until you release your Planned values from Backlog Management, they remain as simulations within the
application, and can't impact actual order scheduling.
Order Management Scheduled sales orders are collected from Order Management and planned in Backlog
Management. When backlog planning is completed and planning results for some orders
are released, the planning results automatically replace the scheduling information on these
orders in Order Management.
Global Order Promising Planning results on orders released from Backlog Management replace the scheduling
information on those orders in Global Order Promising in real time.
Supply Planning Planning results on orders released from Backlog Management replace scheduling information
on those orders in Supply Planning. This happens when demand data is refreshed during a
supply plan run.
2
Oracle SCM Cloud Chapter 2
Using Backlog Management Planning Setups
2 Planning Setups
For more information regarding how to opt in to features, refer to the Using Functional Setup Manager guide, Offering
Configuration chapter in the Oracle Help Center.
For more information regarding how to assign job roles to users, refer to the Securing SCM guide, Provisioning Roles to
Application Users chapter, in the Oracle Help Center.
Review the Supplies and Demands table in the Plan Inputs work area to verify that these orders have been
scheduled in Oracle Fusion Order Management.
2. Collect planning data using data collection tasks.
You can collect data from an Oracle Fusion source system or from an external source system. If your enterprise
uses Oracle Fusion Order Management, you collect scheduled sales orders and predefined sales order
attributes. If your enterprise uses an external source system, you can also collect unscheduled sales orders and
user-defined sales order attributes. To know more, Refer to the Collect Planning Data chapter.
3. Ensure that supply sourcing is set up.
3
Oracle SCM Cloud Chapter 2
Using Backlog Management Planning Setups
Review your sourcing rules, bills of distribution, and assignment sets using the related task links. If your
enterprise uses Global Order Promising, the same assignment set definitions should be used in Backlog
Management. To know more, Refer to the Sourcing rules, Bills of Distribution, and Assignment Sets chapter.
4. Ensure that the drop-ship validation organization has been defined.
If you plan to use drop-ship organizations in planning, use the Maintain Network Supply Model task to define
the drop-ship validation organization and the time zones used to determine transit times. To know more, refer
to the Maintain Supply Network Model chapter.
5. Define a demand priority rule.
Define the rules that prioritize orders for fulfillment based on rankings of order attributes. The order priorities
determine which demands have more access to supply. You can create multiple demand priority rules, and
alternate between rules to understand how planning results change. To know more, refer to the Demand
Priority Rules chapter.
6. Configure your backlog planning options.
Configure default parameters for your backlog planning runs. To know more, refer to the Backlog Planning
Options topic.
7. Ensure that all items are assigned to a backlog planning rule.
Define rules that determine what kind of supply can be used for demand fulfillment. You can configure supply
items to be available infinitely, available after a lead time, or available based on their supply type. Specify
whether these rules apply to items, organizations, item categories, or to item-organization combinations. If
your enterprise uses Oracle Fusion Global Order Promising, items will already be assigned to these rules. To
know more, refer to the Backlog Planning Rules chapter.
8. Ensure that planners and planning calendars have been set up or collected.
If your enterprise has set up calendar and planner data in other cloud services like Supply Planning and Global
Order Promising, then that data will be respected during backlog planning.
• You must have the applicable privileges associated with the task to see the task as a quick action on the
home page. Each quick action is secured by its related privilege or privileges. For example, if you have the
Manage Planning Sourcing privilege, then you should see the Manage Sourcing Rules task in the tasks panel
drawer in the work area. You should also see the task as a quick action on the Supply Chain Planning or Order
Management (in the case of Global Order Promising) home pages.
4
Oracle SCM Cloud Chapter 2
Using Backlog Management Planning Setups
• You must have access to the work area to see the associated manage preferences quick actions. For example,
you must have access to the Supply Planning work area to see the Edit Supply Planning Preferences quick
action.
• You can't navigate to any other UI or open other tabs. When you click a quick access link, the UI opens in the
page, but you aren't in a work area.
• You can only return to the Supply Chain Planning home page when you close out of a task that you initiated
from the Supply Chain Planning home page.
Planning Horizon in Days: This is a duration measured from the horizon start date. Demands with requested dates
within this horizon only are planned. So if the horizon start date is today and you specify 100 as the planning horizon
value, then the planning process will plan orders with requested dates that fall within the next hundred days only.
Horizon Start Date: It's the date from which the planning horizon is calculated. The default start date is the present
day. If you change it to a future date, then the horizon will be calculated from that day.
Assignment Set Name: The name of the assignment set that contains the sourcing rules and bills of distribution used
to implement your supply chain network. If your enterprise uses Oracle Fusion Global Order Promising, the assignment
set up for order promising should be used for backlog management. If you do change the assignment set, you must run
the Import Supply Chain Data for Backlog Management scheduled process.
Demand Priority Rule: This is the rule that the backlog planning process uses to prioritize orders for fulfillment. The
rule you specify is the default demand priority rule, which means that this rule is always used unless you specify another
one before taking plan run actions.
Past-Due Supply and Demand Considered in Days: This is a duration measured backward from the horizon start date.
When a demand's scheduled date or a supply's expected date falls prior to the horizon start date, this demand or supply
is termed past-due. The duration you specify determines how many days prior to the horizon start date a past-due
demand or supply is valid for to be considered by the backlog planning process. You can override the value specified
here while defining a backlog planning rule.
Demand Fulfillment Lead Time in Days: The number of days from the order creation date within which your
customer, by contract, expects the order's fulfillment. This value is used to calculate the fulfillment lead time date.
So if you specify 5 as the value, and the order creation date is 1/20/2020, then the fulfillment lead time date would
be 1/25/2020, assuming that your requested date is between 1/20 and 1/25. If your requested date is later than your
fulfillment lead time date, say 3/25/2020, then the fulfillment lead time date is considered to be the same as your the
requested date.
Supply Plans: The existing supply plans in Oracle Supply Planning Cloud that you want to source supply data from, to
get the most accurate supply picture. You can select multiple supply plans. If you don't select a supply plan, the backlog
planning process uses whatever supply data is available from the collection process. To know more, refer to the Planning
Processes chapter.
Category Set: This is a group of item categories used by the backlog planning process while assigning backlog
planning rules by category. The default value is GOP_Catalog. You can't edit this value on this page because it's derived
5
Oracle SCM Cloud Chapter 2
Using Backlog Management Planning Setups
from the profile MSC_SRC_ASSIGNMENT_CATALOG in Oracle Fusion Global Order Promising. Whenever the category
set value changes, you must run the Import Supply Chain Data for Backlog Management scheduled process.
6
Oracle SCM Cloud Chapter 3
Using Backlog Management Planning Processes
3 Planning Processes
Search Actions
Search for orders using search criteria, which include all order attributes. You can use the Add Fields action to include
attribute criteria that are hidden. You can also set up or save specific search results:
• Use the Manage Conditions action in the Search region to create a set of attribute-based search filters. Each
set is called a condition. Using a condition, you can filter the backlog to see search results only for orders that
meet your condition criteria.
• Use the Save action in the search region to save a particular search after giving it a name. This lets you
preserve search criteria and the results for those criteria, so that you can revisit this search using the drop-down
list of names in the Saved Search field.
7
Oracle SCM Cloud Chapter 3
Using Backlog Management Planning Processes
You can also run plans using a scheduled process. To know more, refer to the Run Plans section in this chapter.
Review Actions
The plan run ranks your orders in priority sequence on the basis of the demand priority rule. It also calculates and
displays planning results for your orders that correspond to scheduling and requested information. Here's what you
need to do:
• Review and compare Planned values with their corresponding Scheduled and Requested Attributes.
• Some rows represent sets, and the set name will be displayed for such rows. Use the Manage Set action to
review results for set's constituent lines.
• To view analytics for the planned orders, use the page-level Open action and open the Backlog Analytics graph.
To know more, refer to the Review Planning Results section in this chapter.
Because these are simulations within Backlog Management, they don't impact actual scheduling information that's
visible to your customers. To know more about these simulations, refer to the Simulate Changes to Attribute Values
section in this chapter.
Release Actions
When you're satisfied with the Planned values, you need to prepare them for release and then release them to the order
management system:
• Use the Save Planning Results action to save Planned values to the backlog planning data repository.
• Use the Mark for Release action on selected rows to indicate that they're ready for release.
• Use the Release Planning Results action to release them to your order management system.
You can also release planning results using a scheduled process. To know more, refer to the Release Planning Results
topic in this chapter.
Run Plans
8
Oracle SCM Cloud Chapter 3
Using Backlog Management Planning Processes
Related Topics
• Reservations in Supply Chain Planning
• Backlog Planning Options
9
Oracle SCM Cloud Chapter 3
Using Backlog Management Planning Processes
10
Oracle SCM Cloud Chapter 3
Using Backlog Management Planning Processes
• Make: Supply for the item that's made is created on the date of the planned order; the corresponding
component availability and resource requirements are reduced to keep the overall supply and demand
consistent.
• Transfer: Supply for the planned transfer item is created at the destination organization and while supply at the
source organization is simultaneously reduced.
• Buy: Supply for the planned transfer item is created at the receiving organization and while supplier capacity is
simultaneously reduced.
The planned make supply information is that 100 units of END_ITEM_1 need to be manufactured on 01/10, from 200
units of COMP_1 using 5 hours of RES_1, both of which need to be consumed by 01/05.
Item, Component, and Resource What Happens on 01/05/2021 What Happens on 01/10/2021
Backlog Management increases supply availability for the end item by 100 units, and reduces the component and
resource availability on the date they have been consumed.
11
Oracle SCM Cloud Chapter 3
Using Backlog Management Planning Processes
How It Works
Backlog Management reads the item's work definitions to check if components and resources are available to make this
item.
• If only one work definition is associated with the item, and components and resources are insufficient, Backlog
Management substitute components or alternate resource within the work definition when the primary
components or resources are insufficient.
• If alternate work definitions are also associated with the item, and the primary work definition doesn't account
for sufficient components and resources, Backlog Management will use the alternative if it allows for quicker
fulfillment. Alternate work definitions at item subassembly levels are also considered.
Conditions
To let Backlog Management consider alternate manufacturing setups, you must ensure that these conditions are met:
• The end item must be assigned to a backlog planning rule that uses the Supply Chain Availability Search mode,
with the Search components and resources setting enabled.
• For a resource to be considered, its Check Capable to Promise setting must be enabled from Oracle
Manufacturing Cloud. If your enterprise uses an external manufacturing application, this setting can be enabled
in the ScpResourcesImportTemplate FBDI file, using the Capable to Promise Indicator column.
Examples
Let's understand the three ways in which this feature helps fulfillment.
Let's say that 10 units of an item ITEM_1 are requested for 4/30/2021. ITEM_1 belongs to the sales order line SO_1. Let's
say that ITEM_1 has primary and alternate work definitions defined with these resource and component availability
details:
12
Oracle SCM Cloud Chapter 3
Using Backlog Management Planning Processes
WD_1 (Primary) Resource R1 is needed for 40 hours, and is 40 units of the component C1 are needed.
available for 100 hours. 100 units are available.
WD_1 (Primary) Resource R2 is needed for 40 hours, but is 40 units of the component C2 are needed.
unavailable. 100 units are available.
WD_2 (Alternate) Resource R1 is needed for 40 hours, and is 40 units of the component C1 are needed.
available for 100 hours. 100 units are available.
WD_2 (Alternate) Resource R7 is needed for 40 hours, and is 40 units of the component C2 are needed.
available for 100 hours. 100 units are available.
Because the primary work definition WD_1 doesn't account for sufficient resource availability, the planning process uses
the alternate work definition WD_2 to assume fulfillment by the requested date.
Let's say that 10 units of an item ITEM_1 are requested for 4/30/2021. ITEM_1 belongs to the sales order line SO_1. Let's
say that ITEM_1 has just one work definition defined, with these resource and component availability details:
Resource R1 is needed for 40 hours, 40 units of the component C1 are needed. 100 units are available.
but is available for just 15 hours.
Alternate resource ALT_R1 is available
for 60 hours.
Because R1 is available for just 15 hours, ALT_R1 is checked for availability. It is available for 60 hours. The planning
process then assumes that the item can be manufactured on time using the 15 available hours from R1 and 25 hours
from ALT_R1.
Let's say that 10 units of an item ITEM_1 are requested for 4/30/2021. ITEM_1 belongs to the sales order line SO_1. Let's
say that ITEM_1 has just one work definition defined, with these resource and component availability details:
Resource R1 is needed for 40 hours. 40 units of the component C1 are needed but only 15 units are available. 60 units of the
It's available for 100 hours. substitute component SUB_C1 are available.
Because only 15 units of C1 are available, SUB_C1 is searched for availability, and 60 units of SUB_C1 are available. The
planning process then assumes that the item can be manufactured on time using the 15 available units of C1 and 25
units from SUB_C1.
13
Oracle SCM Cloud Chapter 3
Using Backlog Management Planning Processes
Simulation Demands
If your enterprise uses an external order management system, you can simulate and plan entire orders before they're
actually created. This helps you anticipate how real orders with the same data will impact planning results in Backlog
Management. These mock orders are called simulation demands or inquiry demands.
In the Backlog Analysis table, simulation demands appear together with real sales orders. To tell them apart, check if the
Simulation Demand column value is Yes or No.
Tip: Have your simulation demand data cleared regularly. To do so, use the Delete Backlog Planning Session Data
scheduled process. In the Process Details dialog box, select the Delete inquiry demands check box.
Related Topics
• How You Load Planning Data from Files
• Define a Demand Priority Rule
14
Oracle SCM Cloud Chapter 3
Using Backlog Management Planning Processes
Potential Without Item, and the items' Constraint Rank values. The planned date for the most constraining item
is the planned date of the set.
If you're satisfied with the results, save them. Remember that the Save Planning Results action doesn't automatically
deliver planning results to the order management system; it only saves results to the backlog planning data repository
so that they can be displayed in subsequent user sessions, until new results for the planned orders are saved.
Tip: You can take actions to lock or override planning results. You can also decommit some orders or prevent the
planning process from considering some orders for fulfillment. While reviewing sets, you can remove constraining
items. To know more, refer to the Simulate Changes to Attribute Values section in this chapter.
Requested Attributes
Requested attribute values are specified during order creation. They're collected during the data collection process, and
you can simulate changes to some of them in the Backlog Analysis table. Here are the key requested attributes:
• Requested Date. The date for which the order was requested.
• Request Type. Orders can be of the shipment or arrival type, as specified by the customer. If the type is
shipment, the customer has requested for the order to be shipped. If it's arrival, the customer has requested for
the order to be delivered at the customer site.
• Requested Ship-from Organization. The value defaults to the organization on the order line, but you can
change it.
• Requested Drop Ship Supplier Site.
• Requested Item.
• Requested Shipping Method. This is the concatenation of shipping information, namely the requested carrier,
requested mode of transport, and requested service level. You can edit the method value, but you can't change
values for individual method components.
In addition to these, your customer also defines the Earliest Acceptable Date and Latest Acceptable Date for an order.
The order also carries a Demand Fulfillment Lead Time value that your enterprise and the customer agreed upon. You
can't change them, and the engine respects them during planning.
Scheduled Attributes
Scheduled values are determined by Global Order Promising, and are always available only if your enterprise uses Oracle
Fusion Order Management. Here are the key scheduled attributes:
15
Oracle SCM Cloud Chapter 3
Using Backlog Management Planning Processes
Planned Attributes
Planned attribute values are determined in Backlog Management. Planned attributes are displayed only after you run
plans. Here are the key planned attributes:
• Planned Ship Date and Planned Arrival Date.
• Planned Date. It's the same as the Planned Ship Date if the request type is Shipment. It's the same as the
Planned Arrival Date if the request type is Arrival.
• Planned Ship-from Organization, also known as the drop ship supplier.
• Planned Shipping Method. This is the concatenation of shipping information, namely the requested carrier,
requested mode of transport, and requested service level. You can edit the method value, but you can't change
values for individual method components.
Calculated Attributes
Some attribute values are calculated during the backlog planning process on the basis of planned, scheduled, and
requested attributes:
• Fulfillment Lead Time Date. This value is calculated using the demand fulfillment lead time, which is the
number of days post the order creation date within which the order must be fulfilled. This lead time value is
mutually decided by your enterprise and your customer, and can be updated through a REST service or on the
Manage Backlog Planning Options page. The fulfillment lead time date can also be specified through a REST
service. If the requested date is later than the fulfillment lead time date calculation, then the fulfillment lead
time date is matched to the requested date.
• Calculated Priority. The planning process calculates a priority value for every order using the demand priority
rule you specified. These values are always in multiples of ten, with 10 being the highest priority value. If a row
represents a set, the displayed calculated priority value will apply on the entire set, and all constituent items will
have the same value.
• Scheduled Days of Delay. It's the difference in working days between the Scheduled Date and the Requested
Date.
• Planned Days of Delay. It's the difference in working days between the Planned Date and the Requested Date.
• Days of Improvement. The difference between the planned days of delay and the scheduled days of delay. A
positive value implies that the planned values are an improvement on the scheduled values.
• Order Revenue. It's the product of the selling price and the requested quantity. A row that represents a set
displays the total order revenue of all lines in the set. Selling Price and Requested Quantity are both collected
attributes.
• Order Margin. It's the difference between the order revenue and the order fulfillment cost, which is a collected
attribute.
Set-Related Attributes
When you review planning results for a shipment or arrival set, remember that the planned date for its most constrained
item becomes the planned date for the entire set, and this is planned date displayed for the row that represents the set.
For such a row, the order revenue displayed is the total revenue of all its constituent lines. In addition to the requested,
scheduled, and planned values, there are a few more relevant attributes that you compare while reviewing a set:
• Item Availability Date. The date when an item will be available. All items with an item availability date later
than the requested date are treated as constraining items, and they get constraint-ranked.
16
Oracle SCM Cloud Chapter 3
Using Backlog Management Planning Processes
• Constraint Rank. Values that indicate which items are more constraining, with 1 being the most constrained
value.
• Planned Date Without Item. The planned date of the set with regard to a specific constraint rank, if all items
with an equal or higher constraint rank are removed from the set.
• Improvement Potential Without Item in Days. The number of days by which the planned date of a set with
regard to a specific constraint rank will improve if all items with an equal or higher constraint rank are removed
from the set.
• Original Set Name. The name of the set a line belonged to before it was removed from the set.
These attributes are specific to Backlog Management and aren't included in collected data. To know more about
enforcing current commits, pulling in orders, locks, and manual overrides, refer to the Simulate Changes to Attribute
Values section in this chapter.
Other Attributes
There are a few more attributes worth considering when you review planning results:
• Simulation Demand. An order simulation that's loaded into Backlog Management using the collection process,
that's planned just like a real sales orders. If the column value is Yes, the row doesn't represent a simulation
demand. Planning results on simulation demands don't affect analytics and can't be released.
• Reserved. An order for which supply has been reserved is marked with a chain-link icon. Reserved lines are also
identifiable by the Yes value in the Reserved column.
• Configuration Item. The top-level configured item for CTO orders.
• Demand Source System. The source system the demand was collected from.
• Demand Class. A classification of customers or demand sources for an order. This is a collected attribute that
you can't modify.
• Error Text. If the order isn't modeled viably for planning, an error message is displayed when you attempt a
plan run. The error text column displays one of these values: Requested Date Out of Range, Sourcing Failed,
Invalid Item and Organization Combination, or Invalid Organization and Ship Method Combination
• Fulfillment Cost. The cost of fulfilling the order. It is collected from Oracle Fusion Order Management.
• Item Type. The type of the requested item. It can be Standard or ATO Model.
17
Oracle SCM Cloud Chapter 3
Using Backlog Management Planning Processes
• Last Updated By. The user who updated the demand most recently. If the demand was updated by a
scheduled process, the value displayed is FUSION_RUNTIME.
• Last Updated Date and Time. The date and time when the demand was last updated.
• Notes. Users can add notes for an order. Notes are retained when the order is replanned.
• Order Creation Date and Time. It's a collected attribute.
• Planner. The planner responsible for a demand line. It's a collected attribute.
• Selling Price. The price of an item per unit. It's a collected attribute used to calculate the order revenue.
• Ship-to Organization. It's a collected attribute valid only for orders sourced from Oracle Fusion Order
Management.
Note: Your enterprise may have loaded additional attributes into Backlog Management. Values for these attributes
appear in the Additional Information column in the Backlog Analysis table. To know more about user-defined
attributes, refer to the How User-Defined Attributes Are Added topic in the Demand Priority Rules chapter.
On Time Fulfillment
This infotile depicts the percentage of orders that are scheduled to be fulfilled by their requested date versus the
percentage of orders that are planned to be fulfilled by their requested date.
Drill down to view analytic data by customer, organization and item category:
• These graphs account for the top ten high-revenue customers, organizations, and item categories.
• They contrast the percentages of scheduled and the percentage of planned orders for each metric, while also
displaying revenues.
• While reviewing a graph, select a revenue bar and use the Drill To action to view results for orders in the
Backlog Analysis table, for a specific customer, organization, or item category.
18
Oracle SCM Cloud Chapter 3
Using Backlog Management Planning Processes
Drill down to view analytic data by customer, organization and item category:
• These graphs account for the top ten high-revenue customers, organizations, and item categories.
• They contrast the percentages of scheduled and the percentage of planned orders for each metric, while also
displaying revenues.
• While reviewing a graph, select a revenue bar and use the Drill To action to view results for orders in the
Backlog Analysis table, for a specific customer, organization, or item category.
Note: The lead time date may be directly specified on an order, or may be calculated from the lead time specified for
these orders on the Manage Backlog Planning Options page.
You can't find the Backlog Analysis table The Backlog Analysis table hasn't opened Click the page-level Open action and
when you enter the Backlog Management by default. select to open the Backlog Analysis table.
work area.
The Refresh and Plan action fails because Only one Refresh and Plan action can run Use the Run Plan action. If you want to
another Refresh and Plan process is at a time. use Refresh and Plan, wait for the process
running. identified in the message to end. Track the
status in the Scheduled Processes UI.
No planned dates are calculated after a The requested date may be too far out in Check the Error Text column for details.
plan run. the future or past.
Sales orders are planned late, at the Supply that might be available might not Collect planning data.
Infinite Time Fence or at the End of the have been collected.
planning horizon.
19
Oracle SCM Cloud Chapter 3
Using Backlog Management Planning Processes
Demands with scheduled dates in the past The Past-Due Supply and Demand On the Manage Backlog Planning Options
aren't getting planned. horizon might not be suitable. page, ensure review and edit the value
for the Past-Due Supply and Demand
Considered In Days field. If this value was
also defined for the backlog planning rule,
the value defined for the rule overrides
the value defined on the planning options
page.
High-priority demands don't improve Supply is first allocated so that all Decommit low-priority demands by
significantly even though there's enough demands are met by their scheduled date. setting their Enforce Current Commit
supply. There might not be enough supply to value to No.
further improve specific demands after
this allocation.
Some demands get planned after their These demands might have been Set their Enforce Current Commit value to
scheduled date even though there's decommitted. Yes.
enough supply for all demands to be
planned on schedule.
You can't see rows for each line in a set. For sets, only a header row is visible and To see constituent lines, select the set row
the sales order information displayed and click the Manage Set action.
accounts for the entire set.
The item availability date isn't appearing The item availability date is calculated only You need the item availability date only
on the Manage Set page. when a set is delayed. to identify constraining items in the set. If
the set is scheduled on time, then there's
enough supply for all items.
There's no Scheduled data in the On Time No sales orders have been collected. Check the Supplies and Demands table in
Fulfillment and Fulfillment by Lead Time the Plan Inputs work area to verify if sales
Date infotiles. orders have been collected. If not, then
collect planning data.
There's no Planned data in the On Time You didn't run the plan. Planned data is Schedule the Start Backlog Planning
Fulfillment and Fulfillment by Lead Time calculated during a plan run and displayed process without specifying parameters for
Date infotiles. when the run completes. the organization.
There's no significant difference between The Fulfillment Lead Time Date of the On the Manage Backlog Planning Options
the data in the On Time Fulfillment and demands being planned might be the page, review and edit the Default Demand
Fulfillment by Lead Time Date infotiles. same as their Requested Date. The lead Fulfillment Lead Time Date value, or
time date defaults to the requested date if update it through a REST service.
the lead time date wasn't specified and the
requested date is too far out.
20
Oracle SCM Cloud Chapter 3
Using Backlog Management Planning Processes
1. Use the Save Planning Results action to register these results in the backlog planning data repository.
2. Select the orders whose results you want to release and use the Mark for Release action to make the results on
these lines eligible for release. You can undo this using the Unmark for Release action.
3. Use the Release Planning Results action to actually release them.
Note: The Release Status column tells you if an order has been marked for release. After planning, if planned values
are different from scheduled values, the status is Release. If you mark the order for release, the status changes to
Marked for Release. If you use the Unmark for Release action on the order, the status reverts to Release.
21
Oracle SCM Cloud Chapter 3
Using Backlog Management Planning Processes
22
Oracle SCM Cloud Chapter 4
Using Backlog Management Simulate Changes to Attribute Values
Note: Because supply needs to be redistributed when you plan after overriding priorities, the planning results of low
priority orders could worsen.
Related Topics
• How Demand Priority Is Calculated Using Demand Priority Rules
• When the Enforce Current Commit value for some orders is Yes, the scheduled dates for these orders are
retained as their planned dates. This is because the supply for the selected orders is retained, and isn't
reallocated to fulfill higher priority demands.
• If you change the Enforce Current Commit value for an order to No, the supply from this order can be
reallocated to another order, and this order's planned delay can be worse than its originally scheduled delay.
23
Oracle SCM Cloud Chapter 4
Using Backlog Management Simulate Changes to Attribute Values
Pull-in Enabled
You can also improve supply for some orders by not letting the backlog planning process consider other orders for
improvement. To do so, set the Pull-in Enabled value for the latter to No and rerun the plan. Here's how it works:
• When the Pull-in Enabled value for some orders is No, the scheduled dates for those orders will be retained as
planned dates, but they can't be improved.
• If you leave the Pull-in Enabled value as Yes, the order can be improved up until its requested date.
Order Number Requested Date Requested Quantity Scheduled Date Enforce Current
Commit
• 15 units on 01/11/2020
• 10 units on 01/18/2020
• 5 units on 01/25/2020
• We select a simple demand priority rule REQDATE, which prioritizes demands by just by their requested date. It
gives highest priority to the order with the earliest requested date.
• The Enforce Current Commit value is Yes for all three orders.
24
Oracle SCM Cloud Chapter 4
Using Backlog Management Simulate Changes to Attribute Values
Orders are prioritized based on their requested date. You infer that the planned dates are no later than the scheduled
dates.. This is because the planning process respected the scheduled dates, based on the Enforce Current Commit
value.
Now let's see what happens when the Enforce Current Commit value of Order 2 is changed to No.
You infer that the planned date of Order 2 is later than its scheduled date. Meanwhile, the planned date of Order 3 has
improved. This is because the planning process used supply for the decommitted Order 2, which would be available
from 01/18, to fulfill Order 3 on 01/18, which is earlier than its scheduled date.
Because 5 units of supply were taken away from Order 2, and because the next 5 units of supply are available on only
01/25, Order 2 can be fulfilled only on 01/25.
25
Oracle SCM Cloud Chapter 4
Using Backlog Management Simulate Changes to Attribute Values
Pull-in Enabled value is Yes for all three orders, and in the second, we prevent one order from being considered for
improvement.
Order Number Requested Date Requested Quantity Scheduled Date Pull-in Enabled
• 10 units on 01/11/2020
• 10 units on 01/15/2020
• We select a simple demand priority rule REQDATE, which prioritizes demands by just by their requested date. It
gives highest priority to the order with the earliest requested date.
• The Pull-in Enabled value is Yes for all three orders.
Orders are prioritized based on their requested date. You infer Order 1 has been improved beyond its scheduled date.
This is because 10 units of supply were available on 01/11 to satisfy the request from Order 1. Another 10 units of supply
were available on 01/15, of which 4 units can be allocated to Order 2 and 6 units to Order 3, as requested.
Now let's see what happens when the Pull-in Enabled value of Order 1 is changed to No.
26
Oracle SCM Cloud Chapter 4
Using Backlog Management Simulate Changes to Attribute Values
You infer that the planned date of Order 1 is the same as its scheduled date. This is because it wasn't considered for
improvement. The supply of 10 units available on 01/11 can now be used to fulfill the demand of Orders 2 and 3, for
which 4 and 6 units were requested, and so their planned dates improve beyond their scheduled date. The 10 units of
supply are available on 01/15, and this supply is used to fulfill Order 1.
• If the Planned values are satisfactory, you can use the Lock Planning Results action to freeze the Planned
values. This ensures that the Planned values for this order line are retained when you rerun the plan.
• If the Planned values are unsatisfactory, you can use the Override Planning Result action to manually specify
Planned values for this line.
27
Oracle SCM Cloud Chapter 4
Using Backlog Management Simulate Changes to Attribute Values
Review A Set
To review the set that an order belongs to, select the order and click the Manage Set action. Here's how you understand
the constraints:
• Compare the Planned Date and Item Availability Date values to know if an item will be available in time. The
planned date for a set depends on the latest item availability date.
• Click the View Constraints button for a graphical depiction of constraining items.
• Review the Constraint Rank values to know which items are more constraining.
• Review the Planned Date Without Item values to know what the set's planned date is if certain constraining
items are removed from the set.
• Review the Improvement Potential Without Item in Days values to know how much the planned date
improves if certain constraining items are removed from the set.
Note: You can't remove an order line from a set that's sourced from Oracle Fusion Order Management. The Remove
from Set action is grayed out for such sets.
Order Line Item Requested Item Planned Date Constraint Planned Date
Number Date Availability Rank Without Item
Date
28
Oracle SCM Cloud Chapter 4
Using Backlog Management Simulate Changes to Attribute Values
Inferences
• The most constraining line is Line 3, because Item 3 is has the latest item availability date. Because the planned
date of a set is the planned date of its most constrained line, the planned date for this set is 01/25/2020. If you
remove Line 3 from the set, the planned date for the set becomes 01/22.
• If you remove just Line 1 and Line 2, the planned date will still be 01/25/2020, because the most constraining
line, Line 3, is still in the set.
• If you want the set planned on time, you must remove not only Line 2, but also Line 1 and Line 3.
29
Oracle SCM Cloud Chapter 4
Using Backlog Management Simulate Changes to Attribute Values
30
Oracle SCM Cloud Chapter 5
Using Backlog Management Demand Priority Rules
To manage your demand priority rules in the Backlog Management work area, open the Tasks panel and click the
Manage Demand Priority Rules link.
31
Oracle SCM Cloud Chapter 5
Using Backlog Management Demand Priority Rules
Related Topics
• Overview of Flexfields
• Considerations for Managing Flexfields
Let's assume that you selected a rule called REV_REQDATE, which is made up of the attributes Order Revenue and
Requested Date. This table shows the attribute and attribute value rankings within the rule:
So, using the rule REV_REQDATE, the backlog planning process first considers the orders by revenue, giving high-value
orders more priority. Then the process prioritizes orders by their requested dates, and calculates priority values for each
order. If the highest order revenue is the same for two orders, then the order with the earlier requested date gets the
higher priority value. Priority values are calculated in multiples of 10, and the highest priority value is 10.
Note: You can override a calculated priority value by specifying a different value in the Override Priority column. You
must rerun the plan for this override to take effect.
Related Topics
• When to Override Demand Priority
32
Oracle SCM Cloud Chapter 6
Using Backlog Management Backlog Planning Rules
To know more about these modes, refer to the Backlog Planning Modes topic.
Because there are four assignment bases, multiple backlog planning rules can be applicable to an item. But the
granularity of the assignment bases determine which rule is used for the item. To know more, refer to the Backlog
Planning Rule Precedence topic.
33
Oracle SCM Cloud Chapter 6
Using Backlog Management Backlog Planning Rules
When you create backlog planning rules in lead time planning mode, you use one of these lead time attributes:
• Total lead time
• Cumulative manufacturing lead time
• Cumulative total lead time
• User-defined lead time
When you create backlog planning rules in supply chain availability search mode, you make specifications to control
several aspects of the search. Here's what you specify:
• Whether the process must search components and resources
• Which types of supply and demand it must consider
• Which lead time it uses for the infinite availability fence
34
Oracle SCM Cloud Chapter 6
Using Backlog Management Backlog Planning Rules
• The time fence for considering past-due demand and past-due supply
Here's the backlog planning rule override sequence in the order of most specific assignment to least specific
assignment:
So if you assign backlog planning rules to the item and to its category, the rule assigned to the item overrides the rule
assigned to the category. The planning process then uses the rule assigned to the item while considering supply.
35
Oracle SCM Cloud Chapter 6
Using Backlog Management Backlog Planning Rules
• If the requested date is the requested arrival date, the process respects calendar constraints and transit lead
time constraints.
• If the requested date is the requested ship date, the process respects calendar constraints.
If the requested date is an arrival date, the backlog planning process first derives the requested ship date by applying a
transit time offset to determine the requested ship date. To determine the offset, the default carrier, shipping mode, and
service level associated between the ship-from date and the ship-to date is considered. To derive the planned ship date,
the process then applies the lead time defined in the backlog planning rule to the derived requested ship date. Then to
calculate the planned arrival date, the process applies the transit time for the specified or default ship method. When
determining dates, the process accounts for any calendar constraints.
The planned date is offset from the requested date based on the lead time defined in the backlog planning rule.
36
Oracle SCM Cloud Chapter 6
Using Backlog Management Backlog Planning Rules
• Constraints specified on the fulfillment line, such as the specification of a ship-from warehouse and whether
splits are allowed.
• Attribute settings for the rule that's being applied.
• The supply chain defined by the assignment set in use and the sourcing rules that it contains.
Additional settings determine other significant considerations. The following must be true for the supply chain
availability search to consider capable-to-make when determining availability:
• The item is built from components, and the rule has been enabled to search for components and resources.
• Inventory is maintained at the component level.
• Modeling of bills-of-material and routings have been collected into the planning data repository from the
applicable fulfillment systems.
The fewer constraints specified on the fulfillment line, the more possibilities the supply chain availability search can
consider. For example, if a ship-from warehouse isn't specified, and splits and item substitutions are allowed, the
supply chain availability search looks for the best possible ways of planning the fulfillment line by looking across all
warehouses specified in the applicable sourcing rules and by considering splitting by date, or substituting items, or both.
The backlog planning process determines a default availability option as well as availability options that represent the
best possible availability from each warehouse.
Unless the constraints on the fulfillment line restrict it from doing so, the supply chain availability search always
considers the supply for the item at other warehouses, also known as transfer capable-to-plan, and the supply for
the item at suppliers, also known as buy capable-to-plan. If the rule being applied has enabled the consideration of
components and resources, the supply chain availability search considers the availability of the components and
resources consumed during manufacturing, also known as make capable-to-plan, For example, if the settings enable a
capable-to-plan search, and an end item is made of two components, C1 and C2, which are assembled on a resource R1,
37
Oracle SCM Cloud Chapter 6
Using Backlog Management Backlog Planning Rules
if supply is available for the components, but not for the end time, the fulfillment line is planned by using the available
supply of the components and by considering the resource availability.
• The cost associated with resource consumption defined as cost per unit of resource consumed
• The cost of the components required to make the end item
Select one of these lead times to define a lead time based infinite availability time fence:
38
Oracle SCM Cloud Chapter 6
Using Backlog Management Backlog Planning Rules
Note: You should define an infinite availability time fence. If you don't define an infinite availability time fence, the
backlog planning process uses the horizon of a year, which incurs a large increase in the memory used by backlog
planning engine.
39
Oracle SCM Cloud Chapter 6
Using Backlog Management Backlog Planning Rules
40
Oracle SCM Cloud Chapter 7
Using Backlog Management Sourcing Rules, Bills of Distribution, and Assignment Sets
Buy from Sourced from an external supplier. Specify the supplier and supplier site.
Make at Sourced from an internal organization that Specify the manufacturing organization.
manufactures the item.
Transfer from Sourced through an interorganization Specify the organization from which items
transfer. will be transferred.
Note: When you create sourcing rules and bills of distribution, you specify how you will replenish items. You don't
specify what items that you will replenish. To specify which sourcing rules or bills of distribution that you will use to
replenish what items, you create assignment sets.
You define the following aspects of sourcing rules and bills of distribution to define your sources of supply and your
sourcing strategies:
• Global sourcing rules
• Local sourcing rules
• Bills of distribution
• Effectivity dates
• Source ranks, quantity-based sourcing specifications, and allocation percentages
Tip: When first designing your sourcing rules and bills of distribution, start by envisioning your assignment set.
Determine what set of global sourcing rules, local sourcing rules, bills of distribution, or combinations of rules and
bills that you need to implement your assignment set while minimizing the number of rules or bills to maintain. For
example, you may be able to define a global sourcing rule in such a way that you will need only a few local sourcing
rules to assign for exceptions to the global rule.
41
Oracle SCM Cloud Chapter 7
Using Backlog Management Sourcing Rules, Bills of Distribution, and Assignment Sets
If you have a source that's applicable to most of your organizations, create a global sourcing rule for that source and
local sourcing rules for the organizations for which the source isn't applicable. For example, if there are 20 organizations
in your company, and 19 of the organizations transfer supply from the Munich organization, create a global sourcing
rule specifying transfer-from the Munich organization, and create a local sourcing rule specifying where the Munich
organization gets supply from.
Bills of Distribution
If you have designed multiple local sourcing rules with material flowing through three or more organizations, you can
choose to create one bill of distribution to implement the sources instead of creating multiple local sourcing rules.
Choosing to create a bill of distribution instead of sourcing rules is a personal or organizational preference. Any scenario
that you can implement by creating a bill of distribution, you can also implement by creating multiple local sourcing
rules.
For example, the following sourcing scenario could be implemented by three local sourcing rules or one bill of
distribution:
• Organization M1 sources items by purchasing from a supplier, XYZ Supply.
• Organization M2 sources items by transferring from M1.
• Organization M3 sources items by transferring from M2.
Effectivity Dates
Use sourcing effectivity dates to modify sourcing rules and bills of distribution when sources change, such as a new
supplier contract is established or a manufacturing facility is shut down. Each rule or bill can have multiple, non-
overlapping ranges of effectivity start dates and end dates, with a different set of sources specified for each range. For
example, if you have a sourcing rule that currently specifies a buy-from source with Acme Supplier specified for the
supplier, but your company has decided to start buying from Winter Widgets instead, you would modify the sourcing
rule by specifying the applicable end date, the date you will no longer buy from Acme Supplier, for the current effectivity
date range. You add a new effectivity date range, specifying the date when you will start buying from Winter Widgets for
the start date, and then you add a buy-from source for the new effectivity date range with Winter Widgets specified for
the supplier.
42
Oracle SCM Cloud Chapter 7
Using Backlog Management Sourcing Rules, Bills of Distribution, and Assignment Sets
Note: Because sourcing rules collected from some source systems might include split allocations for planning
purposes, multiple sources that include the same rank and quantity range might exist, but the allocation percentages
must add up to 100 percent. The backlog planning process doesn't split the quantity when it determines availability.
The backlog planning process checks the source with the highest allocation percent first within a group of sources with
the same rank. If the source with the highest allocation percent has enough supply, that source is used for the entire
requested quantity. If the source with the highest allocation percent doesn't have enough supply, then the source with
the next highest allocation percent will be checked for the entire quantity. Because split allocations aren't applicable to
backlog management sourcing strategies, the examples provided here don't include split allocations.
The following table is an example of a sourcing rule with three ranks. Quantity-based sourcing isn't being used in this
example. If a supply chain search is conducted using this rule, the backlog planning process checks if organization M2
can make the desired quantity first. If organization M2 can't make the desired quantity, the backlog planning process
will then check if there is enough quantity at organization V1 for an interorganization transfer. If there isn't enough
quantity at organization V1, then the backlog planning process will check if the desired quantity can be bought from
supplier Winter Widgets.
43
Oracle SCM Cloud Chapter 7
Using Backlog Management Sourcing Rules, Bills of Distribution, and Assignment Sets
Note: When the planning process conducts a supply chain search, a profile option, the Default Order Promising
Assignment Set profile option, designates which assignment set will be applied. The planning process uses the
sourcing hierarchy to determine which sourcing rule or bill of distribution to follow from the rules or bills within the
designated assignment set.
Tip: Understanding and using the power of the sourcing hierarchy in an assignment set can make the designing and
managing of sourcing relationships easier.
For example, if a plant initially receives all items belonging to a specific item category, such as the Fasteners item
category, from Supplier A, then the sourcing rule to buy from Supplier A can be assigned at the Category assignment
level for the Fastener item category.
If you then determine that a specific fastener is to be sourced from a different supplier, Supplier B for example, then you
can assign a different sourcing rule to buy from Supplier B at the item level for the specific fastener. The detailed-to-
general hierarchy determines that the specific fastener will be sourced from Supplier B, while all other fasteners are still
sourced from Supplier A.
For the sourcing rules and bills of distribution within the assignment set where the effective date of the sourcing
assignment meets the date criteria, each rule or bill is associated with a specific row in the sourcing hierarchy. The
sourcing assignment attribute values, such as the item value, determine which of the rules, bills, and set of item
attributes are applicable to the specific criteria set. Multiple rules, bills, or item attributes can be applicable; therefore,
multiple rows can be applicable. The rule, bill, or set of item attributes associated with the highest row in the hierarchy is
the rule, bill, or set of item attributes that will be followed to determine the source.
From the Manage Assignment Sets page, you can click the View Sourcing Hierarchy button to view a table containing
rows of the sourcing hierarchy.
44
Oracle SCM Cloud Chapter 7
Using Backlog Management Sourcing Rules, Bills of Distribution, and Assignment Sets
This table lists the sourcing hierarchy. The most specific, most granular, row is the first row. The least specific, least
granular row, is the last row.
Tip: You can view the sourcing hierarchy and initiate a search to ask "Where does this organization get this item on
this date?" If you need to analyze why the process returned results that were different than what you expected, you
can view and search the sourcing hierarchy to determine which sourcing rule would be used for your set of criteria.
45
Oracle SCM Cloud Chapter 7
Using Backlog Management Sourcing Rules, Bills of Distribution, and Assignment Sets
The following figure shows an example where three sourcing rules and one bill of distribution are assigned to two
assignment sets:
• The first sourcing rule, SR1, is assigned to the first assignment set, AS1, at the item and organization
assignment level for item B241 and organization M1.
• The bill of distribution, BD1, is assigned to the first assignment set, AS1, at the item assignment level for item
C105.
• The second sourcing rule, SR2, is assigned to the first assignment set, AS1, at the organization assignment level
for organization M2.
• The second sourcing rule, SR2, is also assigned to the second assignment set, AS2, but is assigned to AS2 at the
item assignment level for item C105.
• The third sourcing rule, SR3, is assigned to the second assignment set AS2, at the organization assignment level
for organization M2.
When the supply chain network implemented by assignment set AS2 is followed, Item C105 is replenished according to
the sourcing means specified in the sourcing rule SR2. When the supply chain network implemented by assignment set
AS1 is followed, Item C105 is replenished according to the sourcing means specified in the bill of distribution BD1.
Sourcing Rule
Assign to Item B241 and Organization M1
SR1
Assign to Organization M2
Sourcing Rule
SR2 Assignment Set
Assign to Item C105 AS2
Sourcing Rule
Assign to Organization M2
SR3
When you add new replenishment sources, change your strategies for using your existing sources, or you delete
replenishment sources, you edit existing assignment sets, or create assignment sets, to incorporate these changes into
your supply chains. When you edit assignment sets, you add new sourcing assignments to the assignment set, delete
existing sourcing assignments from the assignment set, or make changes to the assignment level and assignment
46
Oracle SCM Cloud Chapter 7
Using Backlog Management Sourcing Rules, Bills of Distribution, and Assignment Sets
attributes for existing sourcing assignments. You edit assignment sets on the Edit Assignment Set page, or in a
worksheet by selecting to edit in worksheet while on the Manage Assignment Sets or Edit Assignment Set pages.
If you do not specify a catalog for an assignment set, the assignment set uses the Catalog for Sourcing Assignments
(MSC_SRC_ASSIGNMENT_CATALOG) profile option as the default catalog.
To create an assignment set and specify a catalog, use the Manage Assignment Sets task in one of the Supply Chain
Planning work areas.
Note: Assignment sets are not applicable to the Demand Management work area.
Related Topics
• Guidelines for Using Desktop Integrated Excel Workbooks
47
Oracle SCM Cloud Chapter 7
Using Backlog Management Sourcing Rules, Bills of Distribution, and Assignment Sets
48
Oracle SCM Cloud Chapter 8
Using Backlog Management Supply Network Model
• Review organizations, including the time zones associated with the organizations, for all source systems.
• Select the drop ship validation organization. For each source system, you can select only one organization as
the drop ship validation organization. You can also assign a calendar to a drop shop validation organization.
Use the Customer and Supplier tabs to review collected data and assign time zones to customer sites and supplier
sites. If the customer site or supplier site doesn't have an associated time zone, then the customer site or supplier site is
assumed to be in the same time zone as the organization that's associated to the demand or supply.
Use the Carrier and Interlocation Shipping Locations tabs to review collected data on carriers, shipping methods, and
transit times.
When you run the plan, the planning process uses the selected calendar on the Maintain Supply Network Mode page
if the approved supplier list calendar for the supplier site-item is blank. If the approved supplier list calendar for the
49
Oracle SCM Cloud Chapter 8
Using Backlog Management Supply Network Model
supplier site-item is blank, and you do not associate a calendar with a supplier site on the Maintain Supply Network
Model page, then the planning process uses the 24/7 calendar.
To upload additional attributes for supply planning to use, you can create and collect the ASL from purchasing. You can
then use the CSV file upload to define additional attributes such as the following:
• Item-supplier lead time
• Supplier capacity calendar
• Daily supplier capacity
Oracle Fusion Supply Planning supports the approved supplier list for a base model. However, approved supplier lists
aren't supported for configured items and won't be copied into a supply plan.
Related Topics
• Supplier Capacity Options
• How You Maintain Your Supply Network Model
Drop Shipments
Drop ship is an order fulfillment strategy where the seller does not keep products in inventory. Instead, the seller relies
on suppliers or contract manufacturers to build, store, and ship orders to customers. Material flows directly from the
supplier to the end customer. In this flow, the shipment is called a drop shipment.
The drop ship flow includes the following steps:
1. A customer places an order for a product.
50
Oracle SCM Cloud Chapter 8
Using Backlog Management Supply Network Model
2. The seller issues a purchase order for the item and provides instructions for shipping directly to the customer.
3. The suppliers or contract manufacturers ship the product.
4. The seller earns a profit.
Use the drop shipment validation organization for the following purposes:
• As the source for organization-item attributes when creating drop shipment planned orders.
• As a proxy for the organization for drop shipment forecasts and manual demands.
• As a proxy for the organization during the collections of drop shipment sales orders and drop shipment history.
Specify the drop shipment validation organization when you generate a forecast or create a manual demand. Drop
shipment sales order bookings and shipments history are collected with the drop shipment validation organization
when items are shipped from the warehouse. Demand forecasting can create forecasts for the drop shipment validation
organization and release the forecasts for planning supplies. The drop shipment validation organization can be the item
master for a source system, but it's not required.
The drop ship validation organization can be the item master for a source system, but it's not required.
Note: The drop shipment validation organization must be an item organization. When you set up the drop shipment
validation organization, if the item master holds any transactions, create a new drop shipment validation organization.
Note: You can enable only one organization for each source system as the drop shipment
validation organization.
d. In the Organizations region, select the Drop Ship Validation Organization option.
51
Oracle SCM Cloud Chapter 8
Using Backlog Management Supply Network Model
The following table lists the ranking of various demand sourcing hierarchies:
2 Item - Customer
3 Item-Demand Class
4 Item - Region
6 Category - Customer
8 Item
9 Category - Region
10 Category
12 Customer
13 Demand Class
52
Oracle SCM Cloud Chapter 8
Using Backlog Management Supply Network Model
14 Region
15 Global
If an assignment set contains drop shipment rules that are already assigned to an item or a category, then you
must define organization-specific rules for an item or category that's both drop shipped and also shipped to an
inventory organization. If the sourcing rule for the drop ship demand includes a transfer from source or a make at,
the transfer from source and make at is ignored. If there are multiple buy from sources, then the buy from sources are
reapportioned to equal 100%.
53
Oracle SCM Cloud Chapter 8
Using Backlog Management Supply Network Model
54
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
• Collect Planning Data: Use this task when you collect data from the Oracle Fusion source system.
• Load Planning Data from Files: Use this task when you collect data from a completely external source system.
Depending on your security privileges, you may need to manually add these tasks. In the Setup and Maintenance work
area, use the following:
Planning
CSV Files Push Data
Repository
Load Planning
Data from Files
55
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
On the Collect Planning Data page, use the following tabs to select what data you want to collect:
• Reference Data
• Demand Planning Data
• Supply Planning Data
Most of the reference data are global entities. Global entities are common for all source systems. For example, Units of
Measure (UOM) is common for all source systems. The supply planning and demand planning data are transactional
data. Most of the transactional data are local entities. Local entities are specific to each source system. For example, On-
hand Quantity is specific for each source system.
You can also select collection filters to further refine what data you want to collect. You can save your selections to
collection templates.
1. Create the CSV files. To create the CSV files, you can use a predefined set of Microsoft Excel files as import
templates.
2. Import the CSV files. From the navigator, click File Import and Export, and create a new import. Specify scm/
planningDataLoader/Import for the account.
3. Submit the Load Planning Data from Files process. When you submit the process, the process first pushes the
data from the CSV files into the staging tables. The process then loads the data from the staging tables into the
planning data repository.
Related Topics
• Update Existing Setup Data
Global Entities
Within data collections, Oracle Fusion Supply Chain Planning refers to certain business entities as global entities. Global
entities are specific for each instance and are common for all source systems. They are common without regard to
whether they are collected from the Oracle Fusion source system or collected from an external source system using the
file-based data import (FBDI) method.
When collecting data for a global entity, the planning data repository stores only one record for each instance of the
global entity. The data collections process removes the source system reference from the global entity and stores the
data in the data repository. If the data collections process collects the same instance of a global entity from more than
one source system, the data repository stores the value from the last collection.
56
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
For example, the following scenario describes the collection method of the global entity called units of measure (UOM)
from three source systems, namely source system A, B, and C respectively.
• Source system A has an instance of UOM. During the collection of UOMs from source system A, the kilogram
UOM is collected. This is the first time the kilogram UOM is collected. The data collections process creates a
kilogram record in the data repository.
• Source system B does not have any instances of UOM. During the collection of UOMs from source system B,
the data collections process does not collect the kilogram value. Since there was no record for the kilogram
UOM in source system B, the data collections process does not change the kilogram record in the data
repository. The record of the kilogram value from source system A is still valid.
• Source system C has an instance of UOM. During the collection of UOMs from source system C, the kilogram
UOM is again collected. The data collections process registers the kilogram record in the data repository to
match the values from source system C.
Note: When you use the FBDI collection method, the global entity files require a source system. The collections
framework validates that the source system matches each record's source system. A source system identifier marks
each data record.
In Supply Chain Planning, the following entities are classified as global entities:
57
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Targeted
You use the Targeted collection type when you want to perform a complete refresh of the data in the data repository.
In this mode, the planning process deletes the existing data for the selected entities from the data repository. Next, if
subsequently collected from the source, the data for the selected entities replaces the deleted data.
Note: For the following data collection entities, you can use only the Targeted collection type: Item Costs, Resource
Availability, Fiscal Calendars, and all Shipment and Booking History data.
Net change
When you use the Net Change collection type, you collect data incrementally. The Net Change collection type collects
only changed or new data. Collecting data using the Net Change collection type is usually faster than using the Targeted
collection type. You typically use the Net Change collection type when you have previously performed a Targeted
collection, and now you want to keep your planning data current with your execution system data. You cannot select the
demand planning data when the collection type is Net Change.
Automatic selection
You use the Automatic collection type when you are not sure which collection type to select and you want the planning
process to decide the collection type for each entity. The planning process evaluates each entity on multiple factors,
such as the last collected date for an entity, and decides whether to perform a Targeted or a Net Change collection for
the entity. You can manually select the entities that you want to collect or you can use one of the predefined templates
to select your entities. If you select one of the predefined templates, you can't make any changes in the Reference Data,
Demand Planning Data, and Supply Planning Data tabs.
To open the Manage Trading Community Source Systems page, navigate to the Setup and Maintenance work area and
use the following:
• Offering: Supply Chain Planning
58
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
There are two types of external source systems: Others and External.
Version External
The version External source system indicates that the source system is not connected to any other Oracle Fusion
applications. This source system is not integrated with Oracle Fusion Product Data Model, Oracle Fusion Trading
Community Model, and Oracle Fusion Order Management Cloud. The external source system is also referred as a
completely external source system. You cannot enable any other source system settings that are related to other Oracle
Fusion applications. You can select the Collections allowed check box now or later depending on when you want to start
collecting data. This enables the source system for data collections using the file-based import process.
Version Others
The version Others source system indicates that the source system is connected to other Oracle Fusion applications.
This source system is integrated for Oracle Fusion Product Data Model, Oracle Fusion Trading Community Model, and
Oracle Fusion Order Management Cloud. The following conditions are applicable when the external source is Others.
• External system data for Items, Item Structures, and Catalogs is uploaded to Oracle Product Data Model Cloud
• External system data for Customers, Customer Sites, Regions and Zones is uploaded to Oracle Trading
Community Model Cloud
• External system data for Sales Orders is uploaded to Oracle Order Management Cloud
For more information on types of data that can be collected for each source system, see the Import Templates Used to
Create CSV Files for Supply Chain Planning topic.
To enable organizations for data collections when the source system version is Oracle Fusion, perform the following
steps:
1. Click the Manage Organization List button for your Oracle Fusion source system.
2. Click the Refresh Organization List button to update the organizations list
3. Select the Enable for Collections check box for the organizations from which you want to collect data.
Tip: When performing collections during your initial setup, collect order orchestration reference objects from the
predefined Oracle Fusion source system, and consider collecting organizations. After enabling organizations for
collection, collect organizations first. You can confirm the collection results on the Supply Network Model page.
To enable organizations for data collections when the source system version is External (completely external source
system), upload organizations using the file-based import process. The organizations are automatically enabled for
collections.
59
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
To enable organizations for data collections when the source system version is Others, perform the following steps:
Related Topics
• Considerations for Enabling Organizations for Data Collections
• Define Flexfield Mappings
Data Collections
You must perform data collections to populate the planning data repository, also called the order orchestration and
planning data repository, with data from the Oracle Fusion source system or from a completely external source system.
When you load data from an external source system, use the XLSM files to organize your data in the required format
and then convert the data into CSV files. You can then upload the CSV files to the planning data repository.
Order Orchestration
Order orchestration processes use some reference data directly from the planning data repository. You must perform
data collections for the order orchestration reference entities even if you are not using the Supply Chain Planning work
areas.
Note: Before collecting data from your Oracle Fusion source system, you must define at least one organization for
the source system. After you have set up at least one organization, you must update the organization list on the
Manage Planning Source Systems page and then enable at least one of the organizations for collections. If you have
not enabled any organization, then the collections process ends with an error.
Order Promising
The Global Order Promising processes use an in-memory copy of the data from the planning data repository. When
order orchestration processes send a scheduling request or a check availability request to Oracle Fusion Global Order
Promising, the order promising processes use the data stored in main memory to determine the response to send back
to order orchestration. You must refresh the Global Order Promising data store after every collections so that the main
memory always reflect the current.
Related Topics
• Refresh the Global Order Promising Server
60
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
You can view the cross-referenced data for each entity on the Cross-Reference Relationships for Collected Data page in
the Plan Inputs work area.
61
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Manufacturing Cloud Definition Item Structure Name and Work Planning Collections Processes
Definition Name in the Planning Data
Repository
Only item structure is defined for an item. Item structure name exists, no work The planning process collects the item
No work definition is defined. definition name structure information but does not collect
information for routing, operations, or
item resources.
Only work definition is defined for an item. Work definition name exists, no item The planning process collects the work
No item structure is defined. structure name definition information to populate the
item structure and routing information.
Both item structure and work definition Both work definition name and item The planning process uses the
are defined for the item. structure name exist components that are associated
with the work definition to plan. The
planning process does not consider any
components of item structure that are
not associated with the work definition.
You can override the item structure
component usage within the work
definition.
Both item structure and work definition Work definition name exists, no item The planning process collects the
are defined for the item, but the work structure name components from the work definition and
definition does not refer to the item not from the item structure in the Oracle
structure. Ad hoc components are Fusion Product Information Management
assigned to the work definition operations. solution.
62
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Manufacturing Cloud Definition Item Structure Name and Work Planning Collections Processes
Definition Name in the Planning Data
Repository
Manufacturing Work Order Supplies, Resource Availability, Resources, Work Definitions, and Item Structures
1. Select the Manage Planning Source Systems task in the Tasks panel from any Supply Planning work area
page. Or use this task in the Setup and Maintenance work area:
63
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
The following figure illustrates the three categories of data that you collect from the Oracle Fusion source system to the
planning data repository.
Materials
Management
Order Management
2 3
Planning Data Manufacturing
Demand Data Supply Data
Repository
Materials
Management Procurement
Reference Data
Explanation of Callouts
1. Reference data is primarily sourced from Oracle Fusion SCM Cloud
2. Demand data comes from Oracle Order Management Cloud Service and Oracle Materials Management Cloud
Service
64
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
3. Supply data is sourced from Oracle Inventory Management Cloud Service, Oracle Manufacturing Cloud Service,
and Oracle Purchasing Cloud Service
Reference Data
The collection process begins with reference data, which is primarily sourced from Oracle Fusion SCM Cloud. You collect
the data collection entities, such as basic item, resource, organization, customers and suppliers, and calendar data.
Note: Oracle Fusion Sales and Operations Planning uses the Bill of Resources entity to link the make items with their
associated components and resource requirements. For more information on collecting Bill of Resources from an
external source system, see the Loading Planning Data from Files section.
You also use Oracle Supply Chain Planning Cloud to collect the following items:
• Item structures: To explode item-level demand into component demands and supplies.
• Work Definitions: To assign the component and resource requirements for make items.
• Units of measure: To align plan data and to convert plans from one set of units to another.
• Costs: To review plans in financial terms and evaluate the financial impact of planning decisions.
Demand Data
You collect demand data from two potential sources:
• Sales orders that flow from Oracle Order Management Cloud Service: You can use this as the basis of the
demand forecast, while current orders can consume the demand in near-term forecast time buckets.
• Shipment history from Oracle Materials Management Cloud Service: You can use this to generate a shipments
forecast.
Supply Data
You collect supply data from three sources:
• Oracle Inventory Management Cloud Service: This provides data related to on hand inventory, reservations,
material transfers, in-transit supplies, and receipts.
• Oracle Manufacturing Cloud Service: This provides work in process status and any manufacturing work orders.
• Oracle Purchasing Cloud Service: This provides purchase requisitions and purchase orders.
65
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Collection Filters
Use collection filters to improve the performance and efficiency of the collections process, and to avoid accumulation of
irrelevant data in the planning data repository. You can use several filter criteria while performing collections, such as by
employing catalogs, order types, and price lists. You can also use date-based filters for collecting shipment and booking
history information.
Collection Templates
Use collection templates when you want to collect a set of data repeatedly over a period. You can select either one of the
predefined templates that serves your specific need, or you can create your own template and save it for future use.
When you select a predefined template from the list, the Collection Type field is defaulted to Automatic selection and
you cannot edit the field. Also, when you select a predefined template, the Select Collection Filters field is disabled.
You can create a collection template on the Collect Planning Data page by selecting the data collection entities and
saving the template for future use. For example, if you frequently collect certain supply planning transactional entities,
such as On Hand, Purchase Orders, and Purchase Requisitions, then save these entities as a collection template. It
reduces the overhead of selecting the same entities for subsequent collection cycles.
If the template file contains any error during the upload process, rectify the issue found in the log file and upload the
template file again.
Perform the following steps to collect reference data, demand planning data, and supply planning data using the
Targeted collection type.
1. Access the Collect Planning Data page from a Supply Planning work area or the Setup and Maintenance work
area.
66
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Demand planning data can only be collected by using the Targeted collection type.
iii. Click Select Collection Filters to select the collection filters.
◦ On the Reference Data subtab, move the required reference entities to the Selected Entities area.
◦ On the Demand Planning Data subtab, set options to collect the historical demand data in the planning
data repository. The planning process uses the historical demand data for statistical forecasting.
• Collection Time Frame Options: You can specify a fixed or rolling date range for which to collect
data.
The Fixed Date Range option enables you to collect history data within a fixed date range that you
specify.
The Rolling Date Range option enables you to collect the history data for the number of days that
you specify. For example, if you forecast weekly, specify 7 in the Number of Days to Collect field
to collect the demand history data once per week. The data collections collect the demand history
data for the latest week.
Select Roll off time periods automatically to truncate the history data by the number of days that
you specify in the Number of days to keep field each time you run collections for the demand
history data. For example, if you prefer to forecast each week based on the history data of 52
weeks, select the Roll off time periods automatically check box and specify Number of days
to keep as 364 days. This setting ensures that as you collect data every week, you keep the most
recent history of 52 weeks and automatically purge history data older than 52 weeks.
• History Measures and Attributes: Select your shipments history and bookings history measures.
• Collection for ETO Items: Select Collect history from associated base models to collect
bookings and shipments history for Engineer to Order (ETO) items from the associated base
models. When you don't select this option, the history is collected from the standard ETO items.
• History Data Options: To collect only specific order types, select from the Order Types to Include
list of values. By default, all order types are included.
Select the Collect amount data for history check box to collect amount data.
• Additional Options: Select additional options for collections.
Collect Price Lists: Collect the price lists specified in the collections filter for price lists, or collect all
price lists if no filter is specified.
67
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Collect Configure to Order Data: If you selected history measures and attributes, then select the
relevant check boxes to collect shipment history options and booking history options.
Sales Organization Hierarchy: Select Enable sales organization hierarchy collection to collect
one or more sales hierarchies.
◦ On the Supply Planning Data subtab:
i. Move the required supply entities to the Selected Entities area.
ii. If you collect resource availability, then select a date range type: Fixed or Relative to collection
run date.
If you selected Fixed, then provide a start date and an end date for collecting resource availability.
If you selected Relative to collection run date, then enter a number of days in the Collection
Window in Days field. The number that you enter determines a collection window in days to
collect resource availability based on a rolling time window. That rolling time window adjusts itself,
based on the date that you run collections. For example, if you specify 90, then resource availability
is collected for the next 90 days each time from the date of the collection run.
Note: You can save your date range type selection for resource availability collection as
a collection template to use later.
iii. You can collect the existing data for the resource availability.
iv. You can also regenerate the resource availability data and then collect the data. If you select the
Regenerate data, and then collect option, the collections process runs the Update Resource
Availability Job scheduled process first and then collects the resource availability data.
3. (Optional) Click the Schedule tab and set collections to run as soon as possible or schedule to run at a different
time.
4. Click Submit to start the collections process.
5. Monitor the collection status using the Scheduled Processes page.
6. Review the collected data in the Plan Inputs work area.
Related Topics
• Set Up Forecast Consumption for Transfer Orders
68
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Note: You cannot make any changes to the filter criteria and demand planning data in the
net change collection type.
c. In the Reference Data tab, move the required reference entities to the Selected Entities area.
d. In the Supplies Planning Data tab, move the required supply entities to the Selected Entities area.
3. (Optional) Click the Schedule tab and set collections to run as soon as possible or schedule to run at a different
time.
4. Click Submit to initiate the collections process.
5. Monitor the collection status using the Scheduled Processes page.
6. Review the collected data in the Plan Inputs work area.
Related Topics
• Update Existing Setup Data
Note: Before you begin, ensure that you have your organization groups created. A supply planner creates and
manages organization groups using the Manage Organization Groups button on the Maintain Supply Network Model
page.
Related Topics
• How You Maintain Your Supply Network Model
69
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
You use the targeted mode when you want to refresh data for selected entities in the planning data repository. You use
the net change mode to collect data incrementally. The net change collections mode collects only the changed or new
data. Data collection using the net change mode is fast compared to the targeted mode. The net change mode is used
to retain planning data to current with that of the executing system.
The following figure illustrates the process of collecting data from files.
To load planning data from files, you perform the following steps:
70
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
For additional information about creating and importing CSV files, see the following section in the Oracle SCM
Cloud Implementing Common Features for Oracle SCM Cloud guide: External Integration chapter, External Data
Integration Services for Oracle Cloud section.
2. Open the template file for the entity you are preparing and complete the file import template worksheet.
You must enable the macros in the template file before generating the CSV file.
Caution: For the cells that contain dates, ensure that the data is set to the correct format in the
data type. For example, date must be set to YYYY/MM/DD.
3. After you finish preparing the data in the worksheet, generate the CSV file. The Generate CSV File button is
located in the Instructions and CSV Generation worksheet of the workbook.
4. When you save the generated CSV file, you must use the suggested name of the entity. You can add
underscore and add additional characters to the file name. For example, you can name the CSV file as
ShipmentHistory_abc.csv and you can name the file as LoadingCSV.zip.
5. Compress the CSV file into a zipped file format using a compression utility. You can provide any name to the
zipped file.
Note: You can include multiple CSV files in a single compressed file for a source system. The load
process uploads them in a sequential order. Select the CSV files and compress them directly. Do not
compress the parent folder that contains the files.
This completes the preparation of a file that you will upload to collect planning data.
If you run targeted collections for all entities, you can ignore the sequence for collections because targeted collections
automate the collection sequence for all entities within a single collections request. If you collect many entities in a
single request, collections will process them according to the sequences shown in this topic. If you collect only a few
71
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
entities, then you must be aware of the collections sequence information. For example, you should not collect work
orders before you collect items or resources.
To make the workflow simple, the collection sequence is divided into two parts - Part A and Part B. The collection
entities in Part B are dependent on the collection entities in Part A. You must collect the entities in Part A before you
collect the entities in Part B. Also, the collection entities are grouped together for easier presentation. The data groups
in Part A are:
Every collection sequence in Part A starts with defining a source system where the collected data will reside. If you are
collecting data to the same source system, you define the source system only once. Then, use the same source system
to collect all the entities.
The following figure provides an overview of the data collection sequence. The overview shows how Part A and Part B
fit together to form a complete data collection flow.
Collection Sequence
Collection Sequence
Part A for Currency,
Part A for Region, Collection Sequence
Part A Calendar, Demand
Location, and Part A for Item Data
Class, and UOM
Customer Data
Data
Continue to
Collection Sequence
Part B
Part B
Collection Sequence
Collection Sequence
Part B for Work
Part B for Sales
Orders, Work
Order and
Definition, Item
Assignment Sets
Structure
72
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Note: The Organization entity is marked with an asterisk because you can collect other entities such as Planner, Item
Cost, Subinventory, Carrier, Calendar Assignment, Supplier, and Supplier Site after collecting Organization. For more
information on the collection sequence for these entities, see the Collections Sequence Part A for Currency, Calendar,
Demand Class, and UOM Data figure. Refer to the entities that are collected after Organization. Also, ensure that you
collect Location before collecting Supplier Site.
Define Source
Create Organizations Organization*
System
Customer Specific
UOM Class
Item Relationships Item Relationship Item Costs
Conversions
Continue to
Item Structure Catalog Category
Collection Sequence
Component Association
Part B
Item Category
When you collect the data described here, continue to the collection sequence Part B described in the following
subsections.
• Collection Sequence Part B for Sales and Order and Assignment Sets
• Collection Sequence Part B for Work Orders, Work Definition, and Item Structure
73
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Ship Methods
Customer Sites
Sourcing Rules,
Customer Specific Sourcing
Calendar
Item Relationships Assignments, Source
Assignments
Organization,
Receipt Organization
Continue to
Collection Sequence
Part B
When you collect the data described here, continue to the collection sequence Part B described in the following
subsections.
• Collection Sequence Part B for Sales and Order and Assignment Sets
• Collection Sequence Part B for Work Orders, Work Definition, and Item Structure
74
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Collections Sequence Part A for Currency, Calendar, Demand Class, and UOM Data
The following image shows the collections sequence to follow while collecting Currency, Calendar, Demand Class, and
UOM data from external source systems. Also, ensure that you collect Location before collecting Supplier Site.
Note: The Calendar entity is marked with an asterisk because there are other entities that are associated with
Calendar that you must collect in a sequence. To collect other entities associated with Calendar, see the Calendar
Upload Sequence figure.
Define Source
System
Location
Currency Conversion
Type
Currency Conversion
Rate UOM Conversions
Organization*
UOM Class
Conversions
75
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Calendar
Assignment
Continue to
Collection Sequence
Part B
When you collect the data described here, continue to the collection sequence Part B described in the following
subsections.
• Collection Sequence Part B for Sales and Order and Assignment Sets
• Collection Sequence Part B for Work Orders, Work Definition, and Item Structure
76
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Calendar
Calendar Shifts Calendar Exceptions Period Start Days Week Start Dates
Generate Calendar
Calendar Workday
Dates Post
Pattern
Collection
77
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Collection
Sequence Part
A
Continue to
Collection Sequence
Part B
On Hand Purchase
Transfer Order
Orders
Reservations
Sourcing Rules,
Sourcing Assignments,
Source Organization,
Receipt Organization
78
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Collection Sequence Part B for Work Orders, Work Definition, and Item Structures
The following image shows the collections sequence to follow while collecting Work Orders, Work Definition, and Item
Structure data from external source systems. The data entities in Part B are dependent on Part A. So, you must collect
entities listed in Part A before you collect the entities in Part B.
Collection
Sequence
Part A
Continue to
Collection Sequence
Part B
UOM Department
Work Orders
Conversions Resources
Work Order
Resource Work Definition
Reservations Resource
Capacity
Requirement
79
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
the templates to a local drive, enter appropriate data as described in the template, and generate CSV files. Compress
the CSV files to a zipped file format and upload the .zip file to the Universal Content Manager using the File Import and
Export utility. The data is then loaded from the Universal Content Manger to the planning data repository.
Collect Data from the Oracle Fusion Source
The following table lists the collections entities that can be loaded into the planning data repository for the Oracle
Fusion source. The Collection Entity column provides the name of the entities for which you can collect the data.
The XLSM File Name column provides the template name that you will download for the respective collection entity.
Download the XLSM template from the File-Based Data Import for Oracle Supply Chain Management Cloud guide (FBDI
guide). The Link in Data Import Guide column provides the name of the topic in the FBDI guide from where you will
download the template. For example, to collect data for the Item Costs collection entity, refer to the Item Cost Import
topic in the FBDI guide.
Customer Specific Item Relationships Supply Chain Planning Item Substitute ScpItemSubstituteImportTemplate.xlsm
Allocation Assignments and Allocation Supply Chain Planning Planning Allocation ScpPlanningAllocationRulesImportTemplate.xlsm
Rules Rules
ATP Assignments and ATP Rules Supply Chain Planning Available-to- ScpATPRulesImportTemplate.xlsm
Promise Rules
Supply Update Rules Supply Chain Planning Real Time Supply ScpRealTimeSupplyUpdatesImportTemplate.xlsm
Updates
80
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Safety Stock Levels Supply Chain Planning Safety Stock Levels ScpSafetyStockLevelImportTemplate.xlsm
Sourcing Rule and Assignments Supply Chain Planning Sourcing Rules ScpSourcingImportTemplate.xlsm
The following table lists the collections entities that can be loaded into the planning data repository from an external
source, where the version is Others. The Collection Entity column provides the name of the entities for which you can
collect the data. The XLSM File Name column provides the template name that you will download for the respective
collection entity. Download the XLSM template from the File-Based Data Import for Oracle Supply Chain Management
81
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Cloud guide (FBDI guide). The Link in Data Import Guide column provides the name of the topic in the FBDI guide from
where you will download the template. For example, to collect data for the Items and Item Costs collection entities, refer
to the Item Cost Import topic in the FBDI guide.
Customer Specific Item Relationships Supply Chain Planning Item Substitute ScpItemSubstituteImportTemplate.xlsm
Units of Measure, Units of Measure Supply Chain Planning Units of Measure ScpUOMImportTemplate.xlsm
Conversions, and Units of Measure Class
Conversions
Ship Mode of Transport, Ship Class of Supply Chain Planning Carriers ScpCarrierImportTemplate.xlsm
Service, and Carrier
82
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Allocation Assignments and Allocation Supply Chain Planning Planning Allocation ScpPlanningAllocationRulesImportTemplate.xlsm
Rules Rules
ATP Assignments and ATP Rules Supply Chain Planning Available-to- ScpATPRulesImportTemplate.xlsm
Promise Rules
Supply Update Rule Supply Chain Planning Real Time Supply ScpRealTimeSupplyUpdatesImportTemplate.xlsm
Updates
Freight Terms, FOB Points, Invoicing and Supply Chain Planning Order ScpOrderOrchestrationImportTemplate.xlsm
Accounting Rules, Shipment Priorities, Orchestration
Payment Terms, Return Reason, Tax
Classification Code, Tax Exemption
Reason, Sales Credit Type, Activity Type,
Document Categories, Payment Methods,
and Receipt Methods
83
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Safety Stock Levels Supply Chain Planning Safety Stock Levels ScpSafetyStockLevelImportTemplate.xlsm
Purchase Orders, Purchase Requisitions, Supply Chain Planning Purchase Order ScpPurchaseOrderRequisitionImportTemplate.xlsm
PO in Receiving, and In Transits Requisitions
Work Order Material Requirements Supply Chain Planning Work Order ScpWIPComponentDemandsImportTemplate.xlsm
Component Demands
Work Order Resource Requirements Supply Chain Planning Work Order ScpWIPOperationResourceImportTemplate.xlsm
Operation Resources
84
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Sourcing Rule and Assignments Supply Chain Planning Sourcing Rules ScpSourcingImportTemplate.xlsm
The following table lists the collections entities that can be loaded into the planning data repository from an external
source, where the version is External. The Collection Entity column provides the name of the entities for which you can
collect the data. The XLSM File Name column provides the template name that you will download for the respective
collection entity. Download the XLSM template from the File-Based Data Import for Oracle Supply Chain Management
Cloud guide. The Link in Data Import Guide column provides the name of the topic in the File-Based Data Import for
Oracle Supply Chain Management Cloud guide (FBDI guide) from where you will download the template. For example,
to collect data for the Items and Item Costs collection entities, refer to the Item Cost Import topic in the File-Based
Data Import for Oracle Supply Chain Management Cloud guide. All the planning-related entity names are prefixed with
Supply Chain Planning in the FBDI guide.
Catalogs, Categories, and Item Categories Supply Chain Planning Catalogs ScpCatalogImportTemplate.xlsm.xlsm
85
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Item Suppliers (Approved Supplier List) Supply Chain Planning Approved Supplier ScpApprovedSupplierListImportTemplate.xlsm
List
Units of Measure, Units of Measure Supply Chain Planning Units of Measure ScpUOMImportTemplate.xlsm
Conversions, and Units of Measure Class
Conversions
Carrier, Ship Mode of Transport, and Ship Supply Chain Planning Carriers ScpCarrierImportTemplate.xlsm
Class of Service
GOP Allocation Rules and Rule Supply Chain Planning Planning Allocation ScpPlanningAllocationRulesImportTemplate.xlsm
Assignments Rules
GOP ATP Rules and Rule Assignments Supply Chain Planning Available-to- ScpATPRulesImportTemplate.xlsm
Promise Rules
GOP Supply Update Rules Supply Chain Planning Real Time Supply ScpRealTimeSupplyUpdatesImportTemplate.xlsm
Updates
86
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Measures, Sales and Operations Planning Supply Chain Planning Measures ScpMeasuresImportTemplate.xlsm
Backlog, Inventory, and Production History
87
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Safety Stock Levels Supply Chain Planning Safety Stock Levels ScpSafetyStockLevelImportTemplate.xlsm
Purchase Orders, Purchase Requisitions, Supply Chain Planning Purchase Order ScpPurchaseOrderRequisitionImportTemplate.xlsm
PO in Receiving, In Transits Requisitions
Transfer Orders (including expense type Supply Chain Planning Transfer Orders ScpTransferOrderImportTemplate.xlsm
transfers)
Work Order Material Requirements Supply Chain Planning Work Order ScpWIPComponentDemandsImportTemplate.xlsm
Component Demands
Work Order Resource Requirements Supply Chain Planning Work Order ScpWIPOperationResourceImportTemplate.xlsm
Operation Resources
88
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
Sourcing Rule and Assignments Supply Chain Planning Sourcing Rules ScpSourcingImportTemplate.xlsm
Note: For more information about uploading files to the Universal Content Manager server, see the
following section in the Oracle SCM Cloud Implementing Common Features for Oracle SCM Cloud
guide: External Integration chapter, External Data Integration Services for Oracle Cloud section.
2. From one of the Supply Chain Planning work areas or Setup and Maintenance work area, Supply Chain
Planning offering, select the Load Planning Data from Files task.
3. Complete the following parameters on the Load Planning Data from Files page:
If the process completes with warnings, select the request that shows the warning status and click the View
Log button to review the details.
89
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
4. For the rows with errors, resolve the issues found in the log file, and then upload the CSV file again. To load only
the revised rows, use the Net Change option.
To review the following entities, use the Maintain Supply Network Model page:
• Organizations
• Customers
• Suppliers
• Carriers
• Interlocation Shipping Networks
To review data that's not part of the supply network model, use the Plan Inputs page layout. You can view the following
data in the Plan Inputs page layout
• Supply data
• Demand data
Tip: You can set the preview pane to Full Pane for viewing your data in full pane. Click Change and select
Full Pane.
90
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
3. On the Plan Inputs page, click Open, and click Full Pane.
4. On the Open Table, Graph, or Tile Set page, search for the table name.
5. Enter the criteria for the data you want to verify and click Search.
6. Review the data in the Search Results table.
91
Oracle SCM Cloud Chapter 9
Using Backlog Management Planning Data Collection
92
Oracle SCM Cloud Glossary
Using Backlog Management
Glossary
assignment set
A group of sourcing rules, bills of distribution, or both, in which each rule or bill is assigned to an assignment level, and
to attribute values for the attributes applicable to that assignment level. An assignment set defines a supply chain.
bill of distribution
A multilevel specification of the means by which several, specific organizations can replenish items.
profile option
User preferences and system configuration options that users can configure to control application behavior at different
levels of an enterprise.
sourcing rule
A specification of the means by which organizations can replenish items.
93
Oracle SCM Cloud Glossary
Using Backlog Management
94