Regenerating Business Views Creates Views With Column Names With Suffixed With Numbers (Doc ID 1362744.1)

Last updated on JANUARY 16, 2024

Applies to:

Symptoms

After modifying Descriptive Flexfields, regenerating Business Views creates views with column names with suffixed numbers.

Steps
-----
-Generate Business Views,
-Modify Additional Assignment Details DFF,
-Regenerate Business Views by running concurrent request, 'Generate Business Views By Descriptive Flexfield'
for Human resources Application and PER_ASSIGNMENTS DFF field.
p_DF_Appl_Short_Name => 'PER'
p_Desc_Flex_Name => 'PER_ASSIGNMENTS'
This program calls an API, BIS_VIEW_GENERATOR_PVT
.
Notice change in column names of HRBG_ASSIGNMENT view
Ex:
1-Before regeneration, HRBG_ASSIGNMENT had column names like AAD_LOCAL_POSITION_TITLE, AAD_GLOBAL_POSITION_TITLE.
2-Now assume the DFF has been changed, with attribute13 as Local Position Title and attribute2 as Legacy Local Position Title.
3-After regenerating Business Views the column names have changed to AAD_LOCAL_POSITION_TITLE_1, AAD_GLOBAL_POSITION_TITLE_1.
.
The regenerated view should have had aad_local_position_title as there is still a DFF attribute with that name.

Changes

Modified existing flexfield segments and regenerated business views.

Cause

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