AIP Online: retl_load.import_closed_order Has Performance Issues
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.
===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.
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