My Oracle Support Banner

FA:SCM:OM: How Substitute Item Will Be Picked at Sales Order Line When There Is More Than One Defined? (Doc ID 2743010.1)

Last updated on APRIL 17, 2024

Applies to:

Oracle Fusion Planning Central Cloud Service - Version 11.13.20.10.0 and later
Oracle Fusion Order Management Cloud Service - Version 11.13.19.07.0 and later
Oracle Fusion Distributed Order Orchestration - Version 11.12.1.0.0 and later
Oracle Fusion Product Hub Cloud Service - Version 11.13.17.05.0 and later
Information in this document applies to any platform.

Goal

Q1)How are item substitutes ranked in the MISC_ITEM_SUBSTITUTES Table?

Q2)Which substitute item will be selected when create a sales order for Item?

Q3)What is the RANK column under MSC_ITEM_SUBSTITUTES table and can it be populated?

Item X has 3 Item substitutes setup under TAB Relationships>Related Item in Product Hub. Three items have been created as substitute items a,b,c.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.