Step Material Association "ORA-01400:cannot insert NULL into "GMD"."GMD_RECIPE_STEP_MATERIALS"."FORMULALINE_ID" (Doc ID 2200162.1)

Last updated on DECEMBER 12, 2016

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version,

When attempting to add step material association in the Recipe with status
new the following error occurs.

ERROR
-----------------------
' ORA-01400:cannot insert NULL into
("GMD"."GMD_RECIPE_STEP_MATERIALS"."FORMULALINE_ID)"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Define new Recipe in Formulator responsibility .
2. Choose step material Association and enter the required details .
3. When try to save the line , Error is thrown .



Changes

 

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