Oracle Fusion Planning – Interview Questions & Answers

1. How would you approach configuring Oracle Fusion Demand Planning to support new product introductions where historical demand data is unavailable?

Answer

For a new product with no historical demand, I would use Oracle Fusion Demand Management's Manage Product Launch capability.

If the new product is similar to an existing product, I can define a relationship between the new product and a source product. Oracle allows customer-organization combinations and measure data to be copied from the source product to the new product. A factor can also be applied when the expected demand for the new product is higher or lower than the source product.

If the source product isn't suitable, Oracle allows the customer-organization combinations to be generated without using the source product's history. In that case, the forecast can be based on an already determined forecast or other available planning inputs.

After configuring the product launch relationship, I would run the demand plan again with the appropriate refresh option so the forecast can be generated for the new product.

Oracle Fusion Demand Management specifically provides functionality to optimize new product introductions and generate initial demand forecasts. (Oracle Documentation)

2. How would you configure Oracle Fusion Demand Planning to support exception-based alerts for forecast consumption issues during a monthly planning cycle?

Answer

I would use plan exceptions in Oracle Fusion Demand Management to identify significant deviations in the demand plan.

First, I would identify the appropriate predefined exception or create a user-defined exception where supported. For example, the exception could be based on a measure and a threshold that identifies a significant deviation between demand-related measures.

I would then configure the exception's level and threshold so that planners aren't presented with excessive alerts. The exception set is associated with the plan through the Plan Options.

During the monthly planning cycle, the planner can run the plan, review the generated exceptions, drill into the relevant planning views, investigate the underlying demand, and take corrective action.

Oracle states that Demand Management supports measure-based exceptions and user-defined exceptions. Exception thresholds can be configured to control how many exceptions are generated.

3. How would you configure and test Oracle Fusion Planning to support demand-driven replenishment for items with highly variable lead times across multiple suppliers?

Answer

I would configure the relevant planning parameters, sourcing information, lead times, and replenishment policies for the items and organizations involved.

The planning model needs accurate supply and demand information because Oracle Supply Planning uses factors such as customer demand, safety stock requirements, lead times, calendars, availability, and other planning parameters when calculating supply requirements.

For multiple suppliers, I would make sure the supply network and sourcing information correctly represent the available supply options.

I would then run planning scenarios using the relevant demand and supply conditions and review the resulting planned supplies, shortages, and exception messages. I would compare the results against the expected replenishment requirements and adjust the planning parameters where required.

Oracle Supply Planning calculates material and resource requirements using demand, safety stock, lead times, calendars, availability, and other parameters.

4. How would you configure Oracle Fusion Planning to automate safety stock calculations for multiple items with varying demand patterns and ensure replenishment aligns with service level targets?

Answer

I would use Oracle Fusion Supply Planning's statistical safety stock capabilities.

On the plan's Safety Stock options, Oracle provides different safety stock planning methods, including statistical safety stock for end items. When statistical safety stock is used, the calculation can use parameters defined at the item, policy, or measure level.

I would configure the Service Level Percentage according to the required customer service target. Oracle uses this value to represent the desired level of customer service in satisfying product demand immediately from inventory.

I would also configure the forecast error type used for the calculation. Oracle supports forecast error measures such as MAD and MAPE, along with other supported forecast-error options.

After running the plan, I would review the calculated safety stock quantities and the resulting supply recommendations. Where required, item-specific or policy-level overrides can be used.

Oracle documents statistical safety stock methods, service-level percentages, forecast-error types, policy overrides, and safety-stock calculation parameters.

5. You notice a product's statistical forecast in Oracle Fusion Planning is consistently overestimating demand after a major supplier change. How would you analyze and adjust the model?

Answer

I would first review the demand history being used by the forecasting process and determine whether the demand pattern has changed after the supplier change.

I would then review the forecasting profile being used for the demand plan. In Oracle Fusion Demand Management, a forecasting profile defines the forecasting methods and the level at which demand data is aggregated.

I would check the forecast results against the underlying historical demand and forecast accuracy measures. If the existing forecasting approach isn't appropriate for the changed demand pattern, I would evaluate the available forecasting methods and forecasting parameters and adjust the forecasting profile as appropriate.

I would then rerun the demand plan and compare the revised forecast with the historical demand and forecast accuracy results.

Oracle Demand Management supports statistical forecasting, forecast accuracy analysis, forecasting profiles, and multiple forecasting methods.

6. In Oracle Fusion Planning, how would you quickly identify and address statistical forecast exceptions for products with recent demand spikes?

Answer

I would use Demand Management exceptions to identify products where forecast-related measures have deviated significantly from the expected values.

I would configure an appropriate exception threshold and use the exception results to identify the affected products. I would then review the historical demand and determine whether the recent spike represents an actual change in demand or an unusual data point.

I would also review the statistical forecast and its forecast accuracy. If the demand pattern has changed, I would review the forecasting profile and its forecasting methods and parameters.

After making the required planning adjustments, I would rerun the demand plan and compare the updated forecast and exception results.

Oracle Demand Management provides exceptions for identifying significant demand changes and allows thresholds to be configured for exception generation.

7. In Oracle Fusion Planning, how would you configure exception thresholds to balance between minimizing false alerts and ensuring critical supply-demand issues are not missed?

Answer

I would start by identifying the business conditions that represent a meaningful planning problem and then configure the exception threshold and level accordingly.

A threshold that is too low can generate a large number of exceptions and make it difficult for planners to identify the important issues. A threshold that is too high can prevent meaningful deviations from being highlighted.

In Oracle Fusion Planning, exception thresholds can be edited through the Configure Exceptions task. For measure-based exceptions, the threshold is evaluated against the relevant base measure. The level at which the exception is calculated can also be configured where supported.

I would test the exception configuration against representative planning results and adjust the threshold based on the business requirement.

Oracle specifically notes that increasing an exception threshold typically reduces the number of exceptions generated.

8. In Oracle Fusion Planning, how would you review and adjust exception rule configurations after a plan run fails to identify a critical stockout risk?

Answer

I would first review the plan's exception results and determine why the stockout condition wasn't identified.

I would check the exception definition, calculation level, threshold, and the data used by the exception. For measure-based exceptions, I would verify that the correct base measure and threshold are being used. For supply planning exceptions that are order-based, I would review the relevant order-related condition and threshold.

I would also verify that the appropriate exception set is associated with the plan. Oracle requires an exception set to be included in the plan options for the exceptions to be generated.

After making the required configuration changes, I would rerun the plan and verify that the stockout condition is now identified.

Oracle allows exception sets to control which exceptions are generated, while exception configuration allows relevant levels and thresholds to be adjusted.

9. During monthly planning, a spike in demand causes shortages across several locations. How would you use MRP/DRP in Oracle Fusion to rapidly rebalance inventory and maintain service levels?

Answer

I would run the appropriate Supply Planning plan to recalculate supply and demand based on the latest planning inputs.

The plan can identify material shortages and recommend new supplies or changes to existing supplies. Depending on the supply network, the planning process can recommend replenishment through purchases, manufacturing, or transfers.

For a multi-organization environment using Distribution Requirements Planning, I would review the supply requirements across the relevant organizations and the resulting replenishment recommendations. I would then review the plan's exception messages to identify shortages that require immediate attention.

Oracle Supply Planning can balance supply and demand, recommend new supplies, recommend rescheduling or cancellation of existing supplies, and identify material shortages. Oracle item planning attributes also support MPP Planning for scenarios involving Distribution Requirements Planning across multiple organizations.

10. How do you configure MRP/DRP in Oracle Fusion Planning to handle multi-tier supply chains and ensure timely replenishment across all levels?

Answer

I would first make sure the planning model correctly represents the multi-level supply chain, including organizations, items, sourcing relationships, lead times, calendars, and other relevant planning parameters.

For items requiring material requirements planning, Oracle provides MRP planning as an item planning method. For environments where Distribution Requirements Planning is required across multiple organizations, Oracle supports MPP Planning.

I would configure the relevant sourcing and planning parameters and ensure that planning data is correctly collected before running the supply plan.

The plan can then calculate material requirements and replenishment requirements across the supply network. I would review planned orders, transfers, shortages, and exception messages to verify that replenishment is being generated at the appropriate level.

Oracle documentation identifies MRP Planning for dependent-demand items and MPP Planning for scenarios involving Distribution Requirements Planning across multiple organizations.

11. What factors must be considered when mapping demand and supply data between Oracle Fusion Planning and the Inventory, Manufacturing, and Order Management modules for accurate plan execution?

Answer

I would focus on making sure that the planning model receives consistent and timely data from the Fusion SCM execution modules.

For demand, Oracle Supply Planning can receive information such as sales orders from Order Management and shipment history from Inventory Management.

For supply, planning data can come from Inventory Management, Manufacturing, and Purchasing.

I would therefore validate:

• Item and organization alignment

• Demand and supply dates

• Quantity and unit-of-measure consistency

• On-hand and incoming supply information

• Manufacturing supply information

• Sales-order demand

• Transfer and sourcing information

• Data collection status and timing

I would also validate the collected planning data before relying on the resulting supply plan. Incorrect or incomplete collected data can directly affect the plan's demand, supply, and replenishment recommendations.

Oracle documents Order Management sales orders and Inventory Management shipment history as demand sources, while Inventory Management, Manufacturing, and Purchasing provide supply data for Supply Planning.

12. When integrating Fusion Planning with Inventory and Manufacturing, how do you handle changes in item master data to ensure planning accuracy across modules?

Answer

I would make sure that the item master changes required by planning are correctly reflected in the planning data and that the relevant planning attributes are consistent.

For example, changes to an item's planning method, planning parameters, lead times, safety stock settings, sourcing information, or manufacturing-related structures can affect planning results.

I would collect the updated planning data and validate that the item and organization combinations are correctly available to the planning process. For manufacturing scenarios, I would also verify that the relevant product structures and supply information are consistent with the planning model.

After the changes are collected, I would run the relevant plan and review the resulting planned orders, supply recommendations, and exceptions to confirm that the updated item information is being used.

Oracle Supply Planning relies on collected demand and supply data, while item planning attributes determine how individual items are planned. Oracle specifically provides planning methods such as MRP, MPS, MRP and MPP, MPS and MPP, MPP, and Replenishment Planning.

Hope This Helps . Happy Learning