Danny,
You may already be aware of this, but I'll toss this out just in case you aren't.
I myself am not sure about any issues with using an SQL statement to do this, I'll let someone with more experience weigh in on that, but I have gotten around the 5,000 record limit when doing other things like this by using wildcard combinations, i.e. - 1%, 2%, a%, etc., on the item number filter field to display less than 5,000 records on the screen, and then was able to use the common actions option to make the change that I needed. I would then repeat the process for another filtered set of items.
It is a little bit more time consuming, but then I didn't have to worry about causing any related issues in Maximo. Just a thought.
------------------------------
Jim Dutton
Battle Lumber Company
------------------------------
Original Message:
Sent: 02-03-2025 11:52
From: Danny Richardson
Subject: MRO: SQL to Change Cost Type in mass - Any potential issues?
Hello MORE Maximo community,
I am wanting to change the Issue Cost Type for an entire storeroom. The mass option in the UI is limited to 5,000 records and I have a lot more than that. So I was thinking I would use SQL in the database to change the Cost Type.

After an initial test, I do not see any issues, but I was curious if someone with more experience in this area might foresee any potential issues or if this is the way to go for a mass change.
Thank you in advance,
#Administration
#EverythingMaximo
#Inventory
------------------------------
Danny Richardson
Maximo Administrator Manager
Technimark LLC
------------------------------