Expand All


  1. Update 24A
  1. Revision History
  2. Overview
  3. Pre-Update and Post-Update Tasks
  4. Optional Uptake of New Features (Opt In)
  5. Feature Summary
  6. Supply Chain Orchestration
        1. Improve Processing After Supply Chain Orchestration Updates Supply or Demand
        2. Add Postprocessing Days When You Modify Ship Dates in Your Back-to-Back Flows
  7. Demand Management
    1. Demand Management
        1. Plan at Flexible Levels for the Customer Dimension
        2. View an Error Icon When Import from Excel Process has Errors
        3. Export Data in Format Specified in a Planning Table
    2. Replenishment Planning
        1. Enable Incremental Planning for Multiechelon Replenishment Plans
        2. Enhance Policy Calculations for Items in a Supersession Relationship
        3. Respect Orders Planned at Subinventory Level in Buyer Planning
        4. View and Release Rescheduled Purchase Orders from Buyer Planning
        5. View an Error Icon When Import from Excel Process has Errors
        6. Export Data in Format Specified in a Planning Table
        7. Release Planned Buy Orders for Execution with Status Firm
  8. IMPORTANT Actions and Considerations

Update 24A

Revision History

This document will continue to evolve as existing sections change and new information is added. All updates appear in the following table:

Date Module Feature Notes
19 AUG 2024 Replenishment Planning Release Planned Buy Orders for Execution with Status Firm

Updated document. Corrected a privilege name in the Access Requirements section.

01 DEC 2023     Created initial document.

Overview

HAVE AN IDEA?

We’re here and we’re listening. If you have a suggestion on how to make our cloud services even better then go ahead and tell us. There are several ways to submit your ideas, for example, through the Ideas Lab on Oracle Customer Connect. Wherever you see this icon after the feature name it means we delivered one of your ideas.

GIVE US FEEDBACK

We welcome your comments and suggestions to improve the content. Please send us your feedback at oracle_fusion_applications_help_ww_grp@oracle.com.

DISCLAIMER

The information contained in this document may include statements about Oracle’s product development plans. Many factors can materially affect Oracle’s product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle.

This information may not be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates. Oracle specifically disclaims any liability with respect to this information. Refer to the Legal Notices and Terms of Use for further information.

Pre-Update and Post-Update Tasks

Depending on the features you're using in your Cloud applications, you may be required to perform certain steps immediately before or after your quarterly update. For details of these pre-update and post-update steps and the product areas that are affected, refer to Oracle Fusion Cloud SCM: Performing Your Quarterly Update (doc ID 2337485.1) on My Oracle Support.

Optional Uptake of New Features (Opt In)

Oracle Cloud Applications delivers new updates every quarter. This means every three months you'll receive new functionality to help you efficiently and effectively manage your business. Some features are delivered Enabled meaning they are immediately available to end users. Other features are delivered Disabled meaning you have to take action to make available. Features delivered Disabled can be activated for end users by stepping through the following instructions using the following privileges:

  • Review Applications Offering (ASM_REVIEW_APPLICATIONS_OFFERINGS_PRIV)
  • Configure Oracle Fusion Applications Offering (ASM_CONFIGURE_OFFERING_PRIV)

Here’s how you opt in to new features:

  1. Click Navigator > My Enterprise > New Features.
  2. On the Features Overview page, select your offering to review new features specific to it. Or, you can leave the default selection All Enabled Offerings to review new features for all offerings.
  3. On the New Features tab, review the new features and check the opt-in status of the feature in the Enabled column. If a feature has already been enabled, you will see a check mark. Otherwise, you will see an icon to enable the feature.
  4. Click the icon in the Enabled column and complete the steps to enable the feature.

In some cases, you might want to opt in to a feature that's not listed in the New Features work area. Here's how to opt in:

  1. Click Navigator > My Enterprise > Offerings.
  2. On the Offerings page, select your offering, and then click Opt In Features.
  3. On the Opt In page, click the Edit Features (pencil) icon for the offering, or for the functional area that includes your feature.
  4. On the Edit Features page, complete the steps to enable the feature.

For more information and detailed instructions on opting in to new features for your offering, see Configure Offerings.

Opt In Expiration

