Disabled Buyer, No Default Buyer Displayed In Master Item (Doc ID 1590529.1)

Last updated on SEPTEMBER 07, 2021

Applies to:

Symptoms

We have a buyer that has been disabled in the system that was still the default buyer on over 16,000 rows and will need to have a datafix that will update these to a new default buyer. 

This is an issue because no requisitions are being created automatically from the min/max process thus the buyer doesn't know when to order these parts because of the issue.

Identified the parts from the following query...

select m.segment1, m.organization_id, p.organization_code, m.inventory_item_id,
      m.description,buyer_id, m.last_update_date
from apps.mtl_system_items_b m,mtl_parameters p
where buyer_id = 765
and m.organization_id = p.organization_id;

Steps to reproduce the problem ###
Go to inventory responsiblity
Go to master items
Query item 1607-117
Go to purchasing tab and notice buyer field is blank. If you query from sql you will see the buyer id is from the disabled buyer.

Cause

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