My Oracle Support Banner

SVC_ITEM_MASTER_CFA_EXT Remains With Status N After Barcode Item Is Created Using RIB XItem (Doc ID 2897717.1)

Last updated on SEPTEMBER 22, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

On : NA version, Operations & Maintenance

ACTUAL BEHAVIOR
---------------
SVC_ITEM_MASTER_CFA_EXT remains with Status N after barcode item is created using RIB XItem (stage)

In MFCS, table SVC_ITEM_MASTER_CFA_EXT remains with PROCESS$STATUS N after a new Item message to create a barcode (XItemCre) is sent through RIB.

The barcode item and CFA are created successfully but the SVC_ITEM_MASTER_CFA_EXT PROCESS$STATUS remains in "N". This causes new messages to fail.

EXPECTED BEHAVIOR
-----------------------
PROCESS$STATUS should move to P - Processed

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1 - Create Custom Flexible Attributes for Item (define group, groupset, attribute, ...) and enable it
2 - Create a transactional item without any barcode
3 - Send a XItemCre message for the barcode and include the CFA in the message
4 - The barcode is created with CFA in MFCS
5 - Notice the PROCESS$STATUS for the barcode remains in status "N" in table SVC_ITEM_MASTER_CFA_EXT - Expected status is "P"

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.