Tuesday 2 September 2014

ORA-01400: cannot insert NULL into ("INV"."MTL_MATERIAL_STATUS_HISTORY"."UPDATE_METHOD") in Package INV_MATERIAL_STATUS_PKG Procedure Insert_Status_history



When you encounter an ORA-01400 error, the following error message will appear:
  • ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE_NAME"."COLUMN_NAME")
--> In this scenario ("INV"."MTL_MATERIAL_STATUS_HISTORY"."UPDATE_METHOD")
we need to  pass  UPDATE_METHOD :=2;

l_status_rec.UPDATE_METHOD :=2;

No comments:

Post a Comment