Error While Updating Asset Return Status To 'Available For Sale' (Doc ID 2208271.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle Lease and Finance Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to update asset return status "Available for Sale" the following error occurs.

ERROR
-----------------------
Error while updating Asset Return Status to 'Available for Sale'


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Terminate a contract without purchase option.

Navigate to Asset return and update the status to 'Available for Lease' in Assets tab.

The following error pops up

Error creating inventory item A-Dinner12X60 in organization ATCO Structures Canada.
Error : Transaction Id = 6209762
Error : Unique Id = 6209764
Error : Table Name = MTL_SYSTEM_ITEMS_INTERFACE
Error : Column Name = ITEM_TYPE
Error : Message Name = INV_IOI_ITEM_TYPE
Error : Message Text = The ITEM_TYPE specified is not a valid Item Type or is not enabled.
Error : Transaction Id = 6209762
Error : Unique Id = 6209765
Error : Table Name = MTL_SYSTEM_ITEMS_INTERFACE
Error : Column Name = START_DATE_ACTIVE
Error : Message Name = INV_START_DATE_END_DATE_WARN
Error : Message Text = START_DATE_ACTIVE or END_DATE_ACTIVE column values will be ignored, since Item effectivity is based only on Item Status code.


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