Occasionally, features delivered Disabled via Opt In may be enabled automatically in a future update. This is known as an Opt In Expiration. If your cloud service has any Opt In Expirations you will see a related tab in this document. Click on that tab to see when the feature was originally delivered Disabled, and when the Opt In will expire, potentially automatically enabling the feature. You can also click here to see features with Opt In Expirations across all Oracle Cloud Applications.

Feature Summary

Column Definitions:

Report = New or modified, Oracle-delivered, ready to run reports.

UI or Process-Based: Small Scale = These UI or process-based features are typically comprised of minor field, validation, or program changes. Therefore, the potential impact to users is minimal.

UI or Process-Based: Larger Scale* = These UI or process-based features have more complex designs. Therefore, the potential impact to users is higher.

Features Delivered Disabled = Action is needed BEFORE these features can be used by END USERS. These features are delivered disabled and you choose if and when to enable them. For example, a) new or expanded BI subject areas need to first be incorporated into reports, b) Integration is required to utilize new web services, or c) features must be assigned to user roles before they can be accessed.

Ready for Use by End Users
(Feature Delivered Enabled)

Reports plus Small Scale UI or Process-Based new features will have minimal user impact after an update. Therefore, customer acceptance testing should focus on the Larger Scale UI or Process-Based* new features.

Customer Must Take Action before Use by End Users
(Feature Delivered Disabled)

Not disruptive as action is required to make these features ready to use. As you selectively choose to leverage, you set your test and roll out timing.

Feature

Report

UI or
Process-Based:
Small Scale

UI or
Process-Based:
Larger Scale*

Supply Chain Orchestration

Improve Processing After Supply Chain Orchestration Updates Supply or Demand

Add Postprocessing Days When You Modify Ship Dates in Your Back-to-Back Flows

Demand Management

Demand Management

Plan at Flexible Levels for the Customer Dimension

View an Error Icon When Import from Excel Process has Errors

Export Data in Format Specified in a Planning Table

Replenishment Planning

Enable Incremental Planning for Multiechelon Replenishment Plans

Enhance Policy Calculations for Items in a Supersession Relationship

Respect Orders Planned at Subinventory Level in Buyer Planning

View and Release Rescheduled Purchase Orders from Buyer Planning

View an Error Icon When Import from Excel Process has Errors

Export Data in Format Specified in a Planning Table

Release Planned Buy Orders for Execution with Status Firm

>>Click for IMPORTANT Actions and Considerations

Supply Chain Orchestration

Improve Processing After Supply Chain Orchestration Updates Supply or Demand

Manually reduce or cancel the quantity that remains open on a transfer order or purchase order even when only part of the supply is available. Reduce the errors that might come up when you make these adjustments. Let Oracle Order Management know when Oracle Inventory Management closes a transfer order that's within the shipment tolerance but under the quantity that you requested. Use this functionality in your back-to-back flows.

Manage the response that you get from your fulfillment systems when Oracle Supply Chain Orchestration closes one transfer order but the supply order has other transfer orders that remain open. Use this functionality with your internal material transfers when you might have more than one transfer line in a single supply order.

Reduce errors and user interaction when changes are required to supply or demand.

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Manufacturing and Supply Chain Materials ManagementNo Longer Optional From: Update 24B

Key Resources

Access Requirements

The feature is available to any privilege that can create and submit a sales order.

Users who are assigned a configured job role that contains these privileges can access this feature:

  • Initiate Order (FOM_CREATE_ORDER_PRIV)
  • Submit Order (FOM_SUBMIT_ORDER_PRIV)

Users who are assigned a configured job role that contains these privileges and can create a supply order in the Supply Orchestration work area can access other parts of this feature.

  • Create Supply Request (DOS_CREATE_SUPPLY_REQUEST)
  • View Supply Line Details (DOS_VIEW_SUPPLY_LINE_DETAILS)

Add Postprocessing Days When You Modify Ship Dates in Your Back-to-Back Flows

Add postprocessing days to the supply's requested delivery date when you modify the sales order's scheduled ship date. Use this feature to help you reliably meet that ship date in your back-to-back flow.

