Asset Number Import Failes When Importing Only Asset Attributes (Doc ID 1433019.1)

Last updated on NOVEMBER 01, 2016

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance 4-April-2015***

Symptoms

When attempting to import asset attributes only (import_scope = 2), the following error occurs:

CASE 1. import with mode = 0 returns:
In mtl_eam_asset_num_interface:
ERROR_CODE: 150
ERROR_MESSAGE: Asset insertion failed with return status: E and message: EAM

CASE 2. import with mode = 1 returns:
In mtl_eam_asset_num_interface:
ERROR_CODE: 300
ERROR_MESSAGE: Failed because Extensible Attributes import failed
In MTL_EAM_ATTR_VAL_INTERFACE
ERROR_NUMBER: 9999
ERROR_MESSAGE: Attribute Group does not exist


The issue can be reproduced at will with the following steps:
1. populate the asset numbers interface tables
2. run import asset numbers program
3. errors returned

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