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