Rajesh Somisetti
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;
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)