Flexfield Compilation Error for PO Vendors DFF

(Doc ID 2387866.1)

Last updated on APRIL 18, 2018

Applies to:

Oracle Purchasing - Version 12.2.7 and later
Information in this document applies to any platform.

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

 

Changes

 

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