1.

Is There Anyway To Revert Items Back To 'a'ctive Status When They Have Been Accidentally Set To Pending Delete?

Answer»

When an item is deleted from itemmaster screen, the item_master.STATUS for that item will still be what it was PREVIOUSLY. If Active, item_master.status will still be 'A'. However, it will have a record in DAILY_PURGE. Whatever items those are in DAILY_PURGE will have status in the itemmaster screen as 'DELETE Pending'. We do not have a form/process/functionality within RMS to remove the item from *Delete Pending*. Item will be deleted from the tables during dlyprg.pc batch run. But it will have to GO through some validations before it can be deleted. Those that failed VALIDATION will not be purged and an entry will be inserted into DAILY_PURGE_ERROR_LOG. If you do not want to delete the item, you can remove the corresponding record from DAILY_PURGE and DAILY_PURGE_ERROR_LOG tables.

When an item is deleted from itemmaster screen, the item_master.status for that item will still be what it was previously. If Active, item_master.status will still be 'A'. However, it will have a record in DAILY_PURGE. Whatever items those are in DAILY_PURGE will have status in the itemmaster screen as 'Delete Pending'. We do not have a form/process/functionality within RMS to remove the item from *Delete Pending*. Item will be deleted from the tables during dlyprg.pc batch run. But it will have to go through some validations before it can be deleted. Those that failed validation will not be purged and an entry will be inserted into DAILY_PURGE_ERROR_LOG. If you do not want to delete the item, you can remove the corresponding record from DAILY_PURGE and DAILY_PURGE_ERROR_LOG tables.



Discussion

No Comment Found