Flexfield View Generator Completes In Error With More Than 256 Columns (Doc ID 2182777.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Object Library - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Goal

Flexfield View Generator completes in error

Whenever the DFF is compiled the program ends in error.

Steps to Replicate:
1. Unfreeze the DFF
2. Add a segment value to an existing context
3. Freeze the flexfield
4. Compile the flexfield
The DFF is compiled successfully but the program Flexfield View Generator completes in the following error.

**********************************************************
The flexfield view generator cannot create a view with more than 256 columns.

Your descriptive flexfield contains more than 253 uniquely named segments. Change the names of some of your context-sensitive segments so that they share names

View Name: HCCMRO_IWB_ITEM_ATTR_VAL_DFV (or another view ending with _DFV)

 

Solution

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