Unable disallow transactions in material status
Dear friends,
We would like to disallow certain transactions for Quarantine status ("QUAR") in "Define Material Status" screen but system is generating following error
"Cannot update status. On hand inventory or inventory location exist with QUAR".
We have searched through for this issue and found following Oracle Note to resolve this issue.
We opted for Workaround 2.
Workaround #2:
1. First change the status of the onhand records and lots to something else (some dummy status, For ex: "TempStatus") and make sure that this status ("Quarantine") is not tied to any other entity. Follow steps 1-4 below to mass update the onhand records to the new status. Uncheck the reservation flag of the status ("Quarantine"). Then, you can update the status of the onhand records back to the status ("Quarantine").