Here's how it works:

  1. You update the sales order's scheduled ship date, then submit the sales order for scheduling and fulfillment.
  1. Oracle Global Order Promising calculates the scheduled ship date and updates the sales order. Promising adds the postprocessing days to the scheduled ship date because the shipping warehouse will need them when the item arrives at the warehouse.
  1. Oracle Order Management sends the update on the requested delivery date to Oracle Supply Chain Orchestration. The requested delivery date includes the postprocessing days.
  1. Promising subtracts the postprocessing days from the scheduled ship date to calculate the recommended requested delivery date that it sends to Supply Chain Orchestration so Supply Chain Orchestration can make the supply available in the warehouse. The warehouse manager can then do the postprocessing activities before shipping the item to the customer. For example, if the scheduled ship date is November 30, and if the postprocessing days is 5, then Promising will recommend November 25 as the requested delivery date.
  1. Supply Chain Orchestration picks the requested delivery date from Global Order Promising's recommendation, then sends an update to your downstream application, such as Oracle Manufacturing.

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Manufacturing and Supply Chain Materials ManagementNo Longer Optional From: Update 24C

Key Resources

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

  • Process Supply Order Interface (DOS_PROCESS_SUPPLY_ORDER_INTERFACE_PRIV)
  • View Supply Orders (DOS_VIEW_SUPPLY_ORDERS_PRIV)
  • Manage Supply Request Exceptions (DOS_MANAGE_SUPPLY_REQUEST_EXCEPTIONS_PRIV)
  • View Supply Order Exceptions and Status (DOS_VIEW_SUPPLY_ORDER_EXCEPTIONS_AND_STATUS_PRIV)

These privileges were available prior to this update.

Demand Management

Demand Management

Plan at Flexible Levels for the Customer Dimension

It may be desirable for your enterprise to plan at an aggregate level of the hierarchy for customers instead of at the lowest level of customer site. You can now configure the level at which a named demand plan aggregates information, such as historical sales data, and stores the forecast and other data for that plan.

This new feature may also provide performance improvement due to the reduction in the volume of data to be processed during your demand management process.

 To aggregate and store measure data at specified customer planning levels:

  • Create planning level profiles to configure customer planning levels.
  • Use the new Aggregate Collected Planning Data scheduled process after collections to aggregate and store collected measure data based on your planning level profiles.
  • In the plan options for demand plans, select a planning level profile to apply to the plan.

You can create multiple planning level profiles for use in different demand plans.

  • You can associate a planning level profile with multiple demand plans.
  • Each demand plan can have only one planning level profile associated with it.

Planning level profiles support:

  • Both predefined and user-defined customer hierarchies.
  • Multiple customer hierarchies (for example, Customer and Region.)
  • Hierarchy member changes without the need to reload collected data.
  • Exclusion of the customer dimension.

Steps to Enable

Step 1: Configure Planning Level Profiles

Use the Manage Planning Level Profiles task to configure a planning level profile. This is where you specify the customer level that you want to use for planning. If you don’t use any customer level in your planning, then you can exclude the customer dimension. You can create multiple planning level profiles with different customer levels for use in different plans.

Step 2: Aggregate and Store Collected Measure Data based on Planning Level Profiles

Run the Aggregate Collected Planning Data scheduled process to aggregate collected measure data based on your planning level profiles and store the data at the aggregate level.

Run the Create Trees for Dimensions scheduled process to create the necessary hierarchies for the members in your customer planning level.

Step 3: Assign a Planning Level Profile to Your Demand Plan

Create a new demand plan and select one of your planning level profiles in the plan options. Then run your demand plan with the Refresh with current data option selected.

After a plan has been run, you can’t select or change the planning level profile associated with the plan.

Ongoing:

Each time you collect or purge measure data (including bookings history, shipments history, and options history), entities in the customer dimension (such as customers and geographies), or customer hierarchies, you must run both the Aggregate Collected Planning Data and Create Trees for Dimensions scheduled processes.

  • You can initiate these processes manually as needed or run them on a scheduled basis.
  • If you use a job set to run your collections process, then you can add these processes to the job set.
  • You can also configure these processes to run automatically using the profile options as explained in the following section.

To set up the Aggregate Collected Planning Data and Create Trees for Dimensions scheduled process to run automatically:

Use the SCP_PARAMETER_OVERRIDES profile option to configure these processes to run automatically.

  • If the SCP_PARAMETER_OVERRIDES profile option doesn’t exist yet, then you need to create it.
  • To set the profile value: Select User for the Profile Level attribute, and then for the user name, select the application user under which all customer site level measure collection processes are run.
  • If a profile value already exists for this user, then you can append the new values after the existing value. Use either a space or a semicolon to separate values.

