How to resolve INV_IOI_RELEASE_TM_FENCE_DAYS error on INCOIN? (Doc ID 1927571.1)

Last updated on DECEMBER 14, 2015

Applies to:

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

Goal

When user try's to create a new item by item import (INCOIN) with item template which has Release Time Fence = User defined time fence(4),Release Time Fence Days= Number value(Ex,1) and MTL_SYSTEM_ITEMS_INTERFACE.RELEASE_TIME_FENCE_CODE = Number value except 4(Example 5) and RELEASE_TIME_FENCE_DAYS = null, following error occurrs.

Error
-----
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 when Release Time Fence is not set to User Defined.

How to resolve this error?

Solution

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