INCOIN Item Open Interface Completes In Warning With Message "START_DATE_ACTIVE or END_DATE_ACTIVE column values will be ignored ..." (Doc ID 400874.1)

Last updated on SEPTEMBER 07, 2016

Applies to:

Item Master - Version: 11.5.10
This problem can occur on any platform.
EXECUTABLE:INCOIN - Import Items

Symptoms

When attempting to create master or organization items through the Item Open Interface ("IOI", INCOIN), the concurrent requests complete in Warning.
Items get imported but the following message is raised in the request log:

************************************
TRANSACTION ID : <transaction_id>
ORGANIZATION ID : <organization_id>
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : START_DATE_ACTIVE
MESSAGE NAME : INV_START_DATE_END_DATE_WARN
ERROR MESSAGE : START_DATE_ACTIVE or END_DATE_ACTIVE column values will be ignored, since Item effectivity is based only on Item Status code.
************************************

Steps:
The issue can be reproduced at will with the following steps:
1. Load master or organization items into the open interface table.
2. Launch Item Open Interface.
3. Check the results:
- items were successfully imported,
- concurrent request completion status is Warning,
- the above reported message is shown in the request log.

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