To automatically call the Aggregate Collected Planning Data scheduled process whenever measure data is collected via either the Collect Planning Data task or the Load Planning Data from Flat Files scheduled process, add the following to the Profile Value attribute for the SCP_PARAMETER_OVERRIDES profile option: InvokeAggregateCollectedPlanningDataFromCollection=Yes

To automatically call the Create Trees for Dimensions scheduled process from the Aggregate Collected Planning Data scheduled process, add the following to the Profile Value attribute for the SCP_PARAMETER_OVERRIDES profile option: InvokeCreateTreesFromAggregateCollectedPlanningData=Yes

Tips And Considerations

Planning level profiles are supported for only demand plans.

To select a planning level profile, you must create a new demand plan.

  • Once the plan has been run, you can’t select or change the Planning Level Profile associated with the plan.

The Load Measures from Other Plans task doesn't support demand plans with planning level profiles.

  • You can't copy a forecast from a demand plan with a planning level profile to a sales and operations plan.
  • You can't copy measures within the same demand plan if the plan has a planning level profile.

A demand plan with a planning level profile can be used as a demand schedule for a supply plan with the following limitations:

  • The Customer Site level won't be available for Measure levels or Ship-to Consumption level.
  • The Customer level will be available for Measure levels and Ship-to Consumption level if it was a selected level in the planning level profile used in the demand plan.

Planning level profiles aren't supported for demand plans that use the aggregate non-key customer data option.

Planning level profiles aren't supported for demand plans with a planning time level of Day.

The Sales Orders measure isn't populated for demand plans with a planning level profile.

The Orchestrate Refresh Measures Processes scheduled process isn't supported for demand plans with a planning level profile.

Key Resources

  • For more information about profile options, see the Profile Options section in the Oracle Fusion Cloud SCM Implementing Common Features for SCM guide.

Access Requirements

Users who are assigned a configured job role that contains this privilege can utilize the Manage Planning Level Profiles task to create, edit, and delete planning level profiles:

  • Edit Planning Level Profiles (MSC_EDIT_PLANNING_LEVEL_PROFILES_PRIV)

Users who are assigned a configured job role that contains this privilege can utilize the Manage Planning Level Profiles task to view planning level profiles:

  • View Planning Level Profiles (MSC_VIEW_PLANNING_LEVEL_PROFILES_PRIV)

Users who are assigned a configured job role that contains this privilege can assign a planning level profile to a demand plan:

  • Edit Plan Options (MSC_EDIT_PLAN_OPTIONS_PRIV)

Users who are assigned a configured job role that contains this privilege can run the Aggregate Collected Planning Data scheduled process:

  • Run Plan with Snapshot (MSC_RUN_PLAN_WITH_SNAPSHOT_PRIV)

View an Error Icon When Import from Excel Process has Errors

The ability to import data from Microsoft Excel is a popular productivity enhancing mechanism in Oracle Fusion Cloud Supply Chain Planning. With this update, error icons alert you when there are some records in the Excel file that didn’t pass validation conditions. Previously, the success icon was displayed to convey that the process was complete even if some of the records had errors. Now you see the success icon only if no rows had errors. This new error icon helps you identify and correct errors more efficiently.

For example, as soon as the Update Planning Table Data scheduled process completes with an error, the status of the icon for import will be updated to an error icon.

Status of the icon for important will be updated with error icon

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

If the Update Planning Table Data scheduled process completes with an error or warning condition, the status of the icon for import will be updated to an error icon Error icon.

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

  • Monitor Supply Planning Work Area (MSC_MONITOR_SUPPLY_PLANNING_WORK_AREA_PRIV)
  • Monitor Demand and Supply Planning Work Area (MSC_MONITOR_DEMAND_AND_SUPPLY_PLANNING_WORK_AREA_PRIV)

Export Data in Format Specified in a Planning Table

The planning table layouts in Oracle Fusion Cloud Supply Chain Planning enable you to flexibly slice and dice data per your business requirements. Sometimes your configuration of a table can result in data that exceeds the limit set for the amount of data that you can view on the page. Previously, you could export data only when it was within the limits for online viewing. With this update, you can export data even if it exceeds the limits set for online analysis, which enables you to do offline analysis with large volumes of data.

