Asset Suite / PassPortGeek

I015 allows MR deletion of MRs in CANCEL or INPROG status. This shouldn't be relevant as an MR has to be approved to create a Purchase Requistion.

Client should verify that the MRs that appear to be deleted are in sequence with their existing MRs, i.e., the missing MR numbers are holes in the sequence of I010 Material Request numbers. This would confirm that the MR existed at one time. Are MRs being assigned via an Oracle SEQUENCE or the TIDNMBRS table? If Oracle SEQUENCE is in use then the assigning of MR number is probably not the culprit.

If the MR existed at one time, check if the MR appears on other business entities like a Purchase Requisition. This might give an indication of when the MR is being deleted.

Is EZ MR in use and if so, were the missing MRs created via EZ MR? The reason I'm asking this is because the I010 panel is heavily used and it and its subroutines are unlikely to have a bug as large as the incorrect deletion of MRs.

Search baseline PassPort code for deletions from TIDMRMST.
cd ../passport10/source/csm
Use Unix: find . -type f -print | xargs grep "TIDMRMST"
finds: tigi015c.csm, tigmrmst.csm
This is an inconclusive search as it depends on the code being written as: DELETE FROM TIDMRMST, but Ventyx's coding is pretty well standardized.
The 2 programs can be modified to remove the possibility of deleting MRs. This shouldn't have too much of a business impact and the code could be put back once the problem is found.

Look for custom code and/or jobs that manipulate MRs, especially check tigi010.ccp and tigi015.ccp.

Program tigi015c.csm deletes AAAs from tables TIDALARD and TIDALARH while tigmrdtl.csm cancels AAAs. If cancelled AAAs can be found referencing the missing MRs, it would be an indication that tigmrmst.csm and tigmrdtl.csm are being used to do the deletions. I can't think of where baseline PP would do this which would lead me to search for custom code that calls them to do the deletion.

select * from tidalarh
where route_list_type = 'M/R'

The I015 was the culprit. On this panel you can delete a MR and it is still referenced on the pick. We will work on securing this panel from now on.