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 JANUARY 07, 2016

Applies to:

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

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

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