Performance issue while loading ITEM_HTS file in Data Conversion
(Doc ID 2713231.1)
Last updated on OCTOBER 15, 2020
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version 19.0 and later
Information in this document applies to any platform.
Performance issue while running the item_hts taking 17 minutes for 1 item when expenses are set up in system.
Steps to recreate:
- Login to Data Conversion(DC) utility.
- Import the file by selecting entity ITEM_LOCATION_RANGING.
- Click on Data validation by selecting the process Id.
- Click on Business validation by selecting the process Id.
- Observe that it is taking long time to complete the ranging due to huge records in ITEM_HTS table.
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