My Oracle Support Banner

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 later
Information 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


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