Disabled Buyer, No Default Buyer Displayed In Master Item
(Doc ID 1590529.1)
Last updated on APRIL 03, 2025
Applies to:
Oracle Inventory Management - Version 11.5.10.2 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |