Issue : Inactive PO Item Categories are appearing in Approved Supplier List window for selection
While creating Approved Supplier List for Commodity ( PO Item Category ) the list of values for Commodity field show Categories which are end dated in Item Categories form ( INVIDCAT Form ).
Enabled field in Item Categories form ( Navigation : Purchasing Super User > Setup > Items > Categories > Category Codes ) is not allowing us to update ( uncheck ).
For testing we updated this field through SQL ( update mtl_categories_b set enabled_flag='N' where category_id=308 and structure_id=201 ) , after executing the update script , the Approved Supplier List form stops showing the Commodity.
It would be a great help If you guys can share your knowledge on how to make Enaled field unprotected ( or updatable )
Only solution we see now is allowing user to remove/uncheck Enabled field to stop the Commodity appearing in Approved Supplier List form.
Even when the Commodity is end dated , Approved Supplier List form Commodity field still allow selection of Commodity for creating Approved Supplier List.
This seems to be an intended Oracle functionality.
Please log Oracle SR for a datafix/patch.
End Dated Category Code Still Displays In (OEXOEBSO) Blanket Sales Order Form LOV [ID 1454115.1]
Able To Assign A Category To A Supplier Even If That Category Was Inactive [ID 1346571.1]