My Oracle Support Banner

Inconsistent Behavior In CFA Configurations - CFA_ATTRIB_GROUP_LABELS has no DEFAULT_LANG_IND (Doc ID 3047466.1)

Last updated on SEPTEMBER 13, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 24.1 to 24.1 [Release 24.1]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Inconsistent behavior in CFA Configurations when the default language <> 1

After loading the CFA configurations we observe the following inconsistencies :
- CFA_ATTRIB_GROUP_LABELS has no DEFAULT_LANG_IND set to Y
- CFA_ATTRIB_LABELS has DEFAULT_LANG_IND set to Y for lang = 1



EXPECTED BEHAVIOR
-----------------------
CFA_ATTRIB_GROUP_LABELS and CFA_ATTRIB_LABELS should have DEFAULT_LANG_IND set to Y where LANG is the same as DATA_INTEGRATION_LANG

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load the CFA configurations via ODS
2. Execute the following queries (example figures);
select count(*) from CFA_ATTRIB_LABELS where DEFAULT_LANG_IND = 'Y'; --> 8
select count(*) from CFA_ATTRIB_LABELS where DEFAULT_LANG_IND = 'N'; --> 72
select count(*) from CFA_ATTRIB_GROUP_LABELS where DEFAULT_LANG_IND = 'Y'; --> 0
select count(*) from CFA_ATTRIB_GROUP_LABELS where DEFAULT_LANG_IND = 'N'; --> 42

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.