HTS Attached to Items Not Updated While Uploading Via Htsupld

(Doc ID 1618154.1)

Last updated on DECEMBER 08, 2015

Applies to:

Oracle Retail Trade Management - Version 13.2.4 and later
Information in this document applies to any platform.

Symptoms

Running RMS 13.2.4 and finding that Harmonized Tariff Schedule (HTS) attached to items are not being updated when uploaded via htsupld.

Steps to reproduce:
1. Before upload HTS 0706901000, Start date 01-JANUARY-2013, End date 30-APPRIL-2013
2. Upload file for HTS 0706901000, Start date in file: 01-OCT-2013, End date in file: 31-DEC-2013
3. Expected result would be two records in HTS, HTS_TARIFF_TREATMENT and ITEM_HTS tables.
    One record with old dates, and another record with new dates.
    However all the expected tables were updated, except ITEM_HTS table

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