My Oracle Support Banner

ItemSuppCountry and ItemSuppCountryDim Records Are Not Getting Created in RMS When Publishing Message Through PublishXItemSupCreateUsingXItemDesc (Doc ID 1966475.1)

Last updated on MAY 16, 2022

Applies to:

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


Publishing message through publishXItemSupCreateUsingXItemDesc is not adding country record to ITEM_SUPP_COUNTRY, ITEM_SUPP_COUNTRY_DIM table.

1. Run Item Supplier Create message which inserts a record in ITEM_SUPPLIER table and nothing inserted in ITEM_SUPP_COUNTRY table nor ITEM_SUPP_COUNTRY_DIM table.
2. Run Item Supplier Country Create message which fails to insert record in case the message is including DIM data.
Error code [E] Could not update database record. Program: ITEM_SUPP_COUNTRY_SQL.UPDATE_ISC_DIM Table: ITEM_SUPP_COUNTRY_DIM Item: 00045000003187 Supplier: 90000004 Origin_Country: US
3. If DIM data is removed from the latest message then it will run successfully inserting a new record in ITEM_SUPP_COUNTRY 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

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