Flexfield Compilation Error for PO Vendors DFF (Doc ID 2387866.1)

Last updated on MARCH 02, 2023

Applies to:

Symptoms

On : 12.2.7 version, Setups

In the Requests forms, see request 'Flexfield View Generator' is completed with error for PO Vendors DFF.

ERROR
-----------------------
You have a segment, &SEG1 in context Global Data Elements, whose name maps to the same view column name as the context prompt.
The view generator uses underscores ( _ ) to replace all characters in the segment name that are other than alpha
CREATE OR REPLACE VIEW PO_VENDORS_DFV
AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE
FROM SYS.DUAL


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Go to General Ledger Super User - Setup – Financials – Flexfields - Segments, set the DFF as  below:

Application=Purchasing
Title=Vendors

Context Field:
Prompt=XXX

Context Filed Values:
Code=Global Data Elements
Name='XXX'  (Here, set the name to the same value as  above context Prompt value)

2. Go to Requests form and submit request 'Flexfield View Generator', then it completes with error.

3. In the Request log file, see below information:

You have a segment, &SEG1 in context Global Data Elements, whose name maps to the same view column name as the context prompt.
The view generator uses underscores ( _ ) to replace all characters in the segment name that are other than alpha
CREATE OR REPLACE VIEW PO_VENDORS_DFV
AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE
FROM SYS.DUAL

Cause

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