Fusion Apps, Unable To Deploy DFF And EFF, "All rows in FND_DF_FLEX_USAGES_B table must exist in FND_DF_FLEX_USAGES_TL table for all installed languages" (Doc ID 2131975.1)

Last updated on MAY 02, 2016

Applies to:

Oracle Fusion Distributed Order Orchestration - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to deploy various flexfields :
EGP_SYSTEM_ITEMS_DFF
DOO_FULFILL_LINES_ADD_INFO
PER_LOCATIONS_DFF

the following error occurs.

ERROR
-----------------------
Validating flexfield PER_LOCATIONS_DF of Application 800 ...
1. ERROR: Validating Flexfield Metadata : Violations found. See complete report :
+===============================================================================
| Code : DFF.F.IN_B_NOT_IN_TL
| Type : ERROR
| Tables: FND_DF_FLEXFIELDS_B, FND_DF_FLEXFIELDS_TL
| Rule : All rows in FND_DF_FLEXFIELDS_B table
| must exist in FND_DF_FLEXFIELDS_TL table
| for all installed languages
| Check : Rows in FND_DF_FLEXFIELDS_B table
| but not in FND_DF_FLEXFIELDS_TL table
+===============================================================================
1 violation found
Application: APPLICATION_ID/APPLICATION_SHORT_NAME/APPLICATION_NAME
--------------------------------------------------------------------------------
Descriptive Flexfield: FLEXFIELD_TYPE/DESCRIPTIVE_FLEXFIELD_CODE/NAME
--------------------------------------------------------------------------------
Language: LANGUAGE_CODE/INSTALLED_FLAG/NLS_LANGUAGE/NLS_TERRITORY
--------------------------------------------------------------------------------
WHO: FND_DF_FLEXFIELDS_B
--------------------------------------------------------------------------------
WHO: FND_LANGUAGES
--------------------------------------------------------------------------------
800/PER/Global Human Resources
DFF/PER_LOCATIONS_DF/Location Attributes
F/I/FRENCH/FRANCE
CD:2014/10/28 06:48:04, CB:SEED_DATA_FROM_APPLICATION, LUD:2014/10/28 06:48:04,

LUB:SEED_DATA_FROM_APPLICATION, LUL:-1
CD:2014/10/28 05:04:49, CB:SEED_DATA_FROM_APPLICATION, LUD:2016/04/26 22:12:00,

LUB:FAAdmin, LUL:316ABD8F5D88BEFAE0530A05038AAE09
+===============================================================================
| Code : DFF.FU.IN_B_NOT_IN_TL
| Type : ERROR
| Tables: FND_DF_FLEX_USAGES_B, FND_DF_FLEX_USAGES_TL
| Rule : All rows in FND_DF_FLEX_USAGES_B table
| must exist in FND_DF_FLEX_USAGES_TL table
| for all installed languages
| Check : Rows in FND_DF_FLEX_USAGES_B table
| but not in FND_DF_FLEX_USAGES_


 
The issue can be reproduced at will with the following steps:
1. Navigate to Mange Descriptive Flexfields and deploy the DFFs.
2. Get the error indicated above.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms