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 |