MERCHAPI_EXT_ITEM Tables Recording Item CFA Attributes Multiple Times
(Doc ID 2925790.1)
Last updated on MAY 11, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 22.1 and laterInformation in this document applies to any platform.
Symptoms
When using the Item Publish API, an item is having it's CFA's published multiple times to the MERCHAPI_EXT_ITEM_MASTER_CFA table and in the JSON message on the MERCHAPI_EXT_ITEM table. In this case, it was written 3 times for the 3 attributes.
Steps to reproduce:
1. Enable Item Publish API with at least one consumer.
2. Run MERCHAPI batch to populate the MERCHAPI_EXT_ITEM* tables.
3. Create and approve a regular txn-level item with 3 CFA attributes.
4. Verify records on ICL_RMS_ITEM_MASTER for each enabled consumer.
5. Run MERCHAPI batch to populate the MERCHAPI_EXT_ITEM* tables for the unprocessed ICL records.
6. Verify results on MERCHAPI_EXT_ITEM* tables.
Changes
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 |
Changes |
Cause |
Solution |
References |