Unable To Create Multiple Planning Details And Customer Reference For 'Substitute' Item Relationship Using MTL_RELATED_ITEMS_PUB API
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:
Relation Between two inentory_item_ids is as follows
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
Million Knowledge Articles and hundreds of Community platforms