Performance Issue Using Asset Number Import Program (Doc ID 2124139.1)

Last updated on APRIL 07, 2016

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
Users are having a performance issue when submitting the Asset Number Import to import millions of assets into Oracle eAM. It is inserting nearly 6000 assets per hour. For loading, 25 million.

EXPECTED BEHAVIOR
-----------------------
They should be able to load more than 300K per hour.

Changes

 Created index on BATCH_ID of mtl_eam_asset_num_interface table but performance was worse.

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