My Oracle Support Banner

Issue While Uploading HTS Setup Into ORMS (Doc ID 2918695.1)

Last updated on JULY 25, 2023

Applies to:

Oracle Retail Trade Management - Version 16.0 and later
Oracle Retail Merchandising System - Version 16.0.3 to 16.0.3 [Release 16.0]
Information in this document applies to any platform.


Issue while uploading HTS setup into ORMS.

Steps to reproduce:
1. Make sure there are entries in CONTRY_TARIFF_TREATMENT table with effective_to date in the year 2099.(country_id: LR, LT)
2. Download the HTS setup template.
3. Remove data from all the sheets except for country_tariff_treatment.
4. In the country_tariff_treatment sheet retain only those entries which have effective_to in the year 2099.
5. Set the action as Update and upload the template.
6. Note the below error occurs.

"The effective to date must be greater than the effective from date."


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.