Performance Issue Using Asset Number Import Program
(Doc ID 2124139.1)
Last updated on FEBRUARY 15, 2019
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
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.
They should be able to load more than 300K per hour.
Created index on BATCH_ID of mtl_eam_asset_num_interface table but performance was worse.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document