INCOIN - Receive Error When Setting Release Time Fence Days Or Other Fields To Null in Item Open Interface (Doc ID 262817.1)

Last updated on JUNE 20, 2021

Applies to:

Symptoms

Example 1:
When setting the RELEASE_TIME_FENCE_DAYS in IOI to null the following error is generated:

TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : RELEASE_TIME_FENCE_DAYS
MESSAGE NAME : INV_IOI_RELEASE_TM_FENCE_DAYS
ERROR MESSAGE : RELEASE_TIME_FENCE_DAYS must be NULL unless RELEASE_TIME_FENCE_CODE is 4 (User Defined).

The RELEASE_TIME_FENCE_CODE is set to 5 (Do Not Auto Release)

Example 2:
Attempting to set LOT_SUBSTITUTION_ENABLED to null:

TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : LOT_SUBSTITUTION_ENABLED
MESSAGE NAME : INV_INVALID_LOT_SUB_ENABLED
ERROR MESSAGE : Lot Substitution can be enabled only if Lot Control is Full Controlled.

Cause