Last updated on MARCH 08, 2017
Applies to:Oracle Inventory Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
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,
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.
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