You can now export a table without opening it, so you can now export data even if it exceeds the limits set for online analysis. The exported data retains the table layout, including the positioning of dimension levels and measures in rows and columns, column and row headings, and summaries.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

You can export data in table format from:

  • The Actions button for the currently open plan
  • The Actions menu on the Manage Plans page for the currently selected plan
  • The Scheduled Processes work area by running the Export Data in Table Format process and selecting the plan and table name

The format of the export file is based on the layout of the selected table including:

  • The positioning of dimension levels and measures in rows and columns
  • Column and row headings
  • Summaries

Levels on the filter bar will be converted to columns.

All hierarchies will be fully expanded.

Member filters and measure filters configured for the table will be respected.

The export file will be:

  • An XLS file that can be opened in Microsoft Excel
  • Limited to 65,536 rows and 256 columns
  • Zipped and posted in File Import and Export
  • Named <Plan Name>_<Table Name>_<Process ID>

Conditional formatting won't be reflected in the export file.

Import of exported file isn't supported.

Access Requirements

There are no new roles or security privileges needed to access this enhancement.

  • Users who currently have access to open planning tables will automatically be able to use this feature.

Users who are assigned a configured job role that contains one or both of these privileges can access this feature:

  • Maintain Planning Tables (MSC_MAINTAIN_PLANNING_TABLES_PRIV)
  • View Planning Tables (MSC_VIEW_PLANNING_TABLES_PRIV)

These privileges were available prior to this update.

Replenishment Planning

Maintain optimum inventory levels at each node of your supply chain to meet customer service targets at the lowest inventory cost. Use automated processes to maintain inventory policy parameters and improve customer service levels. These automated processes dynamically update the inventory to keep on hand and reduce costs by calculating the economic order quantity for replenishment when appropriate.

After you opt in to the feature named Replenishment Planning, you can use the features described in this section.

Enable Incremental Planning for Multiechelon Replenishment Plans

You can configure a multiechelon replenishment plan as a net change plan by selecting the Enable for Incremental Planning plan option. By selecting this plan option, you’ll ensure that only items with changes in demands or supplies across the network are replanned. Using the incremental planning mode, you can automate your replenishment planning process.

To enable incremental planning for multiechelon replenishment plans, you must select the plan options as shown in this example:

To enable incremental planning for multiechelon replenishment plans, you must select the plan options shown in this example

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Supply Chain Planning

Tips And Considerations

If you want to use the Enable Incremental Planning for Multiechelon Replenishment Plans feature, then you must opt in to its parent feature: Replenishment Planning. If you’ve already opted in to this parent feature, then you don’t have to opt in again.

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

  • Monitor Replenishment Planning Work Area (MSC_MONITOR_REPLENISHMENT_PLANNING_WORK_AREA_PRIV)
  • Manage Segments (MSC_MANAGE_SEGMENTS_PRIV)

These privileges were available prior to this update.

Enhance Policy Calculations for Items in a Supersession Relationship

For items in a bidirectional supersession relationship, Oracle Demand Management calculates the revision start and end dates based on the item relationship’s effectivity dates. If a supersession chain has current and latest revision items with calculated start and end dates, then such items may not be effective or have forecast throughout the plan horizon.

With this update, Oracle Replenishment Planning will compute the inventory policy values for items with calculated start and end dates by considering the forecast only for the period the items are effective.

Note that the inventory policies are only computed and effective within the item revision start and end dates.

To enable enhanced policy calculation for items in a supersession relationship, you must select the forecasting profile for your plan in which you generate forecast as shown in this example:

Selecting Forecasting Profile

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Supply Chain Planning

Tips And Considerations

If you want to use the Enhance Policy Calculations for Items in a Supersession Relationship feature, then you must opt in to its parent feature: Replenishment Planning. If you’ve already opted in to this parent feature, then you don’t have to opt in again

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

  • Monitor Replenishment Planning Work Area (MSC_MONITOR_REPLENISHMENT_PLANNING_WORK_AREA_PRIV)
  • Manage Segments (MSC_MANAGE_SEGMENTS_PRIV)

