How to Make a DESCRIPTIVE FLEXFIELD (DFF) Attribute Disable or Read Only using Special Value Set in Oracle apps EBS R12

How to Make a DESCRIPTIVE FLEXFIELD (DFF) Attribute Disable or Read Only using Special Value Set in Oracle apps EBS R12

Step1 :    Create a Special Value set
    Like this
    Nevigation >> Application Developer
    >> Application >> Validation >> Set

Value Set Name :    XXKAL_DFF_ATTRIBUTE_READ_ONLY

 

 

Edit	FND SQL "BEGIN
	NULL;
	END;"
Validate	FND SQL "BEGIN
	NULL;
	END;"

Step2:	After Create Value set , We will attched this value set to make Appropriate DFF Attribute Disable or Read Only
Step3:	How to Find DESCRIPTIVE FLEXFIELD Atthched in the Header or Line Level at Any Module in Oracle apps.
Step 3-a	Here I have Take Purchase Orders Screen to find the Header DFF.
	Process is
	Open the Purchase Orders Screen
	Then go to the Help >> Diagnostics >> Examine

Then Select the

Block =  $DESCRIPTIVE_FLEXFIELD$

Field = PO_HEADERS.DESC_FLEX

Value = PO Headers (Purchasing)

Here Value = PO Headers (Purchasing) means

PO Headers = Title

Purchasing  = Withen Bracket is Application Name

Step 3-b	Nevigation >> Application Developer
	>> Flexfield >> Descriptive >> Segments

First Uncheked the Freeze Flexfield Definition

	Then Select on the Appropriate Context Field Values and then Click on Segments
Step 4:	Attached the Value Set (We are make at the Above )=XXKAL_DFF_ATTRIBUTE_READ_ONLY
	to the particuler DFF Attribute for make Disable or Read Only.
	(Ex: Here We Used ATTRIBUTE8 = XXKAL_DFF_ATTRIBUTE_READ_ONLY) to make Disable or Read Only.

Step5:

After Save then cheked the Freeze Flexfield Definition. Then Save again

Step6:	Finally We Checked the Purchase Orders Header DFF
	for Disable or Read Only
	(Ex: Here We make 'Budget Limit Exceed Flag' Disable or Read Only)

DFF Flex field Query to find attributes to find DFF Flex field attributes

SELECT ffv.application_table_name, ffv.descriptive_flexfield_name,

ffv.context_column_name, ffv.title, att.application_column_name,

att.end_user_column_name, att.column_seq_num, att.enabled_flag,

att.required_flag, att.security_enabled_flag, att.display_flag,

att.flex_value_set_id, att.form_left_prompt, ffv.*

FROM fnd_descriptive_flexs_vl ffv, fnd_descr_flex_col_usage_vl att

WHERE ffv.descriptive_flexfield_name =  att.descriptive_flexfield_name

AND ffv.descriptive_flexfield_name = 'PO_HEADERS'

--AND (ffv.title) = 'Purchasing'