BI Enabled Flex Field Synchronization Issue With BICCC (Doc ID 2545419.1)

Last updated on JANUARY 31, 2020

Applies to:

Symptoms

We created an Organization flex field (AXP_ERC_GL_CO_CD) with a leading space in the Name field by mistake.

This flex field is BI enabled. This Flex field name was showing a leading underscore in the OTBI Subject area as well as in Oracle BI cloud connector console PVO.                 

This leading underscore is causing issues while loading data to the Data warehouse using BICC.
Now we have corrected the Organization flex field (AXP_ERC_GL_CO_CD) to remove the leading space and re-ran the “Import Oracle Fusion Data Extensions for Transactional Business Intelligence” job.

In the BI cloud connector console the leading underscore is still showing up for this flex field and is causing the load problems.

Please provide guidance on what additional steps we must perform to synchronize the BI cloud connector with the flex field name represented in HCM Cloud.

Cause

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