These privileges were available prior to this update.

Respect Orders Planned at Subinventory Level in Buyer Planning

Oracle Replenishment Planning supports the ability to plan at subinventory level similar to organization level. With this update, Buyer Planning has visibility to planned buy recommendations at the subinventory level that Oracle Replenishment Planning generated. Using Buyer Planning, you can release these planned orders as is, or you can consolidate or group them with other planned buy orders to reduce your overall transportation cost.

With this update, planned recommendations at subinventory level will display the subinventory organization in the location column on the Buyer Planning page.

Subinventory Organization in the Location Column

Subinventory Organization in the Location Column

When you view planning recommendation for a given supplier, supplier site, and location, the inventory organization is listed as a subtitle in the page header.

Subinventory Organization in Page Header

Subinventory Organization in Page Header

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Supply Chain Planning

Tips And Considerations

If you want to use the Respect Orders Planned at Subinventory Level in Buyer Planning feature, then you must opt in to its parent feature: Replenishment Planning. If you’ve already opted in to this parent feature, then you don’t have to opt in again

View and Release Rescheduled Purchase Orders from Buyer Planning

Multiechelon replenishment planning supports the ability to reschedule purchase orders. The rescheduled purchase orders are one of reschedule in or reschedule out statuses. Buyer Planning will have visibility to the rescheduled purchase orders. You can mark the rescheduled purchase orders for release and release them to Oracle Fusion Cloud Procurement to create purchase orders. You can also edit the implement dock date to align with your business requirements.

Note that you can cancel rescheduled purchase orders by changing the implement quantity to zero.

Purchase orders follow a similar process as reviewing and releasing planned orders in buyer planning.  Purchase orders that are reschedule in or reschedule out in replenishment planning resolve to a status of Ready for reschedule in buyer planning. You can change these purchase orders to the Marked for reschedule status and edit the implement dock dates, or you can set the implement quantity to 0 to cancel a purchase order. After you're satisfied with the state of your purchase orders, you can release the plan to procurement which sets your purchase orders that were Marked for reschedule to the Rescheduled status.

Example of purchase orders for Spruce Hospitals being rescheduled on the Buyer Planning page.

  • 2 purchase orders are marked for reschedule
  • 1 purchase order is ready for reschedule

Reschedule Purchase Orders on the Buyer Planning Page

Reschedule Purchase Orders on the Buyer Planning Page

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Supply Chain Planning

Tips And Considerations

If you want to use the View and Release Rescheduled Purchase Orders from Buyer Planning feature, then you must opt in to its parent feature: Replenishment Planning. If you’ve already opted in to this parent feature, then you don’t have to opt in again

Access Requirements

Users who are assigned a configured job role that contains this privilege can access this feature:

  • Edit Supplies in Buyer Planning (MSC_EDIT_SUPPLIES_BUYER_PLANNING_PRIV)

This privilege was available prior to this update.

View an Error Icon When Import from Excel Process has Errors

The ability to import data from Microsoft Excel is a popular productivity enhancing mechanism in Oracle Fusion Cloud Supply Chain Planning. With this update, error icons alert you when there are some records in the Excel file that didn’t pass validation conditions. Previously, the success icon was displayed to convey that the process was complete even if some of the records had errors. Now you see the success icon only if no rows had errors. This new error icon helps you identify and correct errors more efficiently.

For example, as soon as the Update Planning Table Data scheduled process completes with an error, the status of the icon for import will be updated to an error icon.

status of icon for import updated to an error icon

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Supply Chain Planning

Tips And Considerations

If you want to use the View an Error Icon When Import from Excel Process has Errors feature, then you must opt in to its parent feature: Replenishment Planning. If you’ve already opted in to this parent feature, then you don’t have to opt in again.

If the Update Planning Table Data scheduled process completes with an error or warning condition, the status of the icon for import will be updated to an error iconerror icon .

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

  • Monitor Supply Planning Work Area (MSC_MONITOR_SUPPLY_PLANNING_WORK_AREA_PRIV)

Export Data in Format Specified in a Planning Table

The planning table layouts in Oracle Fusion Cloud Supply Chain Planning enable you to flexibly slice and dice data per your business requirements. Sometimes your configuration of a table can result in data that exceeds the limit set for the amount of data that you can view on the page. Previously, you could export data only when it was within the limits for online viewing. With this update, you can export data even if it exceeds the limits set for online analysis, which enables you to do offline analysis with large volumes of data.

