My Oracle Support Banner

When Query_Only is set to Yes on the Fnd_FNDFFMDC form one can compile a Descriptive Flexfield (Doc ID 1219306.1)

Last updated on DECEMBER 23, 2023

Applies to:

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


When the parameter of the Defined Descriptive Flexfield segments form - FND_FNDFFMDC - is set to Query_Only = "Yes" and the form is opened, the compile button of the form is active, and will after a few tries
allow the flexfield that is queried to be compiled and a view created.


The steps used to make the form readonly are as follows:
Create custom function based on the standard FND_FNDFFMDC with parameters QUERY_ONLY="YES" (No other changes). This function is then attached to a custom menu and then to a custom responsibility
When the Define DFF segments form - FNDFFMDC - is opened, the Compile button is active, if the flexfield is FROZEN and this is unacceptable. Eventually, after a series of error messages the flexfield compiles and a view is created.


To view full details, sign in with your My Oracle Support account.

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

In this Document

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