Unable To Create Multiple Planning Details And Customer Reference For 'Substitute' Item Relationship Using MTL_RELATED_ITEMS_PUB API

(Doc ID 2179381.1)

Last updated on SEPTEMBER 04, 2016

Applies to:

Oracle Item Master - Version 12.2.4 and later
Information in this document applies to any platform.


On : 12.2.4 version, Item Relationship Issues

Using MTL_RELATED_ITEMS_PUB API there is no provision to specify the Plan_info_id to create a Customer Reference for planning detail when multiple planning details are available in the same Substitute Relationship.
System is attaching all Customer References to all planning details.

There should be a provision/ method to attach a customer reference to corresponding planning detail.

The issue can be reproduced at will with the following steps:

For example

Relation Between two inentory_item_ids is as follows

inventory_item_id ->1179304
related_item_id ->1377313
relationship_type_id -> 2 (substitute)

For the above relation there are two planning details TEST_SET1, TEST_SET2
For TEST_SET1 -> we have 2 customer references.
For TEST_SET2 -> we have another 2 customer references.

If using API MTL_RELATED_ITEMS_PUB.process_rel_item - we cannot achieve the above requirement.
System is assigning all the 4 customer references to both planning details which is not desired behavior.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms