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;
Posted by Rajesh Somisetti at 23:50 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

About Me

Rajesh Somisetti
View my complete profile

Blog Archive

  • ►  2017 (2)
    • ►  September (1)
    • ►  July (1)
  • ►  2016 (8)
    • ►  September (1)
    • ►  May (1)
    • ►  February (2)
    • ►  January (4)
  • ►  2015 (18)
    • ►  October (1)
    • ►  September (4)
    • ►  July (2)
    • ►  June (2)
    • ►  May (1)
    • ►  April (1)
    • ►  February (3)
    • ►  January (4)
  • ▼  2014 (21)
    • ►  December (3)
    • ►  November (2)
    • ►  October (4)
    • ▼  September (1)
      • ORA-01400: cannot insert NULL into ("INV"."MTL_MAT...
    • ►  August (3)
    • ►  July (3)
    • ►  June (1)
    • ►  March (2)
    • ►  February (2)
Simple theme. Powered by Blogger.