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.

Symptoms

On : 12.2.3 version, Item Issues

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

ERROR
-----------------------
ORA-01400: cannot insert NULL into
("INV"."MTL_MFG_PART_NUMBERS"."MANUFACTURE_ID")


STEPS
-----------------------
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

Cause

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