My Oracle Support Banner

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

Last updated on JUNE 01, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.