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

Last updated on MARCH 08, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

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

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