You can now export a table without opening it, so you can now export data even if it exceeds the limits set for online analysis. The exported data retains the table layout, including the positioning of dimension levels and measures in rows and columns, column and row headings, and summaries.

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Supply Chain Planning

Tips And Considerations

If you want to use the Export Data in Format Specified in a Planning Table feature, then you must opt in to its parent feature: Replenishment Planning. If you’ve already opted in to this parent feature, then you don’t have to opt in again.

Additional Tips and Considerations:

You can export data in table format from:

  • The Actions button for the currently open plan
  • The Actions menu on the Manage Plans page for the currently selected plan
  • The Scheduled Processes work area by running the Export Data in Table Format process and selecting the plan and table name

The format of the export file is based on the layout of the selected table including:

  • The positioning of dimension levels and measures in rows and columns
  • Column and row headings
  • Summaries

Levels on the filter bar will be converted to columns.

All hierarchies will be fully expanded.

Member filters and measure filters configured for the table will be respected.

The export file will be:

  • An XLS file that can be opened in Microsoft Excel
  • Limited to 65,536 rows and 256 columns
  • Zipped and posted in File Import and Export
  • Named <Plan Name>_<Table Name>_<Process ID>

Conditional formatting won't be reflected in the export file.

Import of exported file isn't supported.

Access Requirements

There are no new roles or security privileges needed to access this enhancement.

  • Users who currently have access to open planning tables will automatically be able to use this feature.

Users who are assigned a configured job role that contains one or both of these privileges can access this feature:

  • Maintain Planning Tables (MSC_MAINTAIN_PLANNING_TABLES_PRIV)
  • View Planning Tables (MSC_VIEW_PLANNING_TABLES_PRIV)

These privileges were available prior to this update.

Release Planned Buy Orders for Execution with Status Firm

In some businesses, you may start engaging with suppliers using the output from the supply planning process prior to the release of planned orders to execution systems. If the supplier can come up with a date and quantity that’s agreeable to both parties, you can set the status of a planned order to Firm to indicate that this order shouldn’t be rescheduled.

You can release this planned order for execution to Oracle Fusion Cloud Procurement, and this firm status is carried over to the purchase requisition and then onto the resulting purchase order. You now have a closed loop process so that in subsequent planning cycles the purchase order isn’t eligible for rescheduling.

You can firm the planned order either before or after marking the planned order for release. If the planned order is firmed prior to marking the order for release, the firm status is defaulted into the implement status after the planned order is marked for release. Otherwise, you can update the Implement Firm field after the planned order is marked for release as shown in the following example.

Firm Planned Order

Firm Planned Order

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Supply Chain Planning

Tips And Considerations

If you want to use the Release Planned Buy Orders for Execution with Status Firm feature, then you must opt in to its parent feature: Replenishment Planning. If you’ve already opted in to this parent feature, then you don’t have to opt in again.

Other Tips & Considerations:

  • You aren't able to view the firm status field on a supply request or purchase requisition in the Oracle Fusion source system.
  • After collecting the Purchase Requisition entity into planning, you can view the firm status from the Plan Inputs work area.
  • You can see the firm status of a purchase order in Oracle Fusion Cloud Procurement from the Manage Schedules page. The information icon is displayed, and after you click it, you'll see the following:

Schedule firmed

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

  • Edit Supplies and Demands (MSC_EDIT_DEMANDS_AND_SUPPLIES_PRIV)
  • Mark Orders for Release (MSC_MARK_ORDERS_FOR_RELEASE_PRIV)
  • Release Planning Recommendations (MSC_RELEASE_PLANNING_RECOMMENDATIONS_PRIV)

These privileges were available prior to this update.

IMPORTANT Actions and Considerations

Changes to File-Based Data Import (FBDI) Templates

A Supply Chain Planning FBDI template has changed in this update. For details of the specific changes, refer to the Instructions tab of this FBDI template:

  • Organizations (ScpOrganizationImportTemplate)

You can find the latest template in the Supply Chain Planning section of Oracle Fusion Cloud SCM: File-Based Data Import (FBDI) for SCM, available on the Oracle Help Center.