My Oracle Support Banner

Table Names Are Populated Incorrectly In ITEM_HTS Entity (Doc ID 2870916.1)

Last updated on AUGUST 16, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 to 19.3 [Release 19.3]
Information in this document applies to any platform.

Symptoms

Through the new API , load of ITEM-HTS entity user observed that conv_validation_error is populated with wrong table name for ITEM_HTS entity. It gives table name as SVC_ITEM_HTS_ASSESS whereas the correct table name would be CONV_ITEM_HTS_ASSESS. Please help in correcting the same.

select count(1),error_msg,table_name
from conv_validation_error er,conv_item_hts h
where er.process_id=177
and er.process_id=h.process_id
and er.row_seq=h.row_seq
and er.chunk_id=h.chunk_id
group by error_msg,table_name

Cause

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
Symptoms
Cause
Solution
References


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