Maximo Open Forum

Steven Shull posted 01-05-2022 16:40

Being able to add an obsolete item is definitely not intended so you won't find any options to configure it. When you say obsolete items, is it obsolete at the storeroom (inventory), Organization info (inside the Item master application utilizing the Item/Organization Details dialog), or itemset level? I tested in a 7.6.1.2 environment and it prevented me from using an item that was obsolete at the itemset level at least. I don't have access to a 7.6.0.7 environment and didn't see any APARs at a glance that were fixed between those releases. I found some older APARs like https://www.ibm.com/support/pages/apar/IV71380 & https://www.ibm.com/support/pages/apar/IV49802 that were supposedly addressed in 7.5.0 releases.

In Database Configuration, can you make sure you don't have a table domain configured on the MRLINE.ITEMNUM field? Also make sure that it has the psdi.app.mr.FldMRLineItemnum class referenced on it. 

I'd also check the relationship ITEMORGINFOSTATUS on MRLINE to make sure it looks like:

itemnum=:itemnum and itemsetid=:itemsetid and orgid=:orgid and status in (select value from synonymdomain where domainid = 'ITEMSTATUS' and maxvalue in ('ACTIVE', 'PLANNING', 'PENDOBS') )

One of the checks utilizes this relationship to validate the status so if someone changed it that might explain the difference. 

Craig Kokay posted 01-06-2022 18:17

An item that has been out into inventory will have a status in the Item application, then in the Item/Organization menu setting in the same application, and finally at the Inventory application.

If you make the Item in the Inventory application obsolete, then you can still order the item, but not if it's to replenish the store.

If you make either the item/organization or item obsolete, then you cannot reorder.

So, I'll echo Steven's commentary as we're missing some key information

Troy Brannon posted 01-07-2022 10:11

Morning Steve and Craig

Thanks for the response.

The item is obsoleted on the inventory level and I checked all of the setting you mentioned, Steve. Everything was as you described, so I don't have a clue as to what is allowing obsolete items to be place on DRs.

Steven Shull posted 01-07-2022 14:20

On the desktop requisition your users are providing that storeroom on the line (IE the STORELOC field is set to that inventory storeroom)? If the storeroom isn't provided it only looks at ITEMORGINFO.

In 7.6.1.2 at least, both the storeroom & item fields on MRLINE validate the inventory record is in a valid status when an itemnum & storeloc are provided. For the siteid it utilizes the STORELOCSITE field if that's provided on the MRLINE or uses the SITEID attribute if not.

If you have the access, I would try to enable the SQL logger for INVENTORY.INVENTORY & ITEM.ITEMORINFO to INFO to see what query is being executed. That might help pinpoint your issue. To enable this logging:

1) Go to the Logging application
2) Filter for the sql logger in the Root Loggers table
3) Add a new row for INVENTORY.INVENTORY & ITEM.ITEMORINFO in the Loggers table below
4) Set each to INFO and ensure the Active checkbox is selected
5) Save your changes
6) Use the Apply Settings option

Then create a desktop requisition with an obsolete item.

Craig Kokay posted 01-07-2022 17:49

Hi Troy.

We understand a bit more now that we have more information, so I'm going to add some more detail, but also add that it's working as per design or rather, it's also worked this way.

I have four items: CDKOBS (obsolete at the Item Master), CDKOBS2 (obsolete at the Inventory), CDKOBS3 (active at all levels), and CDKOBS4 (obsolete at the ITEM/Organization level).

In the DR the results VARY depending on what you are selecting when you are forming the Requisition Line Items, this may have resulted in some confusion.

1. Using the New Row | Select Value.  You will get only CDKOBS2, CDKOBS3, and CDKOBS4.  Now, this will result in CDKOBS2 being able to be ordered, but not for the storeroom, you made it obsolete from, CDKOBS3 being able to order including for the storeroom, and CDKOBS4 giving you an error.  For CDKOBS4, it's showing on the list because the actual item is not obsolete, only the item at the organization level.
2. Using the Select Materials button. You will get CDKOBS, CDKOBS2, CDKOBS3 and CDKOBS4. So, CDKOBS2 and CDKOBS4 will result in an error.  CDK2 you can order, just not for the storeroom, you made obsolete from.

So depending on where you're selecting the item, it will show an obsolete item, just understand obsolete at what level.  You've only mentioned that your item is obsolete in the Inventory, so all's good.  It's just that you will not be able to order it for the storeroom you made it obsolete from.  If it's active in other storerooms, you can still order for them.

• From the Select Value when using the New Row

From the Select Materials button

Troy Brannon posted 01-10-2022 09:45

Good Morning 

Thanks a lot for your assistance. Your guidance lead me to the problem and  a solution. I ended up placing a data restriction on the MRLINE STORELOC field making it required. If the item is active there is no difference in how the DR is filled out, but if the item is obsolete is causes an error.

Thanks again for your help.

Troy