SKU With Only One Ref Item but primary_ref_item_ind is N (Doc ID 2940032.1)

Last updated on APRIL 06, 2023

Applies to:

Symptoms

SKU with only one ref item but primary_ref_item_ind is N (that should be Y by default if it is the only child for a SKU) as seen by executing the below query:

select * from rms01.item_master where item_parent in (
select item_parent
from item_master
where item_level =3 and tran_level = 2
group by item_parent having count(*) = 1)
and primary_ref_item_ind = 'N';

Steps To Recreate:
1.For an item, define 2 child items (UPC) - one will be primary and the other non-primary.
2. Using sopaui, delete the primary UPC.
3. Execute daily purge
4. Notice that the only UPC item associated to the SKU has primary_ref_item_ind set to 'N/.

Cause

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