AIP-Online Batch: Performance Issue Executing external_load.load_profile

(Doc ID 2393228.1)

Last updated on MAY 01, 2018

Applies to:

Oracle Retail Advanced Inventory Planning - Version 15.0.2 and later
Information in this document applies to any platform.


Loading table "store_sku_release_schedule_exc" using standard GA procedure "external_load.load_profile" has poor performance. The process runs for 20 minutes to load 75 million records from interface table (I_EXT_PROFILE) to base table (store_sku_release_schedule_exc). A projected full volume of 150 Million records would scale this job to 40 minutes which is considered too long.




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