The Descriptive Flexfield Attribute Column ID Does Not Match The Column Name Label (Doc ID 2961915.1)

Last updated on SEPTEMBER 26, 2023

Applies to:

Symptoms

User wanted the column name in BICC to be more descriptive to identify the column but it is showing "USF_INVESTMENT_VEHICLE" instead of  "USF_NVSTNT_VHCL_"

STEPS
1. Create the descriptive flexfield segment
    Setup and Maintenance > Manage Incentive Descriptive Flexfields > Create Global Segment and Deploy Flexfield
        Flexfield Code = CN_TP_BASETRANS_DFF ( Base Transaction )
        Name = USF Investment Vehicle
        Code = USF Investment Vehicle
        API Name =usfInvestmentVehicle
        Table Column = ATTRIBUTE22
        BI Enable = Yes

2. Submit process  "Import Oracle Fusion Data Extensions for Transactional Business Intelligence" with ERP option

3. Create BI Analysis using "Incentive Compensation - Transactions Real Time" subject area.
    Select column "USF Investment Vehicle" and view the Column formula and it shows "Source Transaction Details"."CN_TP_BASETRANS_DFF_USF_NVSTNT_VHCL_"

4. Review BICC ( Oracle Business Intelligence Cloud Connector Console https://<server>/biacm/faces/setup )
    Search :
        Offering = Incentive Compensation
        Data Store =FscmTopModelAM.TransactionDFFBIAM.FLEX_BI_TransactionDFF_VI
    Drill down on the Data Store in the result and click on [ Select Columns ] shows :
        Column Name             Label                        
        USF_NVSTNT_VHCL_   USF Investment Vehicle

Cause

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