AIP Online: retl_load.import_closed_order Has Performance Issues

(Doc ID 2347004.1)

Last updated on JANUARY 09, 2018

Applies to:

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

Symptoms

===ODM Issue Clarification===
Customer states the ret_load.import_closed_order is take unacceptable amount of time to complete. 17500 records in 45 mins. The issue is due to the lack of an index on allocation_number in the allocation table. By adding the index, the job runs in 5 seconds.

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