My Oracle Support Banner

ORDSKU_HTS_ASSESS Is Not Getting Inserted Properly Through Purchase Order Induction Process (Doc ID 2567200.1)

Last updated on AUGUST 25, 2022

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.


In Retail Merchandising System (RMS),  ORDSKU_HTS_ASSESS is not getting inserted properly through Purchase Order (PO) induction.
Harmonized Tariff Schedule (HTS) assessments getting inserted only for the first sequence and not all sequences , it should insert for all the sequences i.e all the sequences from the ORDSKU_HTS table.

Example:  Say ORDSKU_HTS is having 10 sequences (1,2,3...10) but PO induction is getting created for the ORDSKU_HTS_ASSESS only for the sequence 1 not for all the remaining sequences.

Steps to Recreate:

  1. Make sure that Items does not have any records in ITEM_HTS and ITEM_HTS_ASSESS table.
  2. PO induction should be created using external reference no.
  3. Make sure that Order has multiple cost components and not just TEXP.  Ex (200,55,AFT6P5,BUYCOMM,E02INLDFRE,UNCST)
  4. Observe that ORDSKU_HTS_ASSESS is getting populated only for the first sequence and not for all.


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.