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 FEBRUARY 25, 2021

Applies to:

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


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.


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

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