Error ORA-01400: cannot insert NULL, Unable to Assign The Manufacturing Number To The Item Because Of Null Organization ID

(Doc ID 2173959.1)

Last updated on AUGUST 19, 2016

Applies to:

Oracle Item Master - Version 12.2.3 and later
Information in this document applies to any platform.


On : 12.2.3 version, Item Issues

When attempting to add Manufacturing Part Number to Item,
the following error occurs.

ORA-01400: cannot insert NULL into

The issue can be reproduced at will with the following steps:
1) Inventory responsibility
2) Navigate to > Item > Master Item
3) Query for the Item number> Click Tools>Manufacturers part